Unable to export table footers to xls and csv put works for prin using Tabletools?

James Payne

Hello,

I'm using Tabletools to export my data and everything is working fine except my column totals I have in the footer are not being exported when I copy to clipboard or export as a csv or xls. If I print the data it works fine.

Any ideas why this is happening?

I'm using the latest version of both datatables and tabletools. Here is my initialization code…

[code]$(document).ready(function() {
TableToolsInit.sSwfPath = "../library/swf/ZeroClipboard.swf";
$('#view_booking_forms').dataTable({
"sDom": 'T=<"clear"><"H"lfivp>rt<"F"ip>' ,
"bJQueryUI": true,
'bProcessing':true,
"bServerSide":true,
"bSort":true,
"sPaginationType": "full_numbers",
"sAjaxSource": "includes/datatable_form_parsers/view_booking_forms_parse.php",
"oLanguage": {
"sLengthMenu": 'Display 102550100250Allrecords…'
},
"fnFooterCallback": function ( nRow, aaData, iStart, iEnd, aiDisplay ) {
var iTotal = 0;
for ( var i=0 ; i

lightswitch05

I'm having this same problem, I know 'bFooter' is true by default, but I've set it to true just in case and it is still not included. Setting 'bHeader' works as expected, so have have not clue what is different about the footer. Any ideas would be greatly appreciated. I'm using the newest version of TableTools (2) that I pulled from the git hub
[code]
jQuery('#table_select').dataTable({
"bJQueryUI": true,
"sScrollX": "100%",
"sDom": '<"H"<"toolbar">lfrT>t<"F"ip>',
"aLengthMenu": [[5, 10, 25, 50, -1], [5, 10, 25, 50, "All"]],
"oTableTools":{
"sRowSelect": "single",
"aButtons": [
{
"sExtends": "copy",
"bFooter": true,
"mColumns": [0,1,2,3]
},
{
"sExtends": "xls",
"mColumns": [0,1,2,3],
"bHeader": true,
"bFooter": true
},
{
"sExtends": "pdf",
"bFooter": true,
"mColumns": [0,1,2,3]
},
{
"sExtends": "print",
"bFooter": true,
"mColumns": [0,1,2,3]
}
]
}
});
[/code]

nirant

hey guys
i am facing same problem
please some one give the solution for that....
thanks