Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Help Requested
  • FarhanAhmed's avatar
    FarhanAhmed
    4 years ago

    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"

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

  • FarhanAhmed's avatar
    FarhanAhmed
    Community Champion
    4 years ago

    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"