all groups > sql server reporting services > october 2005 >
You're in the

sql server reporting services

group:

Blank Pages following report


Blank Pages following report Rick via SQLMonster.com
10/31/2005 10:17:39 PM
sql server reporting services: I have a report that uses 7 subreports. Some reports show, some don't
depending on the data received from the Shared Datasource. My initial report
appears fine in the viewer, however I have a single page following the last
page with data containing only the header. When I create a pdf, I have 4
pages at the end with only headers. The main report and the first subreport
should be the only ones outputting data.

Ideas?


--
Message posted via SQLMonster.com
Re: Blank Pages following report Rick via SQLMonster.com
11/1/2005 8:50:01 PM
I have found my problem, but no solution. When the subreports run, they are
given "space" on the report even if their visibility is set to False. This
is what is generating my "blank pages". This poses a new and even uglier
issue for me, What Now? My requirements are to have a single report that
gives alternate data depending on the needs of the user. I have two ideas:

1) Can I manually launch a subreport in code WITHOUT navigating away from
the parent report?

2) Is it possible to dynamically add a Subreport to the main report via VB
Code so only the subreports needed are run?

I am researching both avenues, but any advice you could offer would be WELL
received!

[quoted text, click to view]


--
Re: Blank Pages following report manish
11/2/2005 2:30:07 PM
I am also running into the same issue and finding no solution. Any help is
appreciated.

[quoted text, click to view]
Re: Blank Pages following report manish
11/8/2005 12:28:52 PM
Has Microsoft any answer to this problem as this is something has been faced
by many people and doesnt seem to find any solution.
Setting page size and margine is one part of avoiding blank pages but with
sub reports, it not only introduce blank pages and sometimes change the whole
look of the report.

[quoted text, click to view]
Re: Blank Pages following report Rick via SQLMonster.com
11/15/2005 12:00:00 AM
This is a good question, I see this issue often on many boards I post to. In
this case, it was my error. I was setting sub reports to hidden, however the
Rectangle they were in were not being set to hidden. Hence the blank pages.
When I set the Rectangle to invisible, it works like a charm. If you run
into this issue, I suggest you look at the container you placed your Sub
Report in, that just might be your error.

[quoted text, click to view]

--
Message posted via SQLMonster.com
Re: Blank Pages following report patuww
11/15/2005 2:00:05 PM
Also, if you set the subreport (or its container) to be invisible
conditionally, any pagebreaks selected for that subreport or container
will be ignored. For me, it is a really anoying "feature".
AddThis Social Bookmark Button