Welcome to MSDN Blogs Sign in | Join | Help

Services Rendered

An Insider's Look into the World of SQL Server Reporting Services Report Rendering
The "Every Other Page Is Blank" Feature

Many Reporting Services users ask this question:

"I'm rendering to a physical page format (PDF, Image, Print) and for some reason a blank page gets inserted between all of the other pages in the report.  Thank you, Reporting Services, for the free pages.  It's a charming feature, but paper ain't free and I'm getting paper cuts pulling out every other blank page after it's printed.  How do I make it stop?!"

To which I reply:

This is almost always caused by the Body of your report being too wide for your page.  Make sure that the Width of the Body is less than the physical page size, less the margins.  For those of you who are into the math thing, make sure that:

Body Width <= Page Width - (Left Margin + Right Margin)

For physical page renderers, it's important to keep in mind the concept of Usable Area.  The Usable Area is the amount of space left on a page for your report to be drawn after reserving space for margins, headers and footers, and column spacing (for multi-column reports).

Horizontal usable area:

X = Page.Width - (Left Margin + Right Margin + Column Spacing)

Vertical usable area:

Y = Page.Height - (Top Margin + Bottom Margin + Header Height + Footer Height)

Any time objects on your report (including the Body itself) extend past the usable area either because they are defined like that or because they grow at runtime, the physical page renderers have no choice but to break onto a new page.

Let me know if there are more questions about this.

Published Thursday, August 10, 2006 6:32 PM by chrisbal

Comments

# re: The "Every Other Page Is Blank" Feature @ Monday, August 14, 2006 9:12 AM

I need to render my reports in html before printing, I've tried playing with the page size, margins and interactivesize property values but I can't get the report to display correctly in html.  Typically the report will have more or less page count or will add white space that doesn't show when the report is exported to pdf.  Can you help me with this?

Thanks,
Jacque

JSM

# re: The "Every Other Page Is Blank" Feature @ Tuesday, February 20, 2007 2:21 PM

Hello,

HTML and PDF rendering is fundamentally different for many reasons.  Pagination between interactive formats such as HTML and physical-page bounded formats such as PDF is never guaranteed to be the same.  As for the whitespace issue, it could be because HTML does not support overlapping report items and PDF does.  Overlapping items in HTML will be repositioned to resolve the overlap, which may push other items around as a result.

-Chris

chrisbal

# re: The "Every Other Page Is Blank" Feature @ Thursday, March 08, 2007 4:03 AM

I've found that if you want your report to pront properly on an A4 page , the width should not be more than 16-17 cm ( depending on margins )

Regarding the HTML / PDF rendering issue , I just want to add that you should always deploy and test your reports on the server , not just look at it in the Visual Studio renderer and think it's ok !

VS uses a different renderer and sometimes the HTML renderer will produce different results.

Thavash

# re: The "Every Other Page Is Blank" Feature @ Thursday, March 08, 2007 10:07 AM

What are the defaults for the device information settings for PDF rendering (especially the margins)?

Is there an exeception thrown if I pass a faulty devInfo string when using the render method from VB?

alexcook

# re: The "Every Other Page Is Blank" Feature @ Friday, April 27, 2007 7:49 PM

I've built a report that have many columns but have parameters that set the visibility of each. When i only have a few columns visible, the pdf report shows blank pages, As if those hidden columns are taking up spaces. Any ideas?

marvinbaby@hotmail.com

# re: The "Every Other Page Is Blank" Feature @ Friday, May 25, 2007 4:51 PM

I have that problem too, and it isn't the horizonal width causing it.  It won't go away!

EricT

# re: The "Every Other Page Is Blank" Feature @ Thursday, March 13, 2008 9:48 AM

I have a problem that I'm hoping you could help me with.  I am generating reports that need to be printed on a roll feed receipt printer without viewing them first.  This I have accomplished.  

The problem that I have however is this:  If the report body length is less than the pageHeight set in the DeviceInfo it cuts off the slip at the end of the report which is fine, but when the report body is longer than this it cuts the report in two or more pages.  

I need the full report to print on one continuous slip that only cuts of at the end.  If I don't specify a pageHeight property in DeviceInfo it stretches the shorter reports to the full length of the page which is about 3 meters.  Is there a way to set the pageHeight to the height of the report body?

Daniel Oosthuizen

# re: The "Every Other Page Is Blank" Feature @ Thursday, September 04, 2008 2:36 AM

Awesome help provided by you. Really appreciate it

coolathrt

# re: The "Every Other Page Is Blank" Feature @ Monday, December 29, 2008 12:42 PM

excellent!! I was struggling with this issue all the week and it was just the width!! nice tick, thanks chrisbal

benjarras

# Services Rendered The Every Other Page Is Blank Feature | Quick Diets @ Tuesday, June 09, 2009 6:52 AM

PingBack from http://quickdietsite.info/story.php?id=10624

Services Rendered The Every Other Page Is Blank Feature | Quick Diets

Anonymous comments are disabled
Page view tracker