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

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

elybelyb Posts: 2Questions: 0Answers: 0
edited September 2013 in TableTools
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]

Replies

  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin
    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
  • elybelyb Posts: 2Questions: 0Answers: 0
    alright thanks.
This discussion has been closed.