Q & A: Why does the report image show on local Excel but not on Server Excel

Question: 

What differences are there between running Excel on the local workstation using Jaspersoft Studio and running it on JasperReport Server?

I need to know so that when the local workstation report development is solid and tested on Excel rendering, it should smoothly work on the JasperReports Server.

Answer

The XLS output is data centric meant for spreadsheet analysis purposes therefore any image in a spreadsheet is meaningless as far as the accounting is concerned. Therefore JasperReports Server (JRS) by default will not display images in the spreadsheet outputs (ignoring formatting and graphics to preserve pure data cells).

To meet non-data analyzing requirements with spreadsheet output, users will need to override the configuration setting to allow graphic elements along with the text elements to be exported. Please refer to this JasperReports (JRL) Configuration Reference material for the report property information:

http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.ignore.graphics

User can inject the properties into report template JRXML file to have the graphics appear in this report only:

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

Users can also change this default behavior globally affecting all report exports in JRS. Users need to edit <js-install>WEB-INFapplicationContext.xml file and set the ignoreGraphics property of the xlsExportParameters bean to "false".

<bean id="xlsExportParameters" class="com.jaspersoft.jasperserver.api.engine.jasperreports.common.XlsExportParametersBean"> 
        ......
        <property name="ignoreGraphics" value="false"/> 
        ......
</bean>  

====================================

TTC-20220426-2100271-2102444