SSRS Report Page Orientation

Question

I am creating SSRS reports in Visual Studio but I cannot find out how to set the Page Orientation in my new report from Portrait to Landscape.

I would think this would be in the Report/Report Properties settings but it is not there?

How do I change the Page Orientation from Portrait to Landscape for my new report?

Answer 1

It depends.

Are you using SSRS 2005 or 2008?

For 2005: Right-click the white space area of the design surface, choose properties>Layout. Now switch the Page Width/Height values ([21 & 29.7] to [29.7 & 21]). Also, resize the design area to match the layout. i.e. pull the right edge to ~17cm and the bottom edge to about ~24.7cm (for portarit) or right edge to 24.7cm and bottom edge to 21cm (for landscape). For more see this article

For 2008: Right-click the white space area of the design surface, choose report properties>Page setup>choose landscape/Portrait.

Answer 2

For Visual studio 2012- Open the report, In the top navigation, click "Report"

Goto Report Properties. In the popup, change orientation to what you need it to be.

Answer 3

For 2012, Finding that report property was a pain for me because I could not see that "wrench" icon on the reporting bar (which can be open by right clicking on an empty area at the header and clicking "Reports".

Once you get there, change the Orientation to landscape.

Answer 4

You have page height/width and interactive height in report properties. You don't say "Portrait" or "Landscape".

It's not obvious, unfortunately, and this "Understanding Pagination in Reporting Services" only explains indirectly.

Answer 5

Follow the below steps -

1. In Main Menu,Click on Report in VS2008,
2. Then click on Report Properties and
3. in the Page Setup tab, Change Orientation to Landscape.