search

jdorn / php-reports

A PHP framework for displaying reports from any data source, including SQL and MongoDB
http://jdorn.github.com/php-reports
GNU Lesser General Public License v3.0
478 stars 235 forks source link

Pagination #142

Open alexlewer opened 10 years ago

alexlewer commented 10 years ago

Is there any support currently for pagination within the reports?

jdorn commented 10 years ago

no built in support. You can fake it with VARIABLE headers thouugh:

-- VARIABLE: {name: "page", default: "1"}

SELECT * FROM MyTable LIMIT {{ (page-1)*20 }}, 20
blades commented 9 years ago

another option is to play with the dataTables implementation in the templates/xxxx/html/report_content.twig file.

if you remove the 'pagination:false' javascript declaration, and you don't mind mucking about with the css a little, you can easily get dataTables to do the pagination work for you. of course, it still downloads the entire dataset and then paginates it in-memory, but it's better than not having that capability at all, imo.

acrodea-vinh commented 7 years ago

After changed bPaginate: false to bPaginate: true, how to change css to display pagination?