Hi Folks,
Did anybody try exporting a grid report starting from any custom row number ? Is it possible ?
Thank you in Advance.
2 Answers:
Hi,
This output could be obtained based on print when expressions for elements in the detail band and exporter filter by key properties.
If you need to print out rows starting from 16, for each element in the detail band you need to place 2 textfields: one having the print when expression $V{REPORT_COUNT} < 16 and key="test" setting, the other having the print when expression $V{REPORT_COUNT} > 15 and no key attribute set.
Add these properties in the JRXML file:
<property name="net.sf.jasperreports.export.xls.exclude.key.test"/>
<property name="net.sf.jasperreports.export.xlsx.exclude.key.test"/>
Also, the net.sf.jasperreports.export.xls.remove.empty.space.between.rows property should be set in order to remove the empty rows which are generated instead.
I hope this helps,
Sanda
