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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

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 @Anonymous ,

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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