Tabletools only copy, save, excel on the first 10 records.

elyb

Im having problem with saving all records to excel.. its working but its only saves the first 10 records or the current display on my datatables..

any help.

here is my code
[code]
$('#group_table').dataTable
({

"sAjaxSource": "index.php/contacts/get_contacts_per_group/"+ gid,
"sServerMethod": "POST",
//Select and hide columns
"aoColumns": [ null, null,null,null,null,null,null],
"sPaginationType": "bootstrap",
"sDom": "<'row-fluid'<'span6'T><'span6'f>r>t<'row-fluid'<'span6'i><'span6'p>>",
"oTableTools": {
"sSwfPath": "TableTools/media/swf/copy_csv_xls_pdf.swf",
"aButtons": [ "copy","csv", "xls",'print' ]
},
'bServerSide' : true,
"aaSorting": [[ 1, "acs" ]],
"bPaginate": true,
"bSortClasses": false,
"bAutoWidth": true,
"bInfo": true,
"iDisplayLength" : 10,
"bScrollCollapse": true,
"bDestroy": true,

});
[/code]

allan

You are using server-side processing, so there are only 10 rows at the client-side and TableTools is client-side, so this is expected.

Allan

elyb

alright thanks.