Bad excel export in jasperReports server

[iggythedog91]

Hello everyone,

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

/sites/default/files/user_uploads/iggythedog91/2019-09-20_12h38_13.png

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, ...) :

/sites/default/files/user_uploads/iggythedog91/2019-09-20_12h39_00.png

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

Best regards.

[arnaudsimon091]

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

[iggythedog91]

Thanks again arnaudsimon091, it worked !