Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to 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"
Proud to be a Super User!
I don't know. Could string_split function be used in the procedure to accomplish this? I tried, but didn't manage.
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"
Proud to be a Super User!