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

Page Header Expand / Collapse
Author
Message
Posted Thursday, October 03, 2013 1:17 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:12 PM
Points: 170, Visits: 509
My report has only one table that populates perfectly on the first page.
But when I export the report to a pdf it shows 4 pages instead of 1 .3 extra pages of page Header.

Kindly advise.
Post #1501327
Posted Thursday, October 03, 2013 10:18 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:07 PM
Points: 2,844, Visits: 2,427
Check the dimensions of the report (in BIDS, click somewhere in the report and check the width of the body) and the dimensions of the page that you using (e.g. in the report properties you will have the width and height.

If the actual report width is wider than the page width, you will get extra "blank" pages.



Post #1501412
Posted Monday, October 07, 2013 10:34 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:12 PM
Points: 170, Visits: 509
Setting the margins did help. But now I get one extra(Last) page in the pdf.
It only shows header.


How can i get rid of this?
Post #1502259
Posted Monday, October 07, 2013 11:02 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:12 PM
Points: 170, Visits: 509
No Worries,

I changed all margins(Top, Bottom,Left,Right) to 0 and it worked.

Post #1502272
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse