I am getting an extra empty row between data when I am importing it from the database and formatting the report in Excel sheet.
EDIT (clarification from a comment): The output in Excel shows an extra blank row between records and and extra blank column between fields.
Best Answer
net.sf.jasperreports.export.xls.remove.empty.space.between.columns
andnet.sf.jasperreports.export.xls.remove.empty.space.between.rows
properties to report template.net.sf.jasperreports.export.xls.remove.empty.space.between.columns
- Specifies whether the empty spacer columns should be removed or not.net.sf.jasperreports.export.xls.remove.empty.space.between.rows
- Specifies whether the empty spacer rows should be removed or not.The sample:
The information about configuration properties is here.
The sample how to remove the whole line if the current textField is empty:
In case this design:
you will have a space between any two rows.
In case this design (textField height is equal to the Band's height):
the each line will be exactly under the other.