sherbug1015
asked on
SSRS - Clearing a multi-select drop down
I have two drop downs on my report. One is single select and the other is multi select. If I go in and select multiple values from the multi select drop down and run the report then it pulls back the data fine. Now if I change the value in the single select drop down it refreshes the multi-select drop down with only appropriate values, but the values that I checked before are still checked.
Is there anyway I can clear all the previous selections in the multi-valued drop down.
Is there anyway I can clear all the previous selections in the multi-valued drop down.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks. Not that I know what is causing it, I can provide some workaround. Thanks again.
I think that the parameters are Cascading Parameter due to which value of the list changes when value changes in the other parameter.
Hope the below link will give you idea of the cascading parameter
http://technet.microsoft.com/en-us/library/aa337498%28v=sql.105%29.aspx