ssrs parameter visibility
-
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?
-
Not that I am aware of, however you may be able to get crafty with some cascading parameters. Just built one today that is very slick:-D
***SQL born on date Spring 2013:-)
-
Also on the sorts do you have to use a Parameter? SSRS/Report Builder let you create Interactive sorting on the column. After the report is run the user can decide how to sort the columns. What you could do is only make the Interactive sort visible when Report 4 & 5 are selected.
***SQL born on date Spring 2013:-)
-
user does not want to use the interactive sorting.
-
Unfortunately there is no ability to change visibility of a parameter dynamically. However, you can populate the choices in the Parameter selection dynamically via "Cascading Parameters".
You could do something like this when user chooses Report 4 or 5 from @Reports then the @sort populates with the sorting choices else it only has something like "Not Applicable". If your interested in this method I can show you some quick easy ways to do it if you post the code for those Params.
If you want to go complicated you could always create a button for each report that drills through to its own sub report and parameters. That's a lot of work though.
***SQL born on date Spring 2013:-)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply