This is an easy way to help you layout your reporting services reports so that they print on paper without unwanted blank pages.
This is a simple method to add construction lines to your report. When you enable them, you can see borders round teh previously invisible sections. If you previously got unexpected blank pages, you may find that with the borders being visible, sections of your report are just overlapping the next page. Here's how:
I created a new boolean parameter @debug, default false to allow me to easily show and hide the borders. Next, for the parts of the report I'm interested in, I set a border colour - the items I added a colour to were: Body, List, Header, Footer.
For each section, I then set the BorderStyle to:
=iif(Parameters!Debug.Value=true,"Dotted","None")
or
=iif(Parameters!Debug.Value=true,"Dashed","None")
Now when I run the report, I choose if I want to see the prodcution report (left) or the debug report (right).
Keywords: Reporting Services, Blank Page, Debug
