SSRS 2008 R2 - Multiple Value Selection Parameter - refer a dataset field for default value - how to make "Select All" as default ?

Hi Venkat,

If I understand correctly, you want to make “Select All” as default value for a Multiple Parameter which get available value from a DataSet field in Reporting Services. In this scenario, we can also set the Multiple Parameter get default values from the Dataset field.

In order to achieve your requirement, we can refer to the following steps:

1. Right-click the parameter to open the Properties dialog box.


2. In the left pane, click Default Values.


3. Select Get values from a query, and set the same values as Available Values.

The following screenshot is for your reference:

If you have any more questions, please feel free to ask.

Thanks,

Katherine Xiong

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.

Thanks for helping make community forums a great place.