Wednesday, June 23, 2010

Export SSRS Report data to PDF in Landscape

It is quite a common situation that users request the developers to make a report in such a way that when they export the report to an excel or PDF, they should not have to change the print properties, but automatically, it should export in landscape.

The solution for this is very simple.
In the below Figure,


you see the highlighted property for page size.
(You will find this in report properties). you just have to change those according to the size of paper they are printing on.
In this case, the paper size is regular 'letter'. So what I will do is just change the width to 11 inches, and Height to 8.5 inches.

That is it... now, if the user exports the report to excel or PDF, the file will be in landscape.

No comments:

Post a Comment