How can I suppress blank pages in SQL Reports?

In my experiene, it has ALWAYS been that the data I have on the report page is WIDER than the page margins, so it thinks it needs to make a new page... check the margins of your pages and also how far the data is extending on it. It may not appear that it is to far in the report designer, but I would bet that's the answer. We're talking PIXELS here, so check that out and see if it helps!


Try removing any 'empty space' from the body. Shrink the editing surface to be just large enough for all your ReportItems, both height-wise and width-wise. ReportingServices thinks the space you have in your body is intentional, so it's preserved.

If that doesn't help and you're noticing this issue on 2005, give the 2008 version a try. There's a new property, ConsumeContainerWhitespace that helps reduce blank pages.