topic Re: How to create a paginated report of "multi-paged" subreports with Power BI? in Report Server

How to create a paginated report of "multi-paged" subreports with Power BI?

Anonymous — Sun, 21 Jun 2020 06:35:47 GMT

I want to create a master report that consists of multiple 5-page reports for each sales region (say 10 regions). I am creating a parameter to filter the results based on the region. Every example I found for Power BI paginated report was based on 1-page reports. I wanted to check if it is possible to create my master reports of multi-paged subreports with Power BI paginated report.

One more piece of information to add here is that each of my subreports includes a combination of tables and graphs and the number of rows in some tables may vary for each regional report (pushing some rows to the next page). It is also required to conditionally change the font color for certain rows in the table. Please let me know if these features can be applied too.

Thanks

Re: How to create a paginated report of "multi-paged" subreports with Power BI?

saglamtimur — Mon, 22 Jun 2020 07:12:50 GMT

This topic may lead you

https://community.powerbi.com/t5/Desktop/Power-BI-Report-Builder-Report-having-multiple-sheets/m-p/1141742

Re: How to create a paginated report of "multi-paged" subreports with Power BI?

Anonymous — Mon, 22 Jun 2020 18:14:43 GMT

Hi Saglamtimur,

Thank you for the reply. The link that you kindly shared shows that there's the capability to create a multi page report. Can you also confirm that:

1) To create pdf reports, we should follow the same instruction you gave fro Excel sheets?

2) With paginated report, we can put my individual multi-paged reports together and create a master report? For instance, if the individual report for each company contains 5 pages and we have 10 companies to report on, we want to create a master report of 50 pages, which includes all those 5 reports.

3) Are we required to purchase Embedded/Premium Capacity to be able to achieve this?

4) One last question; can we create a table of contents for the master report?

Looking forward to your insights.

Thanks for your help!

Re: How to create a paginated report of "multi-paged" subreports with Power BI?

saglamtimur — Tue, 23 Jun 2020 06:17:43 GMT

First of all I would like to mention my solution works with Power BI Report Server, not service, as this subject is under Report Server.

From back to forward:

4) As far as I know; no

3) This is capability of Power BI Report Server

2) Yes, it's all about grouping

1) For pdf reports, it's different than Excel. Excel is single file containing multiple sheets. But For pdf there is no such functionality. You can generate multiple pdf files for each group but with data driven subscriptions.

Re: How to create a paginated report of "multi-paged" subreports with Power BI?

Ashok08 — Fri, 14 Jul 2023 12:41:49 GMT

Can we add multiple tabs in One Paginated Report?

Re: How to create a paginated report of "multi-paged" subreports with Power BI?

Ashok08 — Fri, 14 Jul 2023 12:45:41 GMT

I need to add multiple reports in one paginated report like if we click one tab it will show the state level and next tab is for district level and next for city level.

can anyone know this please help me...!

Thanks

Ashok

Re: How to create a paginated report of "multi-paged" subreports with Power BI?

MallikarjunaBan — Wed, 13 Sep 2023 17:44:56 GMT

multi tabbed report has any one created in paginated report builder new version