This is a migrated thread and some comments may be shown as answers.

Multivalue Column cells by group

1 Answer 14 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Waqas
Top achievements
Rank 1
Waqas asked on 10 Apr 2013, 07:38 AM
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

1 Answer, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 15 Apr 2013, 10:42 AM
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

Have you tried the new visualization options in Telerik Reporting Q1 2013? You can get them from your account.

Tags
General Discussions
Asked by
Waqas
Top achievements
Rank 1
Answers by
Stef
Telerik team
Share this question
or