Parameters with multiple values in SQL / SSRS 2005

Hello,

If I understand correctly, you want to filter the report data based on the field "Column_name": the values of "Column_name" exist in the drop-down list of the multiple-value parameter "Param", or the value "Column_name" is NULL. And then you can specify the filter condition as follows:

1.Expression:=IIF(Instr(Join(Paramsters!Param.Value),Fields!Column_name.value)>0 or IsNothing(Fields!Column_name.value) ,true,false)

(Select "Boolean" on the second drop-down section ).

2. Select “=” from Operator drop-down list.

3. Type in “=true” in the Value textbox.

If I have any misunderstanding, please let me know.

Regards,

Fanny Liu

---

Fanny Liu

TechNet Community Support