Footer total in Batch Edit Mode

[Ramey]

Hello,  I was wondering is there a current way that I can implement Client-side calculations in a Grid Footer while but having the Grid set to Batch Edit Mode?  I saw an example on implementing this using a template column as well as set the value of a totals column based on two separate columns calculations but I was wondering about setting the footer to a total.

Thanks,

Ramey

[Viktor Tachev]

Hi Ramey,

Please examine the following article that illustrates similar behavior.

• http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/data-editing/edit-mode/batch-editing/how-to/update-calculated-column-client-side

You can use the same approach to iterate through the cells of a given column and perform the necessary calculations. Then, you can get reference to the footer in that column and update its contents.

Regards,
Viktor Tachev
Telerik

[Ramey]

Viktor,

Would this approach work with just a GridBoundColumn?  I can't use a template column for this field because it would mess up the way the batch editing is working with the batchExtentionsManager.js.  

[Viktor Tachev]

Hi Ramey,

The approach would work for GridBoundColumns and GridTemplateColumns. One method you can use to update the footer is to iterate through all cells and calculate the result.

Another approach is to use the BatchEditClosed handler as in the  and calculate the result based on the current value in the footer and the value entered by the user.

If you would like the footer to show an aggregate for all items that the RadGrid is bound to you can use the approach described below:

• http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/how-to/totals-in-grid-footers#displaying-totals-for-all-grid-pages

Regards,
Viktor Tachev
Telerik