Search code examples
reporting-servicesparametersmdxrdlcascading

SSRS cascading parameters: child parameters' default 'All' value drops to blank after user changes parent parameter

I have a big bunch of cascading parameters in my rdl report with default value 'All' everywhere. But all children go blank after user changes some parent parameter, and then he has to choose 'All' value from drop-down list for each of child parameters manually. This is pretty annoying staff. How can I force report to fix default 'All' value for child parameters, despite of any changes to parent parameter?

Solution

  • I've found decision for my child parameter go-blank problem. In the Report Parameters dialog just print to the 'non-queried' field default value in quotes. For example, in case of olap data source: print

    ="[Calendar].[Quarter].&[All]"

    instead of:

    [Calendar].[Quarter].&[All]

    After this Quarter child cascading parameter will not lose it's default value 'All' when user chooses another Year. Nuts!