Move a row from tbody to tfoot

rstelow

My ajax resultset contains both detail rows and a total row. How can I move the total row from the tbody section to the tfoot section? Would like to allow sorting that does not include total row and apply different styling.

allan

You would need to use fnServerData (in 1.9-) or `ajax.dataSrc` (in 1.10+) to modify the data result from the server to split the result set into the two components and then use fnInitComplete to write the footer information into the footer.

Allan

dstelow

Same question as above except the data is an existing array (with both detail rows and a total row) used to initialize the table (using aoColumns). After the table has been initialized (or during), how can I move the total row (easily identifiable) from the body to the footer?