Forum Discussion
Repeat values in one text box seperated
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!
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"
2 Replies
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"