Pass Main Report Parameters to Nested Sub-Report

JK800 — Sat, 16 Mar 2024 02:04:55 GMT

Hi,

I am using PowerBI Report Buidler to build a paginated report. Is there a way to pass main report parameters to a sub-report that is nested within another sub-report? Trying to do this but it is causing errors in the first sub-report.

Thanks

Re: Pass Main Report Parameters to Nested Sub-Report

Anonymous — Mon, 18 Mar 2024 02:38:07 GMT

Hi JK800 ,

Let’s break down the steps to achieve this:

Create the Reports:
- First, create the main report and the subreport(s) you want to nest within it.
- Save both reports to the same Power BI workspace.
Design the Parent Report:
- Open the main report in Power BI Report Builder.
- In the Design view, right-click the subreport placeholder where you want to embed the subreport.
- Click Subreport Properties.
Specify Parameters for the Subreport:
- In the Subreport Properties dialog box, navigate to the Parameters section.
- Click Add to create a new parameter row in the grid.
- In the Name text box, type the name of a parameter in the subreport or choose it from the list box.
- Repeat this step for any other parameters you want to pass.
Link Parameters:
- Now, go to the Subreport Links window.
- Search for your parameters on the left side and move them to the right side.
- Ensure that the option for Select data in subreport based on field is unchecked for these parameters.
- Click OK to save the changes.
Open the Subreport:
- Finally, open the subreport itself and ensure that it handles the parameters correctly.

Below is the official link will help you:
Pass a report parameter within a URL for a Power BI paginated report - Power BI | Microsoft Learn

Add a subreport and parameters to a Power BI paginated report - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: Pass Main Report Parameters to Nested Sub-Report in Report Server

Pass Main Report Parameters to Nested Sub-Report

Re: Pass Main Report Parameters to Nested Sub-Report