Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Vansaj2
Frequent Visitor

Paginated Report with Subreport page break on parameter

I'm working on building a variation on an invoice that has an invoice number and then pulls in transactions that are part of that invoice as a subreport. 

The problem is that unlike the training examples provided by Microsoft I need to generate roughly 400 at a time and so that subreport needs to end up on the correct page for each Invoice while I run them all at the same time. I've been able to get it to work for a single invoice number. I've been able too get each sub report on a different page but not with the rest of the invoice information (just pages of subreports followed by pages of invoice information). 

 

I've tried grouping on the main report with page breaks, I've tried grouping on the subreport. I've tried both I'm at a loss for how to get them to show up and page break together. 

 

Vansaj2_0-1672933570360.png

 

Vansaj2_1-1672933570377.png

 

 

1 REPLY 1
d_gosbell
Super User
Super User

I cannot see clearly from your screenshot, but it looks like the subreport is just sitting on the body of the report. Normally if I want a sub report for each row in my parent dataset I will put the subreport inside a detail cell in a table in the main report.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.