Show all records on 1 page

Ic3m4n69

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

allan

Use bPaginate : false .

Allan

Ic3m4n69

Hi allan. Thanks for the quick reponse.

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.