Monday, 16 July 2012

JasperReport Server Customization - Export JaspReport in Excel Format





JasperReport server provide the facility to export reports in various format like PDF, Excel, CSV and Flash and many more but by default excel export option is disabled in JasperReport server, so if you want to enable excel export option 

Go to this location

<js-install-directory> \apache-tomcat\webapps\jasperserver\WEB-INF\ Applicationcontext.xml

and open Applicationcontext.xml file with notepad and search for the "ignoreGraphics" property


<bean id="xlsExportParameters" class="com.jaspersoft.jasperserver.api.engine.jasperreports.common.XlsExportParametersBean">
        <property name="detectCellType" value="true"/>
        <property name="onePagePerSheet" value="false"/>
        <property name="removeEmptySpaceBetweenRows" value="true"/>
        <property name="removeEmptySpaceBetweenColumns" value="true"/>
        <property name="whitePageBackground" value="false"/>
        <property name="ignoreGraphics" value="false"/>
        <property name="collapseRowSpan" value="true"/>
        <property name="ignoreCellBorder" value="true"/>
        <property name="fontSizeFixEnabled" value="true"/>
        <property name="maximumRowsPerSheet" value="0"/>
        <property name="xlsFormatPatternsMap" ref="formatPatternsMap"/>
    </bean>


Change ignoreGraphic property false to true to export charts in excel format

   <property name="ignoreGraphics" value="true"/>


JR Server Customization - Change "Jaspersoft: Login" page name to our "Organization: Login"



JasperReport Server is an open source-reporting tool so sometimes you may need to rebrand and customize according to the customer requirements. Therefore, I am going to tell you how to rebrand and customise JR Server.
In order to change "Jaspersoft: Login" page name to customer "Organization: Login" page.
 (When we login on JasperReport Server default page name is Jaspersoft: Login)
You can see in browser after login.

Go to   this directory

                              \jasperreports-server-cp-4.5.0\apache-tomcat\webapps\jasperserver\WEB-INF\decorator\ directory

 And edit the decorator.jsp file and change

Jaspersoft to "Organization_name

<!--default>
<title>Jaspersoft: <decorator:title /></title>
<!--customized message where we edited pro_nav_messages.properties with NAV_020_FULL_TITLE code >
<title><spring:message code='NAV_020_FULL_TITLE'/></title>