2
votes

I'm putting together an SSRS report in BIDS 2008. I've got a parameter - we'll call it ParamA - that's set to allow multiple values, and, in Available Values, I've set it to 'Get values from a query'. When I run the report, I get the following error:

An error occurred during local report processing.

The definition of the report '/Report2' is invalid.

The report parameter 'ParamA' has a DefaultValue or a ValidValue that depends on the report parameter "ParamA". Forward dependencies are not valid.

When other people get this error, it seems to involve multiple datasets, and the forward dependencies always deal with two different parameters. I'm using only one dataset, and only one parameter is cited in the error.

Any advice would be great.

2
Can you post the query you use to populate ParamA?Joao Leal

2 Answers

7
votes

Have you checked the order of your parameters in the report designer toolbar. If they are ordered incorrectly the report will fail because of the order required to make the dependencies work. You use the little blue up and down arrows to set the order of report parameters

4
votes

I think I figured out the problem. Using a multi-value parameters requires that each such parameter have its own dataset. I only had one dataset, and I was trying to point the MVP at it and run the report off of the same set. I don't know why that doesn't work, but I added a dataset for the MVP, and the error went away.