Repeat values in one text box seperated

[Anonymous]

Hi 

My question is simple, but so am I so can't solve it. I return all of my data in sql queries/procedures.

In header of the report I use one text box. This text box should show all values from the same field separated by a comma: value1, value2, value3 ...

But as it is a text box, the report builder wants an aggregating function on that text box. So I could return one of the values, but not all. How do I overcome this? 

Thank you!

[Anonymous]

I don't know. Could string_split function be used in the procedure to accomplish this? I tried, but didn't manage.

[FarhanAhmed · Accepted solution]

You need to return your field value as parameter in dataset and then use it in textbox by using JOIN operator

=Join(Parameters!ProductProduct.Label,",")

make sure that you return Distince values for your parameter.

Since your field may be returning all values in your data. 

You can return your field values as parameter and can make its type "Internal" and "Multiple Value"