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?
2 Answers:
Posted on November 1, 2013 at 12:22pm
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.
Posted on December 10, 2013 at 5:25am
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 :)
Please, if my post was helpful and solved your issue remember to check them so this can help others with similar questions :)
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.
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.