Bad excel export in jasperReports server

Hello everyone,

I created a report in jaspersoft and when I exported it in XLS with Jaspersoft studio everything was well rendered : 

After this export, I published it to the JasperReports Server but when I exported in Excel format, many things were missing (my chart, some data of the detail band, my image, ...) :

Is it possible to have a good Excel export with the JasperReports Server ?

Best regards.

iggythedog91's picture
Joined: Sep 20 2019 - 2:08am
Last seen: 2 years 9 months ago

2 Answers:

Hello again iggy,

If you want a good rendering in the XLS format, you need to place carefully your elements in yoaur report (no overlaping) and add this property in your report to render images / graphics (in the source tab) : 

<property name="net.sf.jasperreports.export.xls.ignore.graphics" value="false"/>
 

PS : You haven't got a missing line in the second report, it's just not aligned, change your column header and it should be fine

arnaudsimon091's picture
Joined: Nov 26 2018 - 12:25pm
Last seen: 4 months 3 weeks ago

Thanks again arnaudsimon091, it worked !

iggythedog91's picture
Joined: Sep 20 2019 - 2:08am
Last seen: 2 years 9 months ago
Feedback