Paginated Report with Subreport page break on parameter

[Vansaj2]

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 with pa. I'm at a loss for how to get them to show up and page break together. 

[Anonymous · Accepted solution]

HI @Vansaj2,

I'd like to suggest you take a look at the following link about subreport if helps with your scenario:

Subreports in Power BI paginated reports - Power BI | Microsoft Learn

BTW, your requirement seems more related to report builder usages, I'd like to suggest you post these to Report Server forum to get better support:

Report Server - Microsoft Power BI Community

Regards,

Xiaoxin Sheng

[Vansaj2]

I'll post this over in report server