Setting SSRS report measurements

When modifying the SSRS reports, make sure, before checking them in, that they export correctly in PDF. Some of the reports are not easily printed on 8.5x11 sheet of paper, make sure they all export into one page width in PDF. This means, no extra blank page and no grids that get cut off and put on extra pages.

Here how to prevent that:

1. Click on Report > Report Properties > Layout tab (Page Setup tab in SSDT-BI)
2. Make a note of the values for Page width, Left margin, Right margin
3. Close and go back to the design surface
4. In the Properties window, select Body
5. Click the + symbol to expand the Size node
6. Make a note of the value for Width

To render in PDF correctly Body Width + Left margin + Right margin must be less than or equal to Page width. When you see blank pages being rendered it is almost always because the body width plus margins is greater than the page width.

Remember: (Body Width + Left margin + Right margin) <= (Page width)

To get the body width, click on the white part of the body of the report and in the properties screen on the right you’ll see the measurements. To get the report width, click on anywhere outside, not on the report, and in the properties screen on the right you’ll see the measurements.

Contributed by: Chris Wright

Contributed on: 2/27/17