javajspreportingexport-to-exceldisplaytag

Exporting data with Display Tag and external pagination

We use the Display Tag Library to display grid data in our JSP's.

We use external sorting and pagingation. And we also use the library's export feature to allow exporting to Excel or PDF.

Issue is the export is only exporting the data on the current set of results (ie: rows 20-40) while we want the export to include all rows.

Anyone know how to do this?

I believe this works automatically when you are NOT using external sorting and pagination as Display Tag has the entire resultset and includes it all in the export. However we are using the external sorting/pagination..

Solution

  • Appears this is indeed a known issue.

    Our solution

    //Determine if user is doing an export
boolean export = request.getParameter(TableTagParameters.PARAMETER_EXPORTING) != null;

if (export) {
    //Return entire list
} else {
    //Return paginated list
}