Forum Discussion

SowmyaTupakula's avatar
SowmyaTupakula
Frequent Visitor
10 months ago
Solved

Paginated Report

Hi Community, I have Customer Balance PBI Report with 7 pages - each page has different filters Main page shows customer balance view for all legal entities for Leadeship view, 2nd page has Canad...
Need Help
  • rohit1991's avatar
    rohit1991
    10 months ago

    Hi SowmyaTupakula 

     

    Yes ,Paginated Report is the right option for this use case.

    1. It can display all rows without any scroll or data limit.

    2. You don’t need to create 7 different .rdl files.

    3. Build one report and use parameters for each view (Leadership, Manager, Canada, etc.).

    4. Add page breaks so every view appears on a separate page.

    5. When exporting to PDF or Excel, users will get complete data for all sections.

    6. Much easier to maintain and update one report instead of managing multiple files.

  • tayloramy's avatar
    tayloramy
    10 months ago

    Hi SowmyaTupakula, 

     

    Yes, that is possible, just set up the entity as a parameter. 

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.  

v-ssriganesh's avatar
v-ssriganesh
Community Support
10 months ago

Hi SowmyaTupakula,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to tayloramy & rohit1991 for sharing valuable insights.

 

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

 

Thank you for being part of the Microsoft Fabric Community.