| Category: | Enhancement request |
Priority: | Normal |
Status: | New |
| Project: | Severity: | Feature |
Resolution: | Reopened |
|
| Component: | Reproducibility: | N/A |
Assigned to: |
Hi, I would like to be able set Print Titles when exporting to Excel so that I can make the column-names (in the header) appear at the top of every page when I print the report to paper.
Here is some background: http://community.jaspersoft.com/questions/800611/setting-print-titles-when-exporting-excel
Q:
"Hi,
I have a jasper report that exports to excel. It has a header that I would like to appear on each new page when I print the report from Excel. This can be achieved by doing this. However, I would prefer to not have to set this up manually each time I generate a new report. Is it possible to configure this using jasper/ireport instead? If so, how do I go about doing this?
Thanks in advance"
A:
"This is not something that can currently be configured within the report design. I would recommend logging it as an enhancement request in the tracker."
Best regards
Gabriel
2 Comments:
I have been able to extend JRXlsExporter.java to provide my own implementation that utilizes Apache POI library in order to accomplish the this. You can further add more formatting details to it according to your needs. In addition to that you can configure your jrxml by adding the following custom property.
Jasper Report jrxml Custom Property:
I also introduce a new feature to Jasper Report 5.0.1 with the following custom custom property for repeating rows. Following line needs to be added to each Jasper report that needs to have repeating rows, if we don’t add the following line then I have already introduced the default to be 2:4 repeating rows.
property name="net.sf.jasperreports.export.xls.repeating.rows.range" value="1:4"
Hello. I use your customjrxlsexporter.java, added jar to class path, but in excel nothing changed. what was i miss?