SSRS distinct lookupset function URGENT

Hi jhowe1,

According to your description, you are using Lookupset function to return sequence numbers. The problem you are facing is that it returns multiple sequence numbers, and you want to remove the duplicate values.

By design, Lookupset function returns the set of matching values for the specified name from a dataset that contains name/value pairs where there is a 1-to-many relationship. LookupSet does the following:

• Evaluates the source expression in the current scope.


• Evaluates the destination expression for each row of the specified dataset after filters have been applied, based on the collation of the specified dataset.


• For each match of source expression and destination expression, evaluates the result expression for that row in the dataset.


• Returns the set of result expression values.

Multilookup Function returns the set of first-match values for the specified set of names from a dataset that contains name/value pairs. In this case, we can use the function like below:

=Join(MultiLookup(Split(Fields!itemId.Value & Fields!UseByDate.Value & Fields!rackId.Value,","), Fields!itemId.Value & Fields!UseByDate.Value & Fields!rackId.Value, Fields!CustomerSeqNo.Value, " PickingList"),",")

For more information about Multilookup Function, please refer to the following document:

http://ift.tt/1uHPfkV

If you have any more questions, please feel free to ask.

Thanks,

Wendy Fu

If you have any feedback on our support, please click here.