Last post Nov 17, 2010 04:15 AM by You-Hu Fu
Nov 11, 2010 10:46 PM|yogesh69|LINK
I have a parameter Owner with 1,2,3 options in dropdown.
On selection of option 1 , a country parameter should be enabled with all countries' values defaulted.
Option 2 should enable Region parameter with all the Regions values selected and country parameter should be displayed.
Option 3 should disable both Region & Country Parameter.
Please help me in achieving this.
I am using SSRS 2005 with Enesys tool as add on.
Thanks in advance.
Nov 12, 2010 03:50 AM|qwe123kids|LINK
Are You Talking about Cascading drop Down List
//// Using Ajax.net
Nov 17, 2010 04:15 AM|You-Hu Fu|LINK
I get your meaning from the detailed information, however the visibility of parameters in Reporting Service can only be set in advanced, and we cannot control its visibility at run-time. To work around the issue, you could add cascading Parameters, if parameter1
select option1, region parameter should return nothing. If paramter1 selects option2, country paramter should return nothing. Of course, you can create a customaries web application in .NET platform with the reportviewer control to show the RDLC file report
just following qwe123kids' reply.
If this requirement is frequently utilized, I would recommend you submit a feedback to Microsoft Connect at this link
https://connect.microsoft.com/SQLServer/Feedback This connect site is a connection point between you and Microsoft, and ultimately the larger community. Your feedback enables Microsoft to make software
and services the best that they can be. Thanks.
For more information about Adding Cascading Parameters click this link