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

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.


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 


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


Next in Advance use these settings


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)


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


Really cool  Smile

Enjoy !

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: