0

I have a couple of multi-valued parameters in my report created using visual studio reporting services, one filtered against the other.

I want that each time there is any change in my first parameter drop-down list, the values appended in my second parameter drop-down list, when updated, must be auto selected by default.

As of now, I get the desired values in my second parameter drop-down list each time there is any change in my first parameter list. However,in some cases,the appended values in my second parameter list are not selected by default.

Please give suggestions to implement this functionality.

pnuts
  • 58,317
  • 11
  • 87
  • 139
jaintanya1128
  • 1
  • 2
  • Phrasing requests in the imperative - such as "An early responds is awaited" - is unlikely to improve the responses that you receive. –  Mar 16 '12 at 09:44

1 Answers1

0

By design, it is not possible for SSRS to re-evaluate the default value(s) for a subsequent parameter unless the selected value is no longer in the valid values list, as can be seen from this issue on Microsoft Connect.

One possible workaround is to ensure that when the higher level parameter's selected value is changed, the selected value is no longer available in the valid values list for the dependant parameter - this technique is discussed in more detail here.