topic Repeat values in one text box seperated in Report Server

Repeat values in one text box seperated

Anonymous — Thu, 21 Apr 2022 12:33:22 GMT

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!

Re: Repeat values in one text box seperated

Anonymous — Fri, 22 Apr 2022 11:54:36 GMT

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

Re: Repeat values in one text box seperated

FarhanAhmed — Mon, 25 Apr 2022 03:04:38 GMT

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"