Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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?
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
217 | |
89 | |
76 | |
66 | |
60 |