CODEWITHSUNDEEP
reporting-servicesreport
Dennis Ferron
Dennis Ferron

Reputation:

How can I suppress blank pages in SQL Reports?

I have a SQL Report that insists on printing an extra blank page at the end, even though all the report items should fit on one page. I tried shortening the elements on the page that is spilling over, but no matter how much I compress them, or how much blank space is left on the first page, SRS still thinks it needs to take up another page as well. This is annoying because it's such a common problem - all it takes is one mistake to make a report spill over. So I'm not asking how can I fix this on this one report, but how can I fix this on this and future reports: Is there a flag or setting I can set to tell SRS "No matter what, never print more than 1 page"? Or "Suppress blank pages = true"?

Upvotes: 10

Views: 24960

Answers (4)

user12927593
user12927593

Reputation: 1

Also, look at headers & footers. I was focused on the central part of the report getting all of the columns smaller, but it was a footer that caused the issue.

Upvotes: 0

Jamie
Jamie

Reputation: 281

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.

Upvotes: 23

Biruk Tilahun
Biruk Tilahun

Reputation: 21

use ConsumeContainerWhitespace to TRUE in the Report Properties its FALSE by default

Upvotes: 1

Russ Wilson
Russ Wilson

Reputation:

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!

Upvotes: 12

Related Questions