A common question I get asked by clients, when it comes to exporting SQL server reporting services reports to PDFs, is extra blank pages.
One of the things I advise is when the report is written is to minimise the amount of excess space around the report objects.
There is also a setting within SSRS - ConsumeContainerWorkspace
This report formatting option controls whether the minimum white space around the report objects is utilised or maintained, when the objects increases.
This only affects the white space to the right and the bottom of the report objects.
To apply the ConsumeContainerWorkspace:
- Click on the Report Canvas
- Press F4, to display the report
- In the Others Section, find the ConsumeContainerWorkspace option
- Change the setting to True
If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us