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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
storko
New Member

Parameter error in paginated report/subreport

Hi,

I'm trying to publish a paginated report showing data for multiple regions, where each region is a subreport.

 

The good news is: it's MOSTLY working. 😄  I created a subreport contaning multiple charts for each region.  In my master report I pass in the region names as a parameter to get each region's data in the specified order.

 

The remaining issue is: on the first page of the paginated mater report, I get an error: "One or more parameters were not specified for the subreport, 'subreport', located at: 'subreport'.  Starting on page two, each region appears properly. 

 

I'm a bit at a loss as to why the error on the first page.  There is only ONE parameter in this report, and it clearly is specified and handled correctly on the subsequent pages.  But on that first page, it is expecting something else.  Am I missing something obvious (or perhaps non-obvious) in the paginated report builder authoring environment?

1 REPLY 1
v-yiruan-msft
Community Support
Community Support

Hi @storko ,

One possible reason for the error is that the subreport does not have the same parameter name as the master report. You need to make sure that the parameter name in the subreport matches the parameter name in the master report, and that the parameter value is passed correctly from the master report to the subreport. You can check the parameter name and value by right-clicking on the subreport in the master report and selecting Subreport Properties. Please refer the following links to try to solve the problem:

To specify parameters to pass to a subreport

One or more parameters were not specified for the subreport

Thanks, I found the problem.  The problem was that the parent RDL used the same sproc as the child report and since the parent report included more parameters the error was actually referring to the parent report.

one or more parameters were not specified for the subreport

This error message hints that either the report parameter has not been passed from the parent report to the child report or that the wrong format of report parameter or an unacceptable value for the report parameter has been passed from the parent to the child report (I mean the subreport when I mean the child report). Can you check the report parameters that are being passed once again?

If the above one can't help you figure out, please provide the settings of parameters in master report and subreport. Thank you.

Best Regards

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors