Cascading params in SSRS -Refresh issue
Hi All,
Any solution is there for this below issue.Any hot fix available?.I tried lot of ways to do this but ...So Please update me it is very imp issue for me right now.
Issue :
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.
Thanks
vru
November 2nd, 2010 10:21am
Hi All,
Any solution is there for this below issue.Any hot fix available?.I tried lot of ways to do this but ...So Please update me it is very imp issue for me right now.
Issue :
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.
Thanks
vru
Free Windows Admin Tool Kit Click here and download it now
November 2nd, 2010 5:21pm
Hi Vruk,
When you select the first parameter, then the second parameter will be updated, if you want the third parameter could
be updated, you have to select the second parameter, this is by design. For more information about cascading parameter please refer to this link
http://msdn.microsoft.com/en-us/library/aa337498.aspx Which provide the detailed steps for creating cascading parameter.
Thanks,
Challen Fu
November 4th, 2010 12:45am
Yes ...but it is not working when default values are there...this is the known issue to Microsoft
Free Windows Admin Tool Kit Click here and download it now
November 5th, 2010 1:12am