Wednesday, July 23, 2014

How can i convert LookupSet result, which is in array, into comma separated? SSRS

You can convert array to comma separated string by using Join() function.

=JOIN(LookupSet(Fields!ID.Value, Fields!ID.Value, Fields!Name.Value, "Sections"),",")


Syntax:
LookupSet(source_expression, destination_expression, result_expression, dataset)



No comments:

Post a Comment

React-select is very slow on larger list - Found solution - using react-window

 I had more than 4000 items in searchable dropdownlist. I have used react-select but it was very slow. finally I found complete solution to ...