Forward dependencies are not valid in SSRS

I got a problem while creating a report in SSRS.

The ERROR shows:

Error 1 [rsInvalidReportParameterDependency] The report parameter ‘COUNTRY’ has a DefaultValue or a ValidValue that depends on the report parameter “COUNTRY”. Forward dependencies are not valid. C:\Users\wiksat\Desktop\New Folder\New folder\Visual Studio 2008\Projects\Report Project2\Report Project2\matrix_cascading.rdl 0 0

What I am suppose to do now? Any suggestions?

Solution 1:

The other reason you will see this error is if you have the order of report-wide parameters incorrect. For instance if you have the following:

@Param1
@Param2
@Param3

and you are trying to use @Param3 in a query populating @Param1, it will throw this error. You need to use the up/down arrows at the top of the report designer to order the parameters appropriately.

Solution 2:

I had the same problem and found by moving the parameter up in the report parameters window, the error disappeared and report displayed.

Solution 3:

Seems like you've somehow set up a report parameter that's referring to itself, in other words "cascading parameters" with just one parameter. That's not going to work.

To show a list of countries, the dataset for your report would be something like:

select CountryID, CountryName from Country

CountryID would be the Value field and CountryName the Label field for your parameter's Available Values.

In case you're interested in cascading parameters: http://msdn.microsoft.com/en-us/library/aa337169.aspx