Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BalakrishnanShanmugham
Starting Member
6 Posts |
 Posted - 2014-03-06 : 04:36:32
|
| Hi,I am using SSRS 2005. I want to enable/disable or hide/view parameters based on another parameter selection. Say Suppose I have 5 parameters. User selects first value in first parameter I should show only Second parameter and hide remaining 3 parameters (Parameter 3,Parameter 4 & Parameter 5).If user selects second value in first parameter I should show third parameter and hide remaining 3 parameters(Parameter 2,Parameter 4 & Parameter 5).Similarly If user selects third value in first parameter I should show fourth and fifth parameter and hide remaining 2 parameters(Parameter 2 & Parameter 3).There is no relationship between these parameters except user selection.I can not see any Visible property for report parameters.Any "builtin" support in SSRS for this scenario.Appreciate your help.Regards,Bala |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-03-06 : 11:14:58
|
| What you need to use is cascading parameters http://technet.microsoft.com/en-us/library/aa337498(v=sql.105).aspx |
 |
|
|
|
|
|
How to hide/view a SSRS report parameter control d