Hello everyone!
I can`t find a solution to the following problem in SQL Server Reporting Services 2005.
I created a table which has multiple columns. It can happen, that some columns have the same values for multiple rows, only the most right column has different values. For example
Column 1 | Column 2 | Column 3
aaa | bbb | 1
aaa | bbb | 2
ccc | ddd | 3
and so on...
But I want it to look like this:
aaa | bbb | 1,2
ccc | ddd | 3
so that in column 3 there are all values that have the same values in column 1 and 2.
How can I do that? Any help is appreciated. Thanks in advance.