Incorrect totals when grouping by multiple columns

[Mathew]

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

[Iana Tsolova]

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.

[Ryan Means]

Has this issue been fixed yet?

[Rosen]

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.

[ggomez]

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


Gerardo Gomez
Grupo Promotora Residencial

[Rosen]

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.