Incorrect totals when grouping by multiple columns

6 posts, 0 answers
  1. Mathew
    Mathew avatar
    11 posts
    Member since:
    Dec 2007

    Posted 09 Oct 2008 Link to this post

    Hi,

    I'm using RadGrid to sort and group our financial data. However, if I group the data by more than one column, the totals (sum) for any groups other than the last are incorrect. In case my TSQL code was to blame I replicated the problem using a very basic Northwind query.

    If you look at the image below, you can see that the total for the ContactName group is incorrect. It appears that RadGrid is providing the sum for the last record in each OrderID group only. I have added asterisks to the screenshot to show you what I mean.

    http://img258.imageshack.us/img258/2448/northwindgroupingym6.png

    Have I misunderstood how grouping aggregates are meant to work, or have I missed a step, or is this a bug?

    Many thanks,
    Mat.


    Telerik RadControls 2008.02.0826.35
    ASP.NET v3.5
    Windows XP SP3 v3311
    Firefox 3.0.3
    IE 7.0.5730.13

    The query I used on the Northwind SQL Server 2000 database:

    select 
        c.ContactName 
        , o.OrderID 
        , d.ProductID 
        , d.UnitPrice 
    from 
        Customers c 
    join 
        Orders o 
        on c.CustomerID = o.CustomerID 
    join 
        [Order Details] d 
        on o.OrderID = d.OrderID 
  2. Iana Tsolova
    Admin
    Iana Tsolova avatar
    3388 posts

    Posted 14 Oct 2008 Link to this post

    Hi Mathew,

    Unfortunately you are right that RadGrid is not calculating totals properly when grouped by more than one column. This is a known issue and we are working on solving it.

    Please excuse us for the inconvenience.

    All the best,
    Iana
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Ryan Means
    Ryan Means avatar
    32 posts
    Member since:
    Dec 2006

    Posted 24 Mar 2009 Link to this post

    Has this issue been fixed yet?
  5. Rosen
    Admin
    Rosen avatar
    3234 posts

    Posted 27 Mar 2009 Link to this post

    Hi Ryan,

    Unfortunately we are still in a search for resolution for this issue. Please excuse us for any inconvenience this may caused you.

    Greetings,
    Rosen
    the Telerik team

    Check out Telerik Trainer , the state of the art learning tool for Telerik products.
  6. ggomez
    ggomez avatar
    1 posts
    Member since:
    Aug 2008

    Posted 31 Mar 2009 Link to this post

    there are any forecast of when this issue will be fixed?


    Gerardo Gomez
    Grupo Promotora Residencial
  7. Rosen
    Admin
    Rosen avatar
    3234 posts

    Posted 01 Apr 2009 Link to this post

    Hi ggomez,

    I'm afraid that we cannot commit to exact timeframe of when this issue will be addressed. However we will do our best to addressed it for feature versions of the control.

    Sincerely yours,
    Rosen
    the Telerik team

    Check out Telerik Trainer , the state of the art learning tool for Telerik products.
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017