Interactive report capability for JasperSoft Server Community Edition

I notice in the JasperSoft Server Community Edition, there is a sample SugarCRM report that I can interact with (filter on, etc.).  Since this functionality is available in this Community Edition, can someone please provide guidance on how I would connect our SugarCRM data to produce an interactive report on the Community Edition of JasperSoft Server?

pduvvuri's picture
Joined: Oct 24 2013 - 10:19am
Last seen: 9 years 3 months ago

2 Answers:

SugarCRM uses a MySQL DB. So you need to set up a JDBC (or JNDI) Data Source to it. Then its just like any other SQL DB.

Once you've done that, then you use either Jaspersoft Studio to create the actual report.  I would look at our Wiki's Getting Started sections for tutorials on all this.

Maybe: Getting Started with Jaspersoft Studio

djohnson53's picture
Joined: May 25 2012 - 11:10am
Last seen: 1 year 1 month ago

I need some information regarding Jaspersoft Community and Commercial Editions ( It is mentioned on the website that for the Community Edition, Interactive Report Viewing and OLAP Server features are available which do interactive reporting. I have downloaded, installed and made some static reports with the Community Edition. I am wondering how to create interactive reports using Community Edition of Jaspersoft Studio. There are some sample reports of SugarCRM where are interactive on JasperSoft Server. Is it possible to make such highly interactive reports using Community Edition or are they limited to the Commercial Edition. Can you also re-direct me to any videos which guide me how to make interactive reports using Studio and that can be published to the Server and the end-user should be able to select the fields or the criteria using filters and then, it should dynamically pull the data as per the criteria given by the user? If you can advise me with this, our team would have a better idea about the solutions offered by Jaspersoft.

pduvvuri - 9 years 3 months ago

Hi pduvvuri,
Did you find the solution for your problem? I am facing the same issue of creating interactive reports using the community edition of jaspersoft. Please help.

jasperServerUser - 7 years 6 months ago
To build interactive reports you need to use the Table component in Jaspersoft Studio. There is a great tutorial in the Online Training Section of on Building interactive reports in Jaspersoft 
The main difference you will find with the comercial version in regards to interactive reports made in JSS is that in the commercial version the end user can save the changes they have made (sorting, formatting, filtering, column selection, etc.) in the interactive reports back to the JasperServer repository. The other feature you get with the commercial version is the capability to let the en user create reports using the web UI via JasperServer Adhoc Views (follow the link to see a demo). If you want to evaluate, you can get a 30 day trial of the commercial edition of Jaspersoft here.
You can get more help in working with Jaspersoft Studio to develop reports and drill downs in our Developing Reports with Jaspersoft Studio training class (free) and also on the Jaspersoft Studio Tutorials Wiki and of curse the documentation Jaspersoft Studio User Guide
Please, if my post was helpful and solved your issue remember to check them so this can help others with similar questions :)
marianol's picture
Joined: Sep 13 2011 - 8:04am
Last seen: 4 years 5 months ago

I would like to do the same--create interactive reports using the CE of Studio but the links to "Building interactive reports in Jaspersoft" and "Developing Reports with Jaspersoft Studio" are broken.

patricia.eilers - 8 years 8 months ago

Hi Patricia...

I see, looks like they changed.. The new training page is now
The Studio Training is in

But I do not see the "Building interactive reports in Jaspersoft Studio" there :( but There are really good tutorials in this page: and here you have the one regarding the Table Component:

When you use the Table or Crosstab component in Studio and deploy those reports to Jasper Server those component become interactive.

marianol - 8 years 8 months ago