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
P.S I couldn't share this jrxml, as this is strict policy posting code on forums. Sorry!!!!
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.
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.