"тнιѕ вℓσg ¢συℓ∂ ѕανє уσυя мσηєу ιƒ тιмє = мσηєу" - ∂.мαηנαℓу

Wednesday, 12 September 2018

SSRS Error -The report parameter has a DefaultValue or a ValidValue that depends on the report parameter Forward dependencies are not valid.

SSRS Error -The report parameter  has a DefaultValue or a ValidValue that depends on the report parameter.  Forward dependencies are not valid.  

This was actually a simple issue. But the error message was a bit confusing. So thought to post this scenario so that this could save someone's time. 

In our scenario we had a parameter called Country. And this Country parameter was used in another parameter to filter down further. So we had another parameter called States which was based on a query with Country parameter in the where condition along with some other conditions. Now the order of the parameters should be Country First and then States. Otherwise you would see the above error. Its super easy to change the order of the parameters. For the beginners, please refer the below link. It has a screen shot.

How to change the order of report parameters 

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/change-the-order-of-a-report-parameter-report-builder-and-ssrs?view=sql-server-2017


2 comments:

  1. As you have now understood the usage of ‘Record and Playback’ tool, the following are the different posts using which you can explore the functioning of ‘Selenium IDE’
    selenium Training in chennai

    ReplyDelete
  2. Testers can build, enhance, and maintain scripts to regression test their mobile applications. Hands-on instruction is provided for those who want to explore the power of using Appium. The course covers content from installation to execution and reporting . The focus is on the practical application of Appium to resolve common mobile automated testing challenges. This course focuses on getting started with Appium.
    course/appiumtraininginsholinganallur/

    ReplyDelete