Update Total Footer for a column when a cell is modified RadGrid in EditMode="Batch"

[Raul]

Hello,

I have a RadGrid  with columns defined at design time (GridBoundColumn, GridNumericColumn), the grid is configured as EditMode="Batch", when the user clicks on a cell, the cell change to be editable,

I am using the built in feature to display aggreate functions on the grid (Aggregate="Sum"), the problem is that the user modify the value on a cell, but the value on the footer for that column do not be updated,

My expectation is, that each modification on the column, should be reflected on the total,

Could you pelase support me with that?

Thanks in advance,

[Angel Petrov]

Hello Raul,

I am sorry to say but in the current implementation of the grid this is not supported. You can however change the value manually by subscribing to the OnBatchEditCellValueChanged event and using JavaScript change the footer's cell value. Please note that if you click on the Save Changes button the value should get updated automatically.

Regards,
Angel Petrov
Telerik

[Ramey]

Angel,

Could you provide an example of this?

Thanks,

Ramey

[Angel Petrov]

Hi Ramey,

Attached you can find a sample web site which illustrates the approach. It is fully runnable just place the Telerik assemblies in the bin folder.

Regards,
Angel Petrov
Telerik

[Ramey]

Good morning Angel,

Thank you for your response, I opened the website and ran it and it ran properly except for when adding a new record it will give you NaN value.

Ramey

[Angel Petrov]

Hi Ramey,

Indeed your observation are correct. Attached you can find a modified version of the sample in which this problem is not reproducible.

Regards,
Angel Petrov
Telerik

[roy]

Hi Angel,

your solution is working perfectly for me as well - but:

for some reason it only works if the calculated column is the first column in the grid!

if i add columns before it i get an error since footerCell.children is empty

 

any ideas?

[roy]

so... can ignore the last post.... feel a little slow i missed the page loud function

so nevermind your code works perfectly for me