One Parameter Selection = Multiple Parameters Selected SSRS/SQL

Question

In SSRS I am looking to create a report that has a selection for location. I would also like to add regions so that groups of locations can be selected easily. Preferably this selection would come out as its own line in the report as well. Any suggestions on how to make this possible?

I am also looking to create a selection for All that use all the locations and create a single line in the report.

M.Ali · Accepted Answer · 2014-07-11 00:44:49Z

1

you will need three data sets

Dataset for Locations

select distinct locations and populate your Locations Parameter's drop down, in parameter properties allow multiple values to be selected. Also for default value select values from query which will bring all the locations forward.
Dataset for Regions

This parameters's drop down will be populated by the Locations selected from 1st locations Parameter something like
```
 SELECT DISTINCT Regions
 FROM TABLE
 WHERE (Locations IN (@Locations))
```
Main Dataset

Finally this will be the main dataset for your report which will pull data where regions are in Regions selected in your Regions parameter. something like
```
 SELECT *
 FROM TABLE
 WHERE (Regions IN (@Regions))
```

answered Jul 11, 2014 at 0:44

M.Ali

69.9k17 gold badges110 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

One Parameter Selection = Multiple Parameters Selected SSRS/SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related