Grouping

3 posts, 0 answers
  1. Chris Thierry
    Chris Thierry avatar
    138 posts
    Member since:
    Jun 2010

    Posted 07 May 2012 Link to this post

    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. Squall
    Squall avatar
    174 posts
    Member since:
    Feb 2011

    Posted 07 May 2012 Link to this post

    Hi Chris,

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

    SN
  3. DevCraft banner
  4. Chris Thierry
    Chris Thierry avatar
    138 posts
    Member since:
    Jun 2010

    Posted 07 May 2012 Link to this post

    Perfect Thank you!
Back to Top