Show all records on 1 page
Show all records on 1 page
Ic3m4n69
Posts: 2Questions: 0Answers: 0
Hi,
I just started using TableTools today and I am extremely happy with the exporting to Excel and PDF functionality. But I need a way to show all records on a single page, no matter how many records there are.
I know that this has been the topic of multiple discussions but none of the solutions are working for me.
I have been able to hide all the controls that I do not need such as,
1. search filter
2. show entries
3. pagination "Previous" and "Next"
However, I cannot get all the records to display, its only showing the first 10 rows, and since I have disabled the "Show entries" control, I cannot view any of the other entries.
[code]$('#rptTable').dataTable({
"sDom": 'T<"clear">r',
"oTableTools": {
"sSwfPath": "/assets/plugins/DataTables-1.9.1/extras/TableTools/media/swf/copy_csv_xls_pdf.swf",
"aButtons": ["xls", "pdf"],
"bPaginate": false
}
});[/code]
Any help on this would be highly appreciated.
Ic3m4n69
I just started using TableTools today and I am extremely happy with the exporting to Excel and PDF functionality. But I need a way to show all records on a single page, no matter how many records there are.
I know that this has been the topic of multiple discussions but none of the solutions are working for me.
I have been able to hide all the controls that I do not need such as,
1. search filter
2. show entries
3. pagination "Previous" and "Next"
However, I cannot get all the records to display, its only showing the first 10 rows, and since I have disabled the "Show entries" control, I cannot view any of the other entries.
[code]$('#rptTable').dataTable({
"sDom": 'T<"clear">r',
"oTableTools": {
"sSwfPath": "/assets/plugins/DataTables-1.9.1/extras/TableTools/media/swf/copy_csv_xls_pdf.swf",
"aButtons": ["xls", "pdf"],
"bPaginate": false
}
});[/code]
Any help on this would be highly appreciated.
Ic3m4n69
This discussion has been closed.
Replies
Allan
I was using "bPaginate": false but I just had in the wrong place.
It took me a while to figure out that I had it in the TableTools initialisation instead of the DataTable initialisation.
The plugin is amazing btw. Great job! Will definitely be using it more often.