Grid w/ Sum at Footer

[Deamon]

How would one go about changing the demo at ...

http://demos.telerik.com/aspnet-mvc/grid/editing

to incorporate a footer that includes the total sum (or sum of shown items, whichever is easier) of the price field?  I was able to use Aggregates and ClientFooterTemplate to get a sum to show, but I want it to update as you lose focus of the control that contains values that affect the sum.  

So for example, when you delete a record the sum should reflect the change.  If you add a new record, enter a value and exit the control the value should change.  Also, if you edit the value of an existing price and exit the control (lose focus) the sum at the bottom should update.

Also, I'd like access to the sum in the footer client side (via jQuery?) for other actions. 

Any pointers?

G

[Kiril Nikolov]

Hello Deamon,

I would suggest you to turn on the autoSync() option of the dataSource, so data is automatically saved when changed and therefore the aggregates are relculated. It should be like this:

.DataSource(dataSource => dataSource
        .AutoSync(true)

As for accessing the aggregates values = you can do it with JavaScript like this:

$("#Grid").getKendoGrid().dataSource.aggregates() //where "Grid" is your Kendo UI Grid Id

Regards,
Kiril Nikolov
Telerik

 

 

[Deamon]

Perfect, thanks for the info.