Parameter automatically created in Report Builder from stored procedure returns error when run

[duncfair]

The report parameter 'RecNum' has a DefaultValue or a ValidValue that depends on the report parameter "RecNum". Forward dependencies are not valid.
----------------------------
The definition of the report '' is invalid.
----------------------------
An error occurred during local report processing.

[ssesham]

@duncfair I am trying to build report using stored proc with parameter. But my report builder throwing error "Procedure or function 'Test' expects parameter '@Dep_Code', which was not supplied."  Report should supposed to create parameter automatically if the stored proc is having one ,but it's not happening in my case.

Can i ask you how did you do that?

Test -  SP Name

@Dep_Code - Parameter Name.

[duncfair]

Thanks, but none of that applies.

[Anonymous]

Hi @duncfair ,

I think you can adjust the order using the up/down arrows in the report designer or by editing the "ReportParameters" section in the RDL file for the report.

You can also define default values in stored procedures instead of setting default values at the report level.

If you are using the same dataset for multiple parameters, consider creating separate datasets for each parameter to avoid conflicts. You can read this documentation: How to: Add Cascading Parameters to a Report (Reporting Services) | Microsoft Learn

I think you can also try recreating the report, which can sometimes solve the problem.

Best Regards

Yilong Zhou

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