I am trying to return multiple column fields using a lookupset but it seems like it can only return a single field at a time. What is the alternative or how can i change my code to return multiple fields. =Join(LookupSet(Fields!contactid.Value, Fields!customerid.Value, Fields!new_mailname.value, "relationship"),",")

Is it possible to return two fields via a lookupset. if not what command do i use.

Hi bhogiyogi, LookupSet function could only return a single datafield at a time, this is by design. If you want to return more datafields, you should make use of the LookupSet function again to return other datafields. For more information about LookupSet function, please refer to SSRS2008 R2 new feature at this link http://cid-45bfd76b0f2c3808.photos.live.com/view.aspx/picture/SSRS2008%20R2%20New%20Feature.docx Thanks, Challen Fu

Challen, Your response does not seem to answer the question. bhogiyogi is asking whether we could return multiple feilds using LOOKUPSET function. You seem to suggest LOOKUPSET over LOOKUP. He is already using LOOKUPSET function. BTW, I'm running into the same issue. Please let me know if there are other alternatives. Thanks, SJ satish jayanthi