Home Dashboard Directory Help

Multi-value cascading parameters list refresh problem by tracylee1


 as Fixed Help for as Fixed

Sign in
to vote
Type: Bug
ID: 431251
Opened: 4/7/2009 11:47:28 PM
Access Restriction: Public
User(s) can reproduce this bug


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 (http://support.microsoft.com/contactus/cu_sc_more_master?ws=support#tab1), 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.
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
myNorthwind_Data.mdf (restricted) 4/8/2009 -
myNorthwind_Log.ldf (restricted) 4/8/2009 -
CascadingParm.rdl (restricted) 4/8/2009 -
CascadingParm.rdl.data (restricted) 4/8/2009 -