Parameters not accepting more number of values?

Hi Gautam

According to your description, it seems that you haven’t add the multiple parameter in the dataset correctly. To achieve your requirement, we can refer to the following two methods:

• Method1: Add a parameter in the where clause in the dataset
  
  1. Add the statement below to your dataset:
  
  Where field_name in (@States)
  
  2. In this way, the parameter is already added in the dataset with [@States] (=Parameters!States.Value )as the Parameter value, we needn’t modify it to =Join(Parameters!States.Value,",")
  


• Method2: Add a filter in the dataset or tablix
  
  1. Add a filter as below to your dataset:
  
  Expression: [field_name]
  
  Operator: In
  
  Value: [@States]

Reference:

Adding Parameters to Select Multiple Values in a List (SSRS)

If there are any other questions, please feel free to ask.

Thanks,

Katherine Xiong

---

Katherine Xiong

TechNet Community Support