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?
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.
Please, if my post was helpful and solved your issue remember to check them so this can help others with similar questions :)
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.
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.
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.