Wednesday, January 27, 2010

SSRS export to PDF in landscape format.


In reporting server you have the option to export your reports to PDF format. By default your reports are generated in the portrait format. When building your report the body will automaitically resized when you add report items which did not fit. After deploying your report, it renders correct in your browser. However after exporting the report you see that the report is exported in the portrait format. This is not nice and generated extra pages. This can be avoided to export the PDF in landscape format. To export your reports to PDF format in landscape format, you need to do the following:

Retrieve the properties of your report. (Right mouse click, just outside the body of the 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.

To avoid extra blank pages during export,  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 (29.7 -1.5 - 1.5)
Set the height of the body to 18 cm (21 - 1.5 -1.5)




Your report is now defined in landscape which will result in generated PDF exports in the landscape format.

Enjoy building your reports.

2 comments:

steeve said...

I tried your solution and it doesn't change anything.

André van de Graaf said...

Steeve, can I help you. Do you have a skydrive from which i can download the report to look what is wrong?