Table Pagination on xls export


I've been working with Jasper Reports 5.0.0 for a few months now, and our company just moved to the new 5.5.0 server version. My problems began with the Table component and Ignore Pagination - for some reason the Ignore Pagination option is no longer honored on any export format for our current reports built with Ireport 5.0, nor on the newer Ireport 5.5 or Jasper Studio 5.5. We use Jasper Server 5.5.0 and call the reports via java servlet & create xlsx exports using POI 3.8.

i've searched the wiki's and answers for any way to restore non-pagination to xlsx format exports to no avail. some of the properties i've included are: (default setting)



and key:

<jr:columnHeader style="table 2_CH" height="30">
<reportElement key="col_header" x="0" y="0" width="90" height="30" uuid="89845e64-9344-4816-8820-b789bc02ffda"/>

as found in:

but unlike in that answer, the table header is removed for all instances including the first, so all we get out is the data, but pagination is removed. it seems the net.sf.jasperreports.export.xls.exclude.origin.keep.first.key.col_header does not work, but the exclude.key does. our tables reside only within the detail band, with Column Header/footer bands removed.

I have also added a parameter to the java report calls to ensure IS_IGNORE_PAGINATION is set to "true" for every report execution.

is there any way to get Ignore Pagination honored again? included is a sample report from Ireport Designer 5.5.0 that i've been testing with.


Thank you in advance for any help.

nicholas.good's picture
Joined: Jan 2 2014 - 12:17pm
Last seen: 9 years 2 months ago

Did you find a solution to this issue??

rang90 - 8 years 8 months ago

I am having the same problem as you and I was wondering if you ever found a solution.

Any help is greatly appreciated.

Thank you!

kiss_m3_girl - 8 years 2 weeks ago

0 Answers:

No answers yet