1- SSRS filters using "IN"

487 Asked by AryanKhan in Tableau , Asked on May 12, 2021

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??

Answered by Bella Blake

In ssrs filter in, 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 workaround : Try this to add filter

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

Operator: =

Value: =true

1- SSRS filters using "IN"

Your Answer