Abiquo Reporting is an Abiquo plugin that offers integration with a Jaspersoft standalone reports server web service. Abiquo Reporting allows access to the reporting system from within the Abiquo user interface and authentication on the reports server with Abiquo user credentials. Abiquo Reporting includes a JasperReports Server repository with an Abiquo theme and a set of basic Abiquo reports that our customers can use as the basis for their own reports based on data from the Abiquo platform. Abiquo Reports, themes and the authentication module can be obtained from Abiquo Support directly.
JasperReports Server features:
See Install Abiquo Reports for full details of how to configure Reports.
After Abiquo Reporting is configured, you should be able to see the Reports icon on the Abiquo top icon bar.
If you cannot see the icon, check your configuration:
Use your Abiquo credentials to log in.
Click on reports and select a Report from the Reports list. Click Run or double click the report name. Follow the instructions on screen. Enter dates in the format yyyy-mm-dd.
Abiquo Reporting offers several different report categories:
The Abiquo Jaspersoft Integration includes the Abiquo Jasperspoft authentication plugin and the Jaspersoft Tomcat hosted application. Ideally, Jaspersoft should be run on its own dedicated server. The Jaspersoft plugin uses the Abiquo API for authentication and then reads the SQL database directly. The plugin allows the authentication of a Jaspersoft user and provides SQL row-level security for the execution of SQL statements. The integration has been tested with the open source version of Jaspersoft (jasperforge.org) and MySQL (MariaDB) and PostgreSQL. Jaspersoft has a small internal database for users and report metadata. It can be installed locally or on a database cluster. It works with both MySQL and PostgreSQL. iReport is a report design program for working with Jaspersoft reports on Windows and Macintosh. On Linux use Jasper Studio for Eclipse.