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

printing blank page every other page Expand / Collapse
Author
Message
Posted Wednesday, June 24, 2009 6:13 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 19, 2012 3:54 PM
Points: 12, Visits: 86
I created a report that prints a blank page every other page. The blank page registers as a printed page because my global pageno shows the page number at the bottom. I've tried changing my layout margins and that doesn't seem to want to stop the blank page from printing. I usually do not develop the reports to print, but, this particular one needs to. Any advice on how to trouble shoot? Oh yea, I also setup the report to print in landscape by changing the page width and heights to 11 by 8.5.

Thanks,

Marc
Post #741460
Posted Thursday, June 25, 2009 7:35 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, May 24, 2012 10:02 AM
Points: 339, Visits: 639
You're on the right track, this is because your report is too wide. You have to verify three things to get printing to work: page size, margins and the width of the Body.

Go to the drop-down at the top of the Properties window and choose Body. The Size will tell you how how large your working area is, and the width is constrained by the position and size of the fields in your report. The Body width + Left margin + Right margin determines how wide the page is, and you're likely over 8.5.


Are you lost daddy? I asked tenderly.
Shut up he explained.

- Ring Lardner
Post #741815
Posted Friday, June 26, 2009 10:54 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 19, 2012 3:54 PM
Points: 12, Visits: 86
Thank you! I didn't even think to check the body size. Once I saw that it was over the width of my page and adjusted it, that fixed my problem.

Marc
Post #742864
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse