By default, your SSRS reports are generated in portrait format. The body of your report will be automatically resized when you add report items. When you deploy your reports, it will portray correctly in your browser. But when you export your report to PDF, you will notice that it is in portrait format. It is not presentable and it will have extra pages. You can prevent this from happening by exporting the PDF in landscape format. To do that, just follow the steps below.
- Go to the properties of your report. (Right-click mouse just outside the body of your report). Set the width of the report to the landscape size of your A4 paper: 29.7 cm. Set the height of the report to 21 cm.
2. When you export the report, you will see extra blank pages. To avoid that, the size of the body should be less or equal to the size of the report margins
Set the width of the body to 26.7 cm Set the height of the body to 18 cm
So now, when you export your report to PDF, it will be in landscape format.
