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.
10 comments:
I tried your solution and it doesn't change anything.
Steeve, can I help you. Do you have a skydrive from which i can download the report to look what is wrong?
The page size needs changing to 29.7 x 21 cm in the report properties also not just the body size
I am using Report builder 3.0 to create the report. I don't see any property option there.
Eva,
You can enable the propertie window in report builder 3.0. by default it is not enabled. Select in teh menu View, Now you can select (tick) Properties. After enableing this you will get the propertie window.
Another way of doing this. Put your mouse on the blue part just outside your report and do right mouse click and select report properties. Or in the report, right mouse click and select Body properties.
Success in configuring your reports in landscape
Thanks. Very simple and works fine.
Hai Andre van - How to export pdf file portrait format A4 size from SSRS report - Please Help
-Veerapandiyan
This works for the report when you have VS2010 loaded. Any ideas when justRedistributable Report Viewer is installed and not VS2010?
thanks it's working fine
Post a Comment