Clarity

Expand all | Collapse all

Jaspersoft 5.6.1 server Image - Lock position in Excel export

Jump to Best Answer
  • 1.  Jaspersoft 5.6.1 server Image - Lock position in Excel export

    Posted 12-08-2016 09:34 AM

    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!!!!



  • 2.  Re: Jaspersoft 5.6.1 server Image - Lock position in Excel export

    Posted 12-09-2016 03:57 PM

    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.



  • 3.  Re: Jaspersoft 5.6.1 server Image - Lock position in Excel export
    Best Answer

    Posted 12-15-2016 01:45 AM

    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