Ramp Up #9: Business Intelligence with Jasper
 |
 |
Jasper Server when used in conjunction with Jasper iReport allows you to extract valuable insights from the systems you use to run your business. In this brief tutorial we’ll examine how to create a simple report using iReport. This exercise presumes that you’ve already completed this prior tutorial on how to expose the MySQL database of a SugarCRM JumpBox. Once you’ve created a report with the client-side tool (iReport) you load the JRXML file generated by iReport into the Repository on the JumpBox for Jasper Server in order to serve it to users. If you have any questions about the video leave a comment below.
*Make sure the 
button is on and click the 
button to expand the video to full-screen and watch the screencast in hi-def.
Well done on the ramp videos, just what I needed to get started. Redmine and Nagios are working for me with Redmine Jumpbox being used extensively in our R&D department for while now. Playing with a couple of others, thanks!
I noticed on the report that there were two sections for California. Why?
@James- I noticed that as well. It grouped two contacts properly under California but had another grouping with one contact labeled California. I don’t have the db up in front of me but my suspicion is that there was a trailing space in “California ” on the first so it appeared as two separate entries. Good catch.
sean
I’m having a hard time wrapping my head around why one needs the JasperServer and the iReport. I’m trying them both and they seem to work independently. There is no setting in iReport to be looking for or at the JasperServer on another machine. Maybe I need to get a little deeper, but I’m not seeing the connection so far.
Thanks for the videos though!
All:
I followed the video very closely and was able to sucessfully create a database connection to my instance of the Sugarcrm5 jumpbox. When I get to the query builder I can see all the table names from the mySql DB. However, when I go to add them to the space the names of the fields appear as boxes – not text. I am using Jasper 3.5.1 for Windows. What am I doing wrong?
Jayme
Chris,
iReport is used to create the report definition and JasperServer executes and delivers the reports to users over the web. In a single user scenario JasperServer doesn’t really have much value, it’s when you look at the scenario where there are users who just want to view (rather than develop) reports that it makes sense.
Kimbro
How does one connect to a MS SQL Server Database. I can not seem to figure out how to load the MS SQL Server JDBC to a jump box?