Search This Blog

The report parameter has a default value forward dependencies are not valid Error in SSRS.

The report parameter has a default value forward dependencies are not valid Error in SSRS.

A comman problem while working with SSRS Reports when you have created Multiple Parameters and 
Created Cascading Parameters then there are chances you will face this problem due to order of Parameters.
In order to know about cascading of Parameters Check my earlier blog on Cascading of Parameter.

The Reason for this Error.
1-When working with Multiple Cascading Parameter if you have added one more parameter in your report
then the Parameter position will be last and lets us suppose that parameter is taking filter value from first parameter so it Should be your second Parameter but you have added it newly so it's comming at last position In this case if you will preview the Report .
The Report will throw an Error saying.

The report parameter has a default value forward dependencies are not valid Error in SSRS.

Solution-In order to Solve this Problem Select your last Parameter change its position to second place 
In order to do this go to view -Last Click Report Data
Screen will come like this.


Now in order to remove error you have to  move Last Parameter ResourceUID to 2nd Place
Select ResourceUID click on arrow key Upward Direction move it to place 2nd
Now the Resource UID in Second Place 


Preview your Report the error will not be there.


3 comments:

  1. Thank you, I begin with SSRS and I could not have guessed that parameters order is so important.

    ReplyDelete
  2. Parameter order is only important because the report definition is stored in XML format and XML readers retrieve the information in the order of creation.

    ReplyDelete
  3. Oflaginviata Jeremy Hearshman Here
    orciocremic

    ReplyDelete