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
- 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