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

Grouping

2 Answers 28 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Chris Thierry
Top achievements
Rank 1
Chris Thierry asked on 07 May 2012, 05:02 PM
Hi, I have a stored procedure that returns for example, a Company column, SubCompany column and TotalCharges like this:

Company SubCompany TotalCharges
A AA 30
A BB 40
B CC 15
B DD 20

I want a report grouping by Company only and sum of TotalCharges with a GrandTotal like this:

Company TotalCharges
A 70
B 35
Total 105

Is there any way to do it? I can modify my stored procedure to bring this information already from the database, but I want to use the same stored procedure without any change because I'm using it in another report.
I really don't know if I need to use a Table or some other control, I'm new with this sorry!
I'm using Telerik Reporting 5.1.11.928 for a Silverlight Project
Thank you.

2 Answers, 1 is accepted

Sort by
0
Squall
Top achievements
Rank 1
answered on 07 May 2012, 05:12 PM
Hi Chris,

Check out the crosstab wizard and select as row group the Company field and use the sum aggregate for the TotalCharges.

SN
0
Chris Thierry
Top achievements
Rank 1
answered on 07 May 2012, 06:11 PM
Perfect Thank you!
Tags
General Discussions
Asked by
Chris Thierry
Top achievements
Rank 1
Answers by
Squall
Top achievements
Rank 1
Chris Thierry
Top achievements
Rank 1
Share this question
or