How to install jasper reports for sugarcrm

Download Jasper reports from here:
http://www.sugarforge.org/frs/?group_id=193

JasperReports for SugarCRM is a Java web application, so it requires a
Java run time and an application server.  The Tomcat application server
is included, so the only prerequisites is a Java Virtual Machine, version
1.3 or later.
Install the jre/jdk and set the JAVA_HOME invironment variable.

Unzip the downloaded zip file, it will create one dir catalina.

Change in the catalina/conf/server.xml file
(Text in bold need to be change according to your sugarcrm)
********************************
<GlobalNamingResources>
        <!– SugarCRM database registered with JNDI.  This needs to be –>
        <!– a global resource so we can use it to authenticate        –>
        <Resource name=”jdbc/jasperreports-sugarcrm” auth=”Container”
                  type=”javax.sql.DataSource”/>
        <ResourceParams name=”jdbc/jasperreports-sugarcrm”>
            <parameter>
                <name>factory</name>
                <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
            </parameter>
            <parameter>
                <name>username</name>
                <value>Sugar_database_user_name</value>
            </parameter>
            <parameter>
                <name>password</name>
                <value>Sugar_database_password</value>
            </parameter>
            <parameter>
                <name>driverClassName</name>
                <value>com.mysql.jdbc.Driver</value>
            </parameter>
            <parameter>
                <name>url</name>
                <value>jdbc:mysql://localhost/Sugar_database_name</value>
            </parameter>
        </ResourceParams>
</GlobalNamingResources>
***************************

Now run the tomcat application server.
$cd catalina/bin
$./catalina.sh start

And point your browser at:
http://localhost:8080/jasperreports-sugarcrm/login.jsp

Login as sugar user/password

Leave a Reply


OpenApp Media Network OpenApp Media Network

Various trademarks held by their respective owners.

Privacy Statement | Terms Of Service