[#14176] - Break element is not working in Excel

Category:
Bug report
Priority:
Immediate
Status:
Resolved
Project: Severity:
Major
Resolution:
No Change Required
Component: Reproducibility:
N/A
Assigned to:

Actually the Break element is not working for excel. So we added the a text field beneath the break element and gave break after row property.
But in that case also the table is breaking and adding excess records at the last sheet. We couldn't resolve it.
Kindly share the solution.

AttachmentSize
Binary Data dtsapp_rptapp_defeventrprt_jasper.jrxml195.23 KB
v7.1.0
kaushikaraju1609's picture
Joined: Apr 22 2022 - 2:58am
Last seen: 3 months 6 days ago

4 Comments:

#1
#2
  • Status:New» Feedback Requested
  • Assigned:nobody» shertage

Hi please specify a valid version of JSS where you tried the feature.
If you used an old one, I see it's marked 7.1.0, please add feedbacks after testing your use case with a more recent version of JSS.

I'm moving the bug to JR project since it seems something mostly related to the break element and Excel exporter.

Regards,
Massimo.

#3
  • Resolution:Open» No Change Required

Hi, try to run your report using the following settings (see the attached report):
- for the report:
<property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="false"/> instead of true
- for the first table in the report:
completely remove the <property name="net.sf.jasperreports.export.xls.break.before.row" value="true"/> property
- for the break element:
completely remove the <property name="net.sf.jasperreports.export.xls.break.after.row" value="true"/> property

Please let us know if it also works for you.
Regards,
Sanda

AttachmentSize
Binary Data dtsapp_rptapp_defeventrprt_jasper.jrxml195.06 KB
#4
  • Status:Feedback Requested» Resolved
Feedback
randomness