Remove spaces when exporting
Posted on September 10, 2015 at 4:09am
I want a single page report in xls and csv,so I removed extra headers.But the problem is when exporting always spaces are being created in which column headers was there.I've added
<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="true"/><property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/>
these properties but the result is same.So my report seems like that in libreoffice calc.Any ideas?
Posted on September 16, 2015 at 7:51pm
If you don't have a page header, just delete it. I just added the property below and the excel came out just fine without any extra row.
<property name="net.sf.jasperreports.export.xls.exclude.origin.band.1" value="columnHeader"/>
Posted on February 24, 2016 at 6:13am
Juust Set the detail band property "Split Type" to "Prevent". OR edit the JRXML as thus:
<band height="27" splitType="Prevent">