Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Blank pages in print preview and pdf format view Expand / Collapse
Author
Message
Posted Tuesday, September 8, 2009 6:53 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 2, 2014 7:13 AM
Points: 45, Visits: 151
Hi,

Pls find attached file and let me know changes.

Thanks.


  Post Attachments 
kam_ Monthly_Invoice.rar (9 views, 332.93 KB)
Post #784200
Posted Friday, September 18, 2009 7:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 9:56 AM
Points: 30, Visits: 306
Hi,

To avoid Blank pages in PDF

In BIDS, do the following:
1. Click on Report > Report Properties > Layout tab
2. Make a note of the values for Page width, Left margin, Right margin
3. Close and go back to the design surface
4. In the Properties window, select Body
5. Click the + symbol to expand the Size node
6. Make a note of the value for Width
To render in PDF correctly Body Width + Left margin + Right margin must be less than or equal to Page width. When you see blank pages being rendered it is almost always because the body width plus margins is greater than the page width.
Remember: (Body Width + Left margin + Right margin) <= (Page width)


Thanks,
Nemo
Post #790352
Posted Monday, December 14, 2009 9:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 14, 2009 9:53 AM
Points: 1, Visits: 0
contactatif (5/7/2009)
Guys in SSRS 2008,

Very important property that can be easily ignored here is: ConsumeContainerWhitespace property of the Report. This is set to False by default, So the whitespace is not ignored by the renderer and is repeated on next page. Setting this to True solved all my Extra Blank Page problems in SSRS 2008.

Cheers.


now, my report is working like a charm.
It helped me a lot.

many thanks!
Post #833969
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse