Friday, February 17, 2012

Dependant Dropdown Filters displaying <Select a Value>

I have a few reports that we have filters where our client can select from dropdown menus. There are four menus and each one is dependant on the previous one. The problem is that initially all of the dropdowns are defaulted to <All>, but once you have gone and selected a value in the dropdowns then you go back and change any of the dropdowns, the dropdowns that are then dependant on the dropdown changed revert to <Select a Value> instead of going back to the default assigned of <All>. This is happening to all of the dropdowns dependant on the one changed no matter how many are changed initially or left alone.

Is there any way to revert them back to their assigned default <All> or is this a bug in SQL Server Reporting Services?

Is there anyone who can help me out with this issue?

Thank you for any help you may have.

No comments:

Post a Comment