SSRS thesterious extra pages

reporting-servicessubreport

I have two reports that are setup with the same page dimensions- A4 portrait, with page margins of 1cm.

When I run the reports seperately and print them they both come out as expected: fitting into the width constraint of the page.

However, when I include one report as a subreport in the other and then run and print the "master" report I start to experience problems. Even though both reports appear I get extra blank pages appearing every other page in the output.

I'm sure I'm missing a simple trick – probably with the page sizes of the two reports but I can't figure it out – any pointers?

I don't mind changing the setup of the subreport as it will never be run as a seperate eport in the wild, I only included that step to prove that it did indeed fit within the page!

Best Answer

One thing that might help is to set your right margin to 0 in your master report. I've noticed this myself with a subreport that appears correctly in a master report, and adding it as a subreport in another master causes it to insert extra page breaks. I agree with TheTXI, its very frustrating, I wish they had a debug/inspection mode like firebug does for web pages.

Edit: Also you should check your fields to make sure they aren't set to expand automatically (unintended). Right click, properties, set .CanGrow = False

Related Topic