Ssrs Grey Out Parameter Based on Result from Other Parameter

SSRS Grey out Parameter based on result from other Parameter

Within the confines of what's built-in, you can use this method:

1. Create a dataset that is based on your SpecifyDate parameter.

   if @SpecifyDates = 'No'
   select null as Date
   else
   select cast('1/1/2012' as datetime) as Date

2. Set the default values for your dates to be based on this dataset.

When you choose "No" for specify dates, the dates will be set to Null, greyed out, and not required to run the report. When you select "Yes" it will put in the default date that you set in the query. Of course you can customize that.

SQL Server Report Builder - How to grey out a parameter with multiple sub-reports?

You can't grey out the parameter. Unfortunately you can't hide the parameter either as the hidden property only takes True and False. What you are doing now might be the best you can do. However, you could try looking at cascading parameters, maybe you might be able to provide a slightly more user friendly value like "None" to the dropdown.

SSRS Parameters - Toggle a parameter's NULL checkbox depending on value other parameter(s) NULL checkboxes

The checkbox for a parameter to allow NULLs can only be set at design-time. You can't have it checked/unchecked depending on other parameters or user action.

The only way to handle your requirement is to allow all three parameters to be NULL, and have your stored procedure return an error message when the user doesn't meet at least one of the required conditions.

SSRS Parameter, Specify Values Not working

Sound like you have not setup the Filter correctly ..

On the Group Properties you need to filter the column with your parameter.

---

Related Topics