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

Help with grouping

1 Answer 13 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Zack
Top achievements
Rank 1
Zack asked on 24 Jul 2013, 03:37 PM
Hello I'm looking for a way to group my data, and would like to know if it is possible to do.

It is possible for one record to exist multiple groups, and I would like to display this somehow.

Ex: Records:

AccountId - DimensionId - DimValue

Account1 - Dimension1 - 000
Account1 - Dimension2 - 213
Account1 - Dimension3 - 390

Account2 - Dimension1 - 000
Account2 - Dimension2 - 240
Account2 - Dimension3 - 300

Account3 - Dimension1 - 000
Account3 - Dimension2 - 240
Account3 - Dimension3 - 290

Account4 - Dimension1 - 000
Account4 - Dimension2 - 240
Account4 - Dimension3 - 610

Account5 - Dimension1 - 000
Account5 - Dimension2 - 240
Account5 - Dimension3 - 610

I want my report to display something like this:

000
213
390
Account1
390
213

240
300
Account2
300

590
Account3
590

610
Account4
Account5
610
240
000

Is this possible

1 Answer, 1 is accepted

Sort by
0
Elian
Telerik team
answered on 29 Jul 2013, 10:26 AM
Hello Zack,

This seems doable. You can  group by dimensions. 
Sample group hierarchy:

Group1 - Dimension1
Group2 - Dimension2 (child to 1)
Group3 - Dimension3 (child to 2)

and you will have the Dimensions value in both the GroupHeader and GroupFooter section to have the desired layout. 
 

Regards,
Elian
Telerik

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

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