SSRS 2005 - Cascading parameters and default value update problem

Posted by sHr0oMaN on Stack Overflow See other posts from Stack Overflow or by sHr0oMaN
Published on 2010-03-30T22:37:57Z Indexed on 2010/03/30 22:43 UTC
Read the original article Hit count: 1027

Filed under:
|

I have a report with cascading parameters. The first parameter is Finanical Period Type, being either Month or Week. The second parameter is a list of either financial months or weeks depending on what was selected for the first parameter. This all works well and selecting a series of different Financial Period Types in sequence correctly updates the second parameter's values.

However I now wish to add a default value for the second parameter, which is once again dependent on the first parameter. So I've added an additional field to the dataset populating the second parameter called DefaultPeriod and set the second parameter's default value to be retrieved from the above field.

The first time I select the Financial Period Type, the default is correctly set. However changing the Financial Period Type results in an updated list for the second parameter, but the default is incorrect. It remains set to the original default value, even thought the dataset has been refresh and the DefaultPeriod field is correct.

This is both an issue in the IDE and on the Report Manager site.

© Stack Overflow or respective owner

Related posts about ssrs-2005

Related posts about ssrs-reports