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: 1083
ssrs-2005
|ssrs-reports
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