JasperReports Server does not insert page breaks in XLSX while Studio does

0

I'm having a problem with JasperReports Server 5.6.1 (and other versions too) with inserting page breaks when I export to xlsx.

Page breaks works as expected on web pages and on Jaspersoft Studio (in xlsx format), but JasperReports Server does not.

Has anybody else experienced this problem? It's kind of strange that JasperReports Server does not work in a similar fashion as Jaspersoft Reports.

hozawa's picture
66920
Joined: Apr 24 2010 - 4:31pm
Last seen: 1 year 5 months ago

1 Answer:

0

This is caused by differences in default values. Setting properties resolved the problem.

Resolved by adding the following properties in the report:

<property name="net.sf.jasperreports.export.xls.collapse.row.span" value="false"/> <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="false"/>

There's a bug in JasperReports 5.2 which seems to ignore these properties so be sure use 5.6.x or above.

hozawa's picture
66920
Joined: Apr 24 2010 - 4:31pm
Last seen: 1 year 5 months ago
Feedback