not sure, you talking about partial matches? else why not just do a count of the id and check if your count is larger one for the given id?

not partial matches, it should be complete matchthank you

not partial matches, it should be complete match ..can you please explain in detail about the count approach thank you thank you

Hi There I could not really understand your requirement but if you think that not in not working for integer please put cstr(Fields!EmpNo.Value ) then I am sure it will work correctly. Please give some more details about your problem if that is not what you after If you have any question please let me know. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

How to perform NOT IN operation for integers, for example , employee id 2222 should be compared with other id's like 2222222, 543,455 etc... expression should return true as it doesnt match with any id's. As of now i have used employee id as string and for NOT IN expression i am using the following code, which only works for strings not for integers. =Iif(InStr("," + Join(Parameters!Bench_Closed.Value,",") + ",", "," + Fields!EmpNo.Value + ",")=0,True,False)thank you