< Blog

How to Set the Page Size for a ConfigMgr Report

By Garth Jones

You took the time to make sure that your report fits perfectly onto a landscape-sized letter page (11 x 8.5 inches) or an A4 (210 x 297 mm). When you run the report on your SSRS site the report looks great as shown below. Then something happens…

How to Set the Page Size for a ConfigMgr Report-Report on SSRS Site

When you export or print the report it gets split over two pages. The report wasn’t designed to be split like that! Notice how the report is shown on two pages in the screenshot below.

How to Set the Page Size for a ConfigMgr Report-Report Split Over Two Pages 

This begs the question, “How do you fix this?”

The answer is actually very simple. When reports are created, the default report size is 8.5 x 11 inches for the printed page size. You can see this by reviewing the Report Properties within SQL Server Data Tools (SSDT). Note: These same attributes also exist in Report Builder (RB) and SQL Server Business Intelligence Development Studio (BIDS).

How to Set the Page Size for a ConfigMgr Report-Report Properties

Simply adjust the printed page size to the appropriate page size. In my case, 11 x 8.5 inches, for a landscape-sized page. With that simple fix your report will no longer split over two pages.

How to Set the Page Size for a ConfigMgr Report-Adjust Page Size

You can see the results below. The last three columns of this report no longer spill onto a second page.

How to Set the Page Size for a ConfigMgr Report-Report on One Page 

I hope that you find this tip useful, and good luck with creating new and useful reports!