Pass multiple values in SSRS

passing multiple values to parameter

{continue with previous}

Here it requires single value for uotput 

But we need to pass multiple values.So follow the steps

 

Step 1: Edit your dataset1 by double clicking on it.The wizard will open,there you can modify query i.e., Instead of  "=" put "IN" clause.(See below figure)

Step 2: 

Add the another data set like as previously created dataset1,here you can select distinct of deptno from EMP table

Select the data source which is all ready exists (if not exists create one more with different data source and the field must be contain same data type) from the drop down list 

Select datasource and write the query,then click OK

Step 3:After clicking OK, you will find dataset 2 with selected fields from query

Step 4: Goto parameters on REPORT DATA -->right click on @DEPTNO (parameter name) -->click on Allow multiple values --> clock OK

Step 5: Now click on PREVIEW, choose any value or multiple values--> click on view report

Step 5: You will get Result like below