Hi I am ready to break my laptop. I can't get the goddamn IN clause to work when filtering a table dataset. I bring back some rows. I only want to display rows that contain a certain "TextString". I have tried everything that I can find on using IN filters. Expression = [CLM_LABEL] IN Rx; Medical; Dental ="Rx, Medical, Dental".Split(",") Rx, Medical, Dental I have tried all of these and more and none seem to work. Very frustrating, there is no information on Expressions. Thanks in advance.

I forgot to mention. If I only include one value in the Value area, like "Rx", it will show only the rows containg Rx. So this does work, but using multiple values does not.

Hi , Make sure you are typing the correct txt in the Value box. Here iks what i did. I created a simple report with Adv Works DB and i have shown only 3 countries' Sales Amt. I went to the Table filters and added the following text Fields!Country.Value In Australia, Canada, United States This was perfectly showing up in my report HTH, Ram

Hey Thanks for your help. This helped me. I made a stupid mistake though, I had a filter on the table and then one on the group. The one on the group was causing the one on the table to never work. So I deleted it and all is good again.