How to keep a server-side calculated total row at the bottom of a DataTable?

How to keep a server-side calculated total row at the bottom of a DataTable?

MattMcgMattMcg Posts: 0Questions: 0Answers: 0
edited August 2013 in General
Hi, I've been having problems getting a Total row to work as the DataTable keeps sorting and moving it about. The main issues I'm having are because I'm using horizontal scrolling and a FixedColumn.

I originally put it in the footer but it seems the footer gets drawn in a separate table after the scroll bar, when I want it with the rest of the results.

I tried to use a callback event to manually clone, remove and then add the row back in to the correct location but this causes FixedColumn to error. It also ruins the styling as it puts two odd/even rows next to each other.

Is there anyway I can access the table data after it is sorted but before it is drawn and tell it that the total row must always be at the bottom?
This discussion has been closed.