Enable SSRS parameter visibility to be set dynamically by expression
SSRS columns can be set to display dynamically based on an expression, but SSRS parameters can only be set to Visible, Hidden, or Internal. My suggestion is to add the ability to control SSRS parameter visibility by expression as well.
The ability to hide a parameter based on the value of another parameter would be so useful for my situation. My report has parameters for AccountNumber and DateRange, where the values for DateRange are some predefined ranges (e.g. prior Monday thru Sunday, Current Monday to now, Prior 7 full days). I also need to allow the users to enter a custom date/time range, so there are also StartDate and EndDate parameters. I need the StartDate and EndDate parameters to be hidden unless the user chooses DateRange value "Custom Date Range". Currently all I can do is set the default to NULL so the boxes are greyed out (with the NULL option selected) when the option chosen is not "Custom Date Range". This is confusing to the users.
I completely agree with the other comments. I too have had many requests over the years to dynamically set Parameter visibility!!
Phil Swan commented
This would be an amazing feature, I have had tons of requests like this over the years.
Hello any update concerning this?
Is there any news about this ?
We are developing a SSRS report where we have a single select drop down (parameter name is AT) and 2 date parameters (parameter names as FromDate and ToDate).
The requirement is that when a report is run or in preview, a selection has to be made from Parameter AT mandatorily. FromDate and ToDate parameter will be hidden or disabled at first run.
If a specific value is selected from Parameter AT, then fromdate and todate parameter has to get enabled or made visible.
If this specific value is not selected from Parameter AT, then fromdate and todate parameter has to remain disabled or hidden.
Objective is to toggle visibility and enablement of date parameters based on selection in parent parameter dropdown. Could we know if this will be resolved in later releases.