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 3, 2013 1:17 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 3:17 PM
Points: 252, Visits: 757
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 3, 2013 10:18 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, December 4, 2014 7:54 PM
Points: 3,087, Visits: 2,686
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 7, 2013 10:34 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 3:17 PM
Points: 252, Visits: 757
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 7, 2013 11:02 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 3:17 PM
Points: 252, Visits: 757
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