Jaspersoft 5.6.1 server Image - Lock position in Excel export

[Sreerambabu Palaniswamy]

I've designed a Jasperreport using studio 5.6.1 which has got images. When I export to excel from Studio, it works fine. When I upload to the server and then export to excel (xls or xlsx) the Image postion moves down or up.This creates a extra row in excel and causing a alignment issue.

Is there a way to lock the Image postion or is there any property to set at element level? Please advise

Thanks

Sreeram

P.S I couldn't share this jrxml, as this is strict policy posting code on forums. Sorry!!!!

[Aurora_Gaimon]

You cannot limit it from jasper report itself. When exporting report to different formats... you may get odd results. It could be a defect.

 

The only place you can control it a "bit" is from properties file.

 

Tips for Exporting to Excel | Jaspersoft Community 

 

Also, ensure you are using the right Jasper Studio developing tool according to JasperSoft server. But, it looks like a defect.

[Sreerambabu Palaniswamy]

Hi 

 

Thanks Aurora for the reply. 

 

I managed to solve the issue by placing the static text above and below the image, so the image wouldn't move. Also I removed Frame which was surrounding the image.

 

Thanks

 

Sreeram