Showing posts with label subreport. Show all posts
Showing posts with label subreport. Show all posts

Sunday, February 19, 2012

Blank pages in print preview for sub reports

Hi,

I have serveral subreports in main report. I have no problem print the orignal report but when I print them as subreport so get extra blank pages. I try to set the width of sub report in main report the max width value (19.6 cm width) without succeed. Any help would be appreiciate!

Hi,The extra blank page is coming for the Page Layout that you set for your report.Decrease the Left Margin and right margin percentage and try to move your Textbox fields bit closer to each other from right side and remove the extra space left on the right side of your report just draging it towards left.Hope this will solve your problem.|||Hi,In Sql report the preview take extra space for the extra width that you give to your report.So remove the extra width from your report.Do not increase the default width of the report by draging it towards right.Hope this will solve your problem.

Regards
Gelu

Blank Pages generated after the subreport

Hi,

I am very new to SSRS. I developed a report which has two subreports in it. Blank page is generated at the end of each Page. Can any one help me how to avoid this.

try to reduce the spacing between the sub report components on the main page - It needs some trail and error

Thursday, February 16, 2012

Blank page when using subreport

I have a subreport on a SRS report. When I run the subreport by itself,
there is no problem. But when I run the main report it always generates a
blank page as page one.
Any help pinpointing the problem would be greatly appreciated!
Thanks,
BobOn Sep 11, 9:28 am, "Bob Bridges"<m...@.here.com> wrote:
> I have a subreport on a SRS report. When I run the subreport by itself,
> there is no problem. But when I run the main report it always generates a
> blank page as page one.
> Any help pinpointing the problem would be greatly appreciated!
> Thanks,
> Bob
Make sure that you are not setting a page break for grouping. The best
way to condense down this space is to include this subreport inside a
rectangle control. Of course, there's always including the subreport
as a table/etc in the main report, which sometimes due to complexity
of layout requirements, is necessary. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

blank page between the main report and a subreport when exporting to PDF.

When I create a report that has imbedded subreports there are occasions
when I get a blank page between the main report and a subreport, this
occurs when exporting to PDF. From what I have observed; if a
subreport contains more rows of data than can fit on the same page as
the main report then a page break occurs a blank page is inserted and
then the subreport comes out on the subsequent page. This behavior will
not be repeated until the same condition occurs again.When the result
sets from the main report and subreport can fit on one page there is no
problem in exporting to PDF. In HTML format I get the report as
expected with no blank pages..PDF rendering is picky. You have to make sure that the body width does not
exceed, not even by 1 pixel, the (page width - (left margin + right
margin)).
--
Adrian M.
MCP
"Tom" <tom_barnard@.aotx.uscourts.gov> wrote in message
news:1112137446.997763.245800@.l41g2000cwc.googlegroups.com...
> When I create a report that has imbedded subreports there are occasions
> when I get a blank page between the main report and a subreport, this
> occurs when exporting to PDF. From what I have observed; if a
> subreport contains more rows of data than can fit on the same page as
> the main report then a page break occurs a blank page is inserted and
> then the subreport comes out on the subsequent page. This behavior will
> not be repeated until the same condition occurs again.When the result
> sets from the main report and subreport can fit on one page there is no
> problem in exporting to PDF. In HTML format I get the report as
> expected with no blank pages..
>|||Adrian,
We have checked the body width and found no problem there. Could
something else be causing this?
Thanks,
Tom|||This same situation happened to me. I found that two of the subreports had
matrices in them with extra white space to the right of the matrix. The extra
pages were eliminated when I removed this white space.
I hope this helps!
-Jason
"Tom" wrote:
> When I create a report that has imbedded subreports there are occasions
> when I get a blank page between the main report and a subreport, this
> occurs when exporting to PDF. From what I have observed; if a
> subreport contains more rows of data than can fit on the same page as
> the main report then a page break occurs a blank page is inserted and
> then the subreport comes out on the subsequent page. This behavior will
> not be repeated until the same condition occurs again.When the result
> sets from the main report and subreport can fit on one page there is no
> problem in exporting to PDF. In HTML format I get the report as
> expected with no blank pages..
>