Multi-value cascading parameters list refresh problem - by tracylee1

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 431251 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 4/7/2009 11:47:28 PM
Access Restriction Public


forgive me, i am not an english speaker.
i have 3 parameters, Country, State, City and all are multi-valued. State is depend on Country, City is depend on State. Default value is set to all avaliable values [Select All].
This issue is if user changes the  Country value(1st parameter) ,and cascading refresh State (2nd parameter), the City(3rd parameter) list will not be refreshed.  

my real report is using Reporting Services 2008 querying from a SSAS cube, for simplicity, i use  SQL Server db as demo. This issue is also exist in my  cube report.

i also tried the same report in Reporting Services 2005 without any SP, all the parameters and their default values work fine.

Sign in to post a comment.
Posted by Jazz5 on 4/14/2014 at 10:26 PM
I believe I've seen this issue in SSRS 2012. Is it possible the bug has resurfaced?
Microsoft SQL Server Reporting Services Version 2011.0110.2100.060 ((SQL11_RTM).120210-1917 )
Posted by Mallyk on 6/25/2009 at 4:45 PM
(RS 2008) I see this issue even for the 2 parameters. I have a parent parameter having the available values with multi-select option, the second parameter is defined as (Parameters!Parent.Count). Now when I preview the report, for the initial selection the second parameter shows up the right values but for the subsequent selection it still shows up the initial value :(. Is this fixed as a part of CU#5? Please let me know.
Posted by Microsoft on 4/8/2009 at 8:57 AM
Thank you for reporting this issue. The fix will be available in the next cumulative update, i.e. CU#5 that is expected to be released in mid May. CU#5 will be a publicly available download.

If you have to get it earlier, you can call/contact Microsoft Support (CSS) directly today (, open an incident and specifically ask to get access to a on-demand QFE for this issue that we made available a few days ago. When calling CSS about the on-demand QFE, please refer to SQL Server QFE ID 291168, hotfix build 10.00.1799, hotfix ids 376783 (x86), 376782 (x64), 376781 (ia64).

Reporting Services Team.