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.
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.