Cascading Parameter not working after selecting specific value from loaded value

• ravisankar

  Old Hand

  Points: 339

  More actions

  June 10, 2020 at 4:32 pm

  #3762039

  Hi

  I have cascading parameter in report

  Parameter1 - from Dataset1

  Parameter2 - based on Parameter1 selection - Dataset2

  Both Parameters having large number data

  both has default values and also both are multi select parameter

  Steps:

  1. After loading default parameter, I unchecked "select all" from Parameter1 and selected only 1 parameter then Parameter2 is not working(Showing full default values). - during this case we are not able to see query in sql profiler also.

  2. If I removed default for both parameters or Parameter2 then its working fine for Parameter2 by selecting values in Parameter1

  What may be the cause for issue and solution

• Site Owners

  SSC Guru

  Points: 80305

  More actions

  June 11, 2020 at 5:10 pm

  #3762373

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.