Showing posts with label generate. Show all posts
Showing posts with label generate. Show all posts

Sunday, February 19, 2012

Blank pages when printing

Hi - I am generating a table with large amounts of data. When I generate the
report, the report looks fine but when I print preview it, every alternating
page is blank with only the header and footer being displayed on every page.
I have tried playing around with the page breaks with no luck. Is there a
way, maybe programmaticaly to set page breaks and stop my report from having
blank page between data page? Or what might be causing the alternate blank
pages with header/footer?
thanksHello ISGADMIN,
I had a real time myself at first with plank pages as I am sure a lot of
designers did, but all you need to do is make sure the design grid, margin
settings and data regions fall within boundaries when designing. If you have
a one inch margins on the R and L in Landscape settings (11 X 8.5 in the
Report Properties) for example, the design area and all objects on it need
to fall under 10 inches on the ruler. You may have to tweak with the
measurement for the actual grid to get it just right, but it will work.
--
Rodney Landrum - Author, "Pro SQL Server Reporting Services" (Apress)
http://www.apress.com
"ISGADMIN" <isgadmin@.newsgroup.nospam> wrote in message
news:C1D58BC4-D257-4052-AAB6-10BE7BEE21E2@.microsoft.com...
> Hi - I am generating a table with large amounts of data. When I generate
> the
> report, the report looks fine but when I print preview it, every
> alternating
> page is blank with only the header and footer being displayed on every
> page.
> I have tried playing around with the page breaks with no luck. Is there a
> way, maybe programmaticaly to set page breaks and stop my report from
> having
> blank page between data page? Or what might be causing the alternate
> blank
> pages with header/footer?
> thanks|||Have you considered re-creating the report? Or copy & paste the RDL File,
and start deleting objects from it. Perhaps one of the objects is taking a
full new page.
"ItSGADMIN" wrote:
> Hi - I am generating a table with large amounts of data. When I generate the
> report, the report looks fine but when I print preview it, every alternating
> page is blank with only the header and footer being displayed on every page.
> I have tried playing around with the page breaks with no luck. Is there a
> way, maybe programmaticaly to set page breaks and stop my report from having
> blank page between data page? Or what might be causing the alternate blank
> pages with header/footer?
> thanks|||Hi isgadmin,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

blank pages in reports through subscriptions

I have Reporting Services 2005 wsp1, SQL Server 2005 version 9.00.2047. When
I generate reports through Reports Admin interface and then export them to
PDF, they come out ok. When I set up a subscription that is supposed to send
a report in pdf format - I get the same report with around 50 blank pages
inserted in it.
Anybody ran across the same stuff?On Mar 2, 11:39 am, "ilona" <ilona_scramb...@.no-go.com> wrote:
> I have Reporting Services 2005 wsp1, SQL Server 2005 version 9.00.2047. When
> I generate reports through Reports Admin interface and then export them to
> PDF, they come out ok. When I set up a subscription that is supposed to send
> a report in pdf format - I get the same report with around 50 blank pages
> inserted in it.
> Anybody ran across the same stuff?
I've had some problems with this before...I would try to eliminate any
unused space in the report designer area and check your page
setting...
Cheers,
-Ben