Let me explain what I have: WorkItemID -- this number exists maximum 2 rows for each, 1 for each action code 10, and once for the second action code, 20, 21, or 23. I group my data together by LoginName then Month, Day, and then WorkItemID, so when Person1 worked on WorkItem1 on Jan 24th it got an action code of 10. Then on Jan 29th Person2 fixed WorkItem1 making the action code 21. There now exists two rows in my db one for person1 and one for person2 My Problem: I have a collapseable table which has the information Person1 worked on WorkItem1 - action code 10, because of this context I cannot check to see if WorkItem1 has also an action code of 21 (worked on my person 2) How can I use the lookup to return a true or false, if the same WorkItem worked by person1 got a 21 by person2 while in the context of person1? I need something like: Lookup(Fields!ActionCode.Value=21, Fields!WorkItemID.Value, Fields!ActionCode.Value,"DataSet1") Thanks In Advance

Hi, As you tried, you can use the Lookup Functions in Reporting Services is 2008 R2. Please first insert a new column, and then in the detail cell of the new column, type in the expression like =(LookupSet(Fields!WorkItemID.Value,Fields!WorkItemID.Value,Fields!ActionCode.Value,"DataSet1").Length>1) This expression will return a Boolean value indicate if the count of one WorkItemID is greater than 1. If yes, return True, otherwise return False.(Please correct the data field names and dataset name in the expression based on your report) For more information about the LookupSet function, please refer to: http://msdn.microsoft.com/en-us/library/ee210576.aspx Thanks, Tony Chain Tony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

This is helpful thank you, however, what I'm really looking for is to see if this workitem also has an action code of 20 or 21, in addition to the 10(by default)