Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSRS Report Page Orientation

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?

like image 971
Seth Spearman Avatar asked Jul 22 '09 15:07

Seth Spearman


People also ask

How do I change the orientation of report Builder?

Suggested Answer Open the report design in VS, Select from the top menu Report -> Report properties and then under Page setup, select Orientation as Landscape.


3 Answers

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.

like image 185
lukehayler Avatar answered Oct 04 '22 17:10

lukehayler


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.

like image 23
Pallavi Avatar answered Oct 04 '22 19:10

Pallavi


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.

like image 41
Ammar Avatar answered Oct 04 '22 18:10

Ammar