Multivalue Column cells by group

[Waqas]

Hi
 I'm making a report in which i have a table consisting of two columns, let we have ColumnA and ColumnB, the values of ColumnB
are grouped by ColumnA. The report generates a separate cell for every value of ColumnB but I want  all the values of ColumnB that belongs to a particular value of ColumnA to be in one cell, separated by comma. 

I've attached a snapshot of the two columns, and what I'm doing is to put the values of the 2nd column in a single cell separated by comma. Your help would be greatly appreciated and Sorry for my poor english, I hope you understand it.

Thanks

[Stef]

Hi Waqas,

There are a lot of approaches which depends on your data and desired report structures. A possible approach using your current result, would be to add a static row in the group and use similar to this user-defined aggregate function to achieve the desired text formatting. You can find attached an example report illustrating the described approach.

Regards,
Stef
the Telerik team