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.

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 ssrs paramter visibility

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
Go to Top of Page
   

- Advertisement -