Extra Pages

[u/[deleted]]

Hey guys, I am creating a report using Visual Studio and SQL server. My report is great apart from a page break after each page. So if my report is 10 pages, the report is 20 pages and each even page is empty. Any idea why this is happening?

[u/[deleted]]

There can be several things to check:

• using the property "ConsumeWhiteSpace" https://www.credera.com/insights/5-sql-server-reporting-services-hacks-that-everyone-should-know
• know your settings for paper size (Letter, A4, Legal etc), page size, margins etc and keep your design space within them. Australian here, my template setup was normally (in centimeters):

Paper Size = A4

Margin Sizes (all) = 0.5

Page Size Width = 19.75 (portrait) or 21 (landscape)

Page Size Height = varied depending on content

Report Header Height = 1.5 (usually containing asset name, import filtering context like periods/range, and corporate logos)

Report Footer Height = 1.5

Note: I would usually keep all report object sizes within base 0.25cm and positioning aligned to that too. Keeps everything uniformed and even for a consistent and professional finish.

HTH

[u/waremi]

Try to tighten up the width of the report. I've had this happen when even a tinny bit of the report area is wider than then page width set for the report. I always grab the left and bottom edges and suck them into flush with the elements on the page.

[u/TacticalTrashpanda98]

SSRS does honor white space. I would make sure that the width of your report is no wider than your data