Show all records on 1 page

Show all records on 1 page

Ic3m4n69Ic3m4n69 Posts: 2Questions: 0Answers: 0
edited May 2012 in TableTools
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

Replies

  • allanallan Posts: 63,498Questions: 1Answers: 10,470 Site admin
    Use bPaginate : false .

    Allan
  • Ic3m4n69Ic3m4n69 Posts: 2Questions: 0Answers: 0
    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.
This discussion has been closed.