Answered by:

SSRS Reports

Question

My case is like I need to display parameter values based on previous parameter. I came up with a workaround to ensure my final parameter is disabled if a value from previous parameter. But when report parameter is disabled report is not executing and nothing
happens when i click View Report button.

Answers

In your scenario, the parameters are used in the dataset and you disable one of the parameters in some particular condition, right? In this case, I am afraid the report can no be executed because of the parameter was used in the dataset. You cannot execute
the report without change the dataset difinition. One way to workaround this is leave the parameter as blank instead of disable it.

You cannot really "disable" parameters based on other parameters. All you can do is add a "N/A - Not applicable" item to your list of available values, and possibly make that the default as well. And you will need to take that into account
in any dataset that uses this parameter.

Yes
Valentino, I agree on that. Because i too feel the same and moreover there is no workaround suggested.Actually I made a workaround to disable the value. But I can't execute with one param disabled.

In your scenario, the parameters are used in the dataset and you disable one of the parameters in some particular condition, right? In this case, I am afraid the report can no be executed because of the parameter was used in the dataset. You cannot execute
the report without change the dataset difinition. One way to workaround this is leave the parameter as blank instead of disable it.