How to install Jasper Reports on SugarCRM

[asimzaidi]

Hello guys

For the life of me, I couldn't figure out how to integrate jasper reports with my opensource sugarcrm. I have downloaded the jasper reports on my hard drive and I am using windows xp so I downloaded the zip version. However I need some guidence in regards of where to go from here.
Thank you in advance

[susiewilliams]

Hi there,

Did you follow the README instructions? They're posted on SugarForge with the rest of the project.

[sanjaykatiyar1]

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.BasicDataSourceFact ory</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

[asimzaidi]

When I try to go to
localhost:8080
it says page can not be displayed

Also I am using windows environment so would I still be using this
Now run the tomcat application server.
$cd catalina/bin
$./catalina.sh start
?

Thank you

[asimzaidi]

Dear Sunjay

You said
"Install the jre/jdk and set the JAVA_HOME invironment variable"

How do I set those?

Thanks

[asimzaidi]

Ok I found out how to set variables but now I have strange problem. When I go to http://localhost:8080 it asks for login information and when I enter my sugarmcrm admin login and password, it says invalid username or password.... I can log into my sugarcrm just fine..any idea why it is happening.
Thanks

[asimzaidi]

Ok figure it out.Thought I will share it with you guys. I initially entered my sugarcrm username and passwprd in server.xml and then once I realized I tried to change it but the changes wouldn't take effect. The reason was that I had to restart Tomcat ..So everytime you make changes to server.xml file you need to restart tomcat for the changes to take effect. Hope this will help some people.
Thanks

[asimzaidi]

you have to enter mysql root in server.xml

Thanks

[susiewilliams]

Thanks for posting the followups and your findings!

[Byapti]

[SIZE=7]Hi,
I think the JasperReports article on
http://aspalliance.com/1140_Creating..._JasperReports
may be helpful in this discussion.

This popular white paper is written by a software engineer from our organization Mindfire Solutions (http://www.mindfiresolutions.com).

I hope you find it useful!

Cheers,
Byapti[/SIZE]