Chris Thierry
Top achievements
Rank 1
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.
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
0
Squall
Top achievements
Rank 1
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
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
Rank 1
answered on 07 May 2012, 06:11 PM
Perfect Thank you!