How to change SSRS report design to landscape orientation?

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

I want to modify PurchPurchOrder report so that it will have many columns in the lines table. It will become little wider report due to that.

Hence obviously i want to print it in Landscape and user need not to select 'Landscape' every time from print options.

how to achieve this? I am using AX 2012 R3.

Categories:

Reporting and BI

All responses (14)

Answers (0)

ArcaneCode on at

Like (1)

Report

RE: How to change SSRS report design to landscape orientation?

If you are on the most recent (Sept 2021) release of SSRS Report Builder, go to the view tab, and put a check in the Properties box.

The properties window will appear on the right side. It should read "Report" under properties. If it is showing one of the controls on the report, then click in the big empty gray area outside the body of your report so it'll show the properties of the report.

Now click on the right most icon right under report (looks like a white square). This will bring up the report properties.

On the page setup tab, you can easily change the paper orientation among a slew of other settings.

I know this is an old post, but hopefully it'll help others still looking for the answer.

ArcaneCode
pickedaname 5 on at

Like (0)

Report

RE: How to change SSRS report design to landscape orientation?

From Report Builder 15 (for those that came here looking for a way to set report orientation in RB)

From the Insert tab, click Report Parts. This brings up the Report Properties list. At the top of this list, there are a few buttons. One of them is named Property Pages.

That was not a very intuitive experience, but there it is.
Suggested answer

Vipin J 1,582 on at

Like (0)

Report

RE: How to change SSRS report design to landscape orientation?

Here is a blogpost for in-dept understanding about SSRS report page setup

vjcity.blogspot.com/.../dynamic-crm-ssrs-report-best.html
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: How to change SSRS report design to landscape orientation?

Hi axie1928,

we can give solution for you but you cannot verify this tread as answered. then it won't be useful in future. But anyway as Baber Owais said the path : Report -> Report properties and then under Page setup, select Orientation as Landscape. Here you can find screen shots to set the landscape setup.

Thanks

Suresh
Community Member Microsoft Employee on at

Like (0)

Report

RE: How to change SSRS report design to landscape orientation?

Hi,

Can you open new tread for this as new one. Because it will be useful for future reference to other members.

Thanks

Suresh
Community Member Microsoft Employee on at

Like (1)

Report

RE: How to change SSRS report design to landscape orientation?

Hi,

I assigned page orientation as per page actual heights and weights. that solve my problems.

I used c# to fix this code.

Please explain us detailed issue. so that we can understand what's the actual problem.
axie1928 on at

Like (0)

Report

RE: How to change SSRS report design to landscape orientation?

I have the same issue. Can you be more specific on how to solve the problem.?

Thanks ahead.
Community Member Microsoft Employee on at

Like (0)

Report

RE: How to change SSRS report design to landscape orientation?

I m able to changed the reports orientation successfully and also print reports as per current orientation but reports not preview as per current orientation so what we do to change reports preview as per current orientation.

Thanks

Kapil Khare
Suggested answer

syed baber 11,627 on at

Like (0)

Report

RE: How to change SSRS report design to landscape orientation?

Hi VDY,

Check the below thread:

community.dynamics.com/.../106577

This seems to be related to your issue depending upon which version of AX 2012 are you using. Please have a look and let me know if you have further queries.

One option you have is to export the report as PDF and then print it from there and see what are the results.

Thanks,

Baber.
Community Member Microsoft Employee on at

Like (0)

Report

RE: How to change SSRS report design to landscape orientation?

Hi Baber,

It doesn't print in Landscape. I think as a developer we can't control it. User has to decide every time whether he wants to print it in landscape or portrait.

I am working on Purchase order report where i wanted to add few columns in existing report and hence it became little wider which can't be accomodated in portrait. so i wanted to make it landscape orientation.