topic Re: How to set land space and Portrait for single report in Power BI paginated report. in Report Server

How to set land space and Portrait for single report in Power BI paginated report.

Anonymous — Thu, 02 Jan 2025 05:38:16 GMT

Hi,

How can we set up Land Space and Portrait for single report in Power BI paginated report? is there any way to do that?

Re: How to set land space and Portrait for single report in Power BI paginated report.

saud968 — Thu, 02 Jan 2025 13:03:49 GMT

In Power BI Paginated Reports, you can set the orientation of your report to either landscape or portrait, but you can't mix both orientations within a single report. Here's how you can set the orientation:

Open Report Builder: Start by opening your report in Power BI Report Builder.
Access Report Properties:
Right-click on the empty space next to your report.
Select Report Properties from the context menu.
Set Orientation:
In the Page Setup tab, you can choose either Portrait or Landscape orientation.
Adjust Page Size and Margins: Make sure to adjust the page size and margins to fit your content properly.
Save and Deploy: Save your changes and redeploy the report to the Report Server.
Unfortunately, if you need different sections of the same report to have different orientations, you would need to create separate reports for each orientation and then combine them as needed

Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!

Re: How to set land space and Portrait for single report in Power BI paginated report.

Anonymous — Fri, 03 Jan 2025 05:43:54 GMT

Your solution is so great saud968

Hi, Anonymous

I guess you can do this with subreports. By setting the orientation to Portrait subreport 1 and setting the orientation to landscape subreport 2, and then inserting the subreport with two different directions into the new report:

In the report builder software, orientation is a single choice, and two orientations in the same report are not supported.

Of course, setting up a sub-report with a different orientation, and then inserting them all in the same report will achieve the desired effect.

Add a subreport and parameters to a Report Builder paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn

If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: How to set land space and Portrait for single report in Power BI paginated report.

Anonymous — Mon, 06 Jan 2025 03:17:38 GMT

Hi, Anonymous

I wish you all the best. Previously we have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

Best Regards

Jianpeng Li