I have ten types of categories in one column. In which one category named as "Open". I have added parameter where I can see records which are either "NOT- Open" or ALL the records. I named parameter as "NOT-Open" with two values ALL - "A" and "Not Open" = "O" Now I am going into dataset in Filters tab. Filters has three columns in it. Expression where i selected =Fields!Category.Value Second one is Operator , I selected "Like" and third one is Value where I write one expression Here I need the help in finding out solution. IF I select "ALL" I should get all records including Open , if I select "Not Open" it Should show all the records EXCLUDING "Open". You can also get some reference from this question which is little linked to this question:- http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/690c53ab-53db-4a20-9da2-967c7853de9a Please let me know how could I exclude one value in expression.deepak

Hello, In the filter tab For the first column give the expression as below. IIF(Parameters!Parameter.Value = "O", Fields!Category.Value, "1") In the second column select like In the third column give the expression as below: =IIF(Parameters!Type.Value = "O", "Open", "1") Hope its clear & helpful....Pavan Kokkula Tata Consultancy Services.

I dont want records that are open, I want all the records which does not include "OPEN". Your expression gives me records which are open.deepak

Hello, In the filter tab For the first column give the expression as below. IIF(Parameters!Parameter.Value = "O", Fields!Category.Value, "1") In the second column select "like" In the third column give the expression as below: =IIF(Parameters!Parameter.Value = "O", Fields!Category.Value, "1") Now again click on Add and do the below: For the first column give the expression as below. IIF(Parameters!Parameter.Value = "O", Fields!Category.Value, "1") In the second column select "<>" In the third column give the expression as below: =IIF(Parameters!Parameter.Value = "O", "Open", "2") Hope its clear & helpful....Pavan Kokkula Tata Consultancy Services.

Pavan, Thats is correct solution. Thanks a lot. Thanks, Deepakdeepak