SSRS – Multi Select Drop down based on a Query Data Source

October 31, 2019

If you need a Multi Select Drop down box that fills up dynamically…

This is the way to do it.

1. Create a new data set

That holds the query to populate the drop down box.

image

Make sure you set the WHERE clause to point to new Multi Select Parameter

2. Create a new Parameter

Set the parameter settings to ALLOW MULTIPLE VALUES 

image

And next set the available values to retrieve the data from the above Query

image

Next in Advance use these settings

image

4. Main ‘DataSet1’ Query selection settings

In the main dataset make sure that you set the WHERE clause :

To point to the parameter using this format IN (@yourparameter)

image

IMPORTANT : Notice the brackets around the Parameter name !

If you forget them you will get errors !

5. Result

The result is that your drop down box will populate dynamically,

based on the previous parameter values

image

Really cool  Smile

Enjoy !