How to split XLS document according to some condition - How-To - Jaspersoft Community

Jump to content

We've recently updated our Privacy Statement, available here ×

How to split XLS document according to some condition
By akonkin

November 25, 2014
Features: Exporters Version: v5.6.1
Share

Followers 0
The desired solution can be implemented with the export to XLS and the properties that I quote below:
net.sf.jasperreports.export.xls.break.before.row net.sf.jasperreports.export.xls.break.after.row
With these properties you can perform the export to XLS, but split it to separate worksheets according to the aforementioned properties in the report.
Below I give you a link to the documentation regarding this property:
http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.break.before.row
Please find a sample of the report that is based on Foormart database.
Best regards,
Alex

report2.jrxml
Table of contents
Share
Followers 0
Go to entries

User Feedback
- 1 Comment
Recommended Comments

tahmid.tee10 0

Posted February 27, 2020

Share this comment

Hi Alex,
I was under similar situation. So this is what I did to solve my problem:

Add a blank 'Text Field' element.

Added the property (net.sf.jasperreports.export.xls.break.after.row) you mentioned about to that text field element.

The added 'Print When' expression (the conditional expression that you would like to add) to that blank text field.

Link to comment

Share on other sites

This is now closed for further comments

×

×

Create New...