0

I am using SQL server 2008 R2. I have two multiselect dropdown in my report. Second dropdown values populate based on 1st dropdown selected value.

Expectation

Select ALL checkbox in 1st dropdown, second dropdown values are loaded.Then I deselect ALL checkbok in 1st dropdown, 1st dropdown checked values are unchecked and second dropdown is disabled.

Output

When I deselect All checkbox in 1st dropdown,the 1st dropdown checkbox are didn't deselect and 2nd dropdown showed previous selected value.

You have any ideas, please Let me know

Brian Tompsett - 汤莱恩
  • 5,753
  • 72
  • 57
  • 129
Mano Johnbritto
  • 288
  • 1
  • 5
  • 16

1 Answers1

0

If you select 1 or more values in the 1st dropdown then the value of 2nd dropdown should refresh automatically (ordering of your parameters is important).

Whereas if you UNCHECK ALL the value in the 1st dropdown then the 2nd dropdown will not refresh to DEFAULT value which is by the design of the SSRS. Here is the link from microsoft community.

https://connect.microsoft.com/SQLServer/feedback/details/268032/default-does-not-get-refreshed-for-cascading-parameters

CuriousKid
  • 605
  • 5
  • 24