I always get asked about printing in Reporting Services. The 2 issues are always
1) Printing in Landscape in Reporting Services
2) After creating reports , when printed or exported to PDF you get blank pages.
Lets talk about the blank pages first. What I’ve found when authoring reports , is that when you are creating portrait reports ( reports that should either print on a normal A4 page , or be exported to a PDF file ) make sure that the report width is not more than 16 cm’s. Sometimes a report author has a table or matrix that is short enough , but still gets the extra blank page. Thats because the report width is greater than 16 cm’s. What you need to do is remove all the extra space at the right of the report. This is normally the cause of the "Extra Blank Pages" that you see when you print or export to PDF.
The above illustrates a report where the actual table is less than 16 cms but the report width is not. You will still get extra blank pages when you print this or export to PDF. Make sure therefore that there is no extra space after the table on the right ( if not needed ).
The other way to control the report width is on the Report Properties Tab.
This is a useful window, lots of properties to set here
Which brings me to the Landscape Printing option. To set your report to always print / export in Landscape mode, you need to go into the report properties box , select the Layout tab and inverse the Width and Height ie. The normal settings are 21cm for Page Width and 29.7cm for Page Height. Swop these around and you should get a Landscape Report.
The above image shows the same report exported to PDF after the change is made. Easy as pie…….