in operator filter

[jmk418]

Hi all
I am trying to filter a table in reporting services 2005 using the "In" operator. If I use the following code then I get results back but I cannot figure out how to add other requirements.

 =("e")

I have tried the following all with no success.

 =("e, f")

 =("e"), ("f")

 ="e, f"

Does anyone know what the correct syntax is?

Thanks in advance.

 

[unclerico]

i haven't used RS 2005, but try

=("e","f")

 

[jmk418]

That gives an error too.

 

[unclerico]

the filter you are applying is on the table iself in the report designer and not in your SQL statement correct??

 

[jmk418]

Correct. In my stored procedure I am returning all codes (a - i) so that I can display the number of each in a graph but I wanted to use the same stored procedure in a table below the graph but only display certain codes (e - i) in the table. This can be done using multiple OR statements in the table filter but I would like to clean it up and use an IN statement.