[Solved] Totals Row Workaround

[Rick Glos]

Hello,

I see from this thread and this thread that you are working towards adding a grand total row / footer.

I have a client requesting that we add a totals row and wanted to get your thoughts and input.

I'm using the telerik grid to sit on top of a Microsoft Analysis Services Cube.  I use a fairly complex MDX statement to pull data back into the webservice, populate a POCO object collection and then I bind the grid to that collection.

Couple of thoughts/concerns:

1. I'm not sure I want the Telerik grid to do the summarizing.  It may be easier to just pull back the totals row using MDX and use that to create a 'GrandTotal' row object.  Especially in cases like Gross Margin Percent, it's not a sum calculation - you need the detail.
2. I could just throw the row into the grid but then it will sort and filter - don't want that.
3. Could I programmatically remove and re-insert the row whenever the grid is filtered or sorted?  (seems like too much work).
4. Maybe throw a second grid on the page, with the same column widths as the first grid so it lines up correctly, and bind it to the GrandTotal row?  If the user resizes the 1st grid, I'll have to resize the grandtotal grid.  Does this seem like a good solution?

Really looking for your thoughts ideas as I have no-one else to ponder this with.

[Vlad]

Hi Rick,

Our totals row will be very similar to RadGrid for ASP.NET AJAX:
http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/aggregates/defaultcs.aspx

The row will be outside of the scrolling area (static) and the row cells will respect columns width, order and horizontal scrolling.
Every column will have Aggregate property where you can select desired aggregate function plus you will have special event for custom calculations.

Let us know what you think.

Vlad

[Alvaro]

Hi Vlad,

Do you have an exact ETA on when this feature will be available?  The lack of an aggregate footer is pretty much a show-stopper for us.  We're now considering the ASP.NET RadGrid, but that has its own issues, such as the fact that it goes back to the server for sorting, column filtering, and paging.  *sigh*

Thanks,
Alvaro

[Milan]

Hello Alvaro,

This feature will be introduced in our Q2 release which is expected to ship in early July.
All the best,
Milan
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.