Forum Discussion
Solved
Syntax to join values from multiple table cells into one Table cell
Good day! I am attempting to join values from multiple table cells into one Table cell. Simple right?! Using =Join(Fields!XXX.Value, ", ") causes "#Error" to show up in the table cell, I assume be...
parry2k, many thanks!
As mentioned, I also tried Lookup with minor success. My issue remains that for each occurence of a name (it's actually an ID field), the joins are returned in each cell for as many rows as an ID occurs. I am going to test the creation of a separate Data Set, and remove the IDs from my main query/Data Set.
I will update this post if it works, but I have accepted your solution as well
Thanks again!
~San