Interactive report capability for JasperSoft Server Community Edition

[pduvvuri]

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?

[djohnson53]

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

[pduvvuri]

I need some information regarding Jaspersoft Community and Commercial Editions (https://www.jaspersoft.com/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.

 

[marianol]

 

pduvvuri,

 

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 Jaspersoft.com 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

 

Best.. 
Please, if my post was helpful and solved your issue remember to check them so this can help others with similar questions :)

[patricia.eilers]

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.

[marianol]

Hi Patricia...

 

I see, looks like they changed.. The new training page is now https://www.jaspersoft.com/bi-training-center

The Studio Training is in https://www.jaspersoft.com/olp/developing-reports-jaspersoft-studio

 

But I do not see the "Building interactive reports in Jaspersoft Studio" there :( but There are really good tutorials in this page: http://community.jaspersoft.com/project/jaspersoft-studio/resources and here you have the one regarding the Table Component: http://community.jaspersoft.com/wiki/tables-and-crosstabs-jaspersoft-studio

 

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

 

 

[jasperServerUser]

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.