Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

How to change SSRS report design to landscape orientation?

(0) ShareShare
ReportReport
Posted on by 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.

*This post is locked for comments

  • ArcaneCode Profile Picture
    ArcaneCode 2 on at
    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 Profile Picture
    pickedaname 5 on at
    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.

    pastedimage1597347111907v1.png

  • Suggested answer
    Vipin J Profile Picture
    Vipin J 1,583 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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.

    RP2.JPG

    RP2.JPG

    Thanks

    Suresh

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    axie1928 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    syed baber 11,627 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans