I’m juggling with Report Builder and I need to build a string composed by the concatenation of values of in a column. In the example attached Concatenate.rdl (11.3 KB)
I have values from A to F and the result should be A, B, C, D, E, F
I’m trying to use the Join function which should do the trick but I always get an #Error.
Why is that? What I’m doing wrong?
Thanks for help
Bumping this post for more visibility from our experts and users.
Hi @Sue - Can you help with Paginated question.
Hi Roberto, I haven’t had to use this before, however I think the problem is that you need to iterate over the Class.Value column to gather all the values before you can then join.
Have a look at this post and this may help you
Let me know how you get on and if that doesn’t work, we can have another look,