SSRS filters using "IN"

Question

I am having a table. Now, I need to sort by multiple values and I am not able to do that. Is it possible to use the "In" expression in a table?

Field: =Fields!XYZ.value
Operator: IN
Value: ?????

The filter works only when I only use 1 value (123456).  However no results are displayed, when I add multiple values.
I have tried the following values

(123456,456789)
123456,56789
"123456","56789"
'123456','56789'

Any suggestions??

Answer 1

In SSRS, we have three different main places to filter the data

• T-SQL Script
• Dataset Filters
• Run-time Filter using Parameters

In order to create a filter, you must specify one or more filter equations. Expression, data type, operator, and value are included in a filter equation. 

Simple Expression: =LEFT(Fields!Subcat.Value,1)

Value: B, C, T

Explanation: All subcategory values that begin with the letters B, C, or T.

Simple workaroud : Try this to add filter 

Field(Expression): =(Fields!XYZ.value=123456) or (Fields!XYZ.value=56789)

Operator: =

Value: =true

You can enroll for SSRS Certification Training from Intellipaat to master the concepts of SQL Server Reporting Services