in operator filter

[taruna1]

i am trying to use the in operator on a table in the grouping and sorting windows - filter tab.
Expression := left(fields!field1.value,1)
Operator:= In
Values:= 1,2

I have tried multiple combinations (1,2), "1","2". None of them seem to work.

Would anyone know what is the correct syntax to use the IN operator on the table?

Thanks,

 

[MSBusIntel]

I have the same problem.

I am trying to filter a dataset with values from a parameter.

If I want to filter by one value, easy enough but if I want to remove the filter or filter by all values, I hit this problem.

expression: =Fields!ClientFirstCode.Value
Operator: IN
Value: =iif(Parameters!Scope.Value=1,1,"1,2")

I am not sure about the correct syntax to use to get this expression to accept multiple values.

Any help is appreciated.

Ta

 

[jymm]

I do it in the sql

so in the sql where I have

where
... and
 (CustomerName IN (@CustomerLabel) OR 'ALL' IN (@CustomerLabel))

and my @CustomerLabel is a multi select parameter of all of my customer names that is defaulted to ALL

this way the user can control it when their needs change. This help or hinder?