Pagination

[alexlewer]

Is there any support currently for pagination within the reports?

[jdorn]

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]

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]

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