Forum Discussion
Report Builder - generate a single report that shows same data but with different filters applied
One way to do this would be using a sub report Subreports in Power BI paginated reports - Power BI | Microsoft Learn
If you build a single report that has a parameter that can either be MLB or League or a Team and prints the page for that entity.
Then build a second report that has a dataset with 33 rows - one row for each entity you want to print. With the parameter value you need to pass into the first report.
eg
MLB League 1 League 2 Team 1
Team 2
etc...
In this second report you create a table based on this dataset with a single detail cell which covers the whole width of the report and put a subreport control in it linked to your first report and link up the parameter in the subreport to value from the dataset.
Then when you run the second report it should generate the first report 33 times passing in the different parameter values from the dataset in the second report.
Super UserOne way to do this would be using a sub report Subreports in Power BI paginated reports - Power BI | Microsoft Learn
If you build a single report that has a parameter that can either be MLB or League or a Team and prints the page for that entity.
Then build a second report that has a dataset with 33 rows - one row for each entity you want to print. With the parameter value you need to pass into the first report.
eg
| MLB |
| League 1 |
| League 2 |
|
Team 1 |
|
Team 2 |
|
etc... |
In this second report you create a table based on this dataset with a single detail cell which covers the whole width of the report and put a subreport control in it linked to your first report and link up the parameter in the subreport to value from the dataset.
Then when you run the second report it should generate the first report 33 times passing in the different parameter values from the dataset in the second report.
thanks so much for pointing me in the right direction. i am able to follow up until:
"In this second report you create a table based on this dataset with a single detail cell which covers the whole width of the report and put a subreport control in it linked to your first report and link up the parameter in the subreport to value from the dataset."
Can you clarify/expand what you mean by subreport control and how to link it to the first report?
- d_gosbell
There are instructions here on using subreports Add a subreport and parameters to a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn
thanks for the help and lnks; was able to sort it out and it worked perfectly.