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 |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2014-09-17 : 14:49:00
|
| In an SSRS 2012 report, I have a parameter called 'report' where the user can select what report(s) they want executed. When report4 and/or report5 are selected. I want like a parameter called 'sort' to be displayed. If report4 or report5 are not selected, I do not want the parameter called 'sort' to be visible.Thus is there a way to make a parameter visible based upon the value of 'report' having report4 or report5 selected? If so, can you show me how to setup the conditional display of this parameter? |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-09-17 : 17:08:25
|
| As far as I know, you cannot hide a parameter based on the value of another parameter. However, you can decide what values if any will be shown for the second parameter based on the value in the first parameter - via cascading parameters http://technet.microsoft.com/en-us/library/aa337169(v=sql.100).aspx |
 |
|
|
|
|
|
ssrs paramter visibility