SSRS parameter Single-select multiple selection

The previous period of time the company requires that the options for the report can be multi-selected.

After knowing the requirements, the research was implemented.

First we create a report and then add 3 datasets, 2 parameters, such as.

DataSet1 Data set: Holds master data.

Ddl_emplid Data set: Store number and name.

Ddl_paymon Data set: storage date.

Once configured, you will see multiple options in the preview screen. Select the employee and month you want to view, and click View Report

You can get the table.

This will give you the relevant data.

So how did we do it,

First, in the design page, right-click Parameters, in the General options, select Allow multiple values, and then, in the available values and Defaults option, select a dataset that has been prepared already. Such as.

With these settings, our parameters can be chosen more than once.

After the parameters can be multiple, you can pass the values of the multiple selection to the data source of the main data set.

This allows us to slice the string and then get the corresponding data in the database.

SSRS parameter Single-select multiple selection