How to Set the Default values from available values Through Report Manager

328 views Asked by At

I have an SSRS report which contains the students details, which will display all the results(passed and failed) of the students. I get the options for the parameter by selecting "Specify values" under the Parameter's "Default Values" setting. However when report gets executed I want "Passed" to be displayed as default and with dropdown to select "Failed" as an option in the report. How can I achieve it?

reference pic of parameter's Default values

1

There are 1 answers

3
Harry On BEST ANSWER

Under your parameter, if you right click your parameter - > parameter properties -> Default Value -> click "Add" button and then type ="Passed" (assuming this string is what the report is expecting)

enter image description here