SSRS mysterious extra pages

Question

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!

Answer 1

There is probably an overhang somewhere with your page size or margins that is causing it to spill over into blank pages. They can be infuriating to find sometimes.

Answer 2

See page 12 of this document (.doc download) : http://tinyurl.com/5pxzeq

Answer 3

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