What is Reportico ?

Reportico is a comprehensive Open Source web reporting tool written purely in PHP. Reportico provides a web-based front end screen for designing and viewing reports stored in XML format. Reportico supports flexible criteria selection and reports may be presented in HTML, PDF, CSV, XML and JSON formats. Groups, graphs, expressions and drilldowns are also easily incorporated and reports may be embedded into existing web pages with a few lines of PHP.

Reportico Features

• Report output in HTML, PDF or CSV format
• Easy set up of report criteria entry screens. You may select from list boxes, check boxes, radio buttons all generated from the underlying database data.
• Configurable labelling and formatting of report data
• Reports can be executed directly from URL address bar or command line by passing through the desired report criteria, output and report name as parameters. By specifying XML, JSON output formats Reportico report suites can be turned into web APIs
• Configurable look and feel via Stylesheets and Templates
• Support for many databases through the ADODB connectivity class. Supported databases are MySQL, PostgreSQL, Oracle, Informix, SQLite 3 and Microsoft SQLServer
• Definition of group and associated headers and trailers
• Data brought back from the database can be manipulated prior to reporting via expression assignments using the the PHP language. This allows you to alter the formatting of data and perform arithmetic and string manipulation.
• Reports can be embedded within web pages with only a few lines of PHP
Ability to drill down between one report and another.
• For more complex reports, you may enter PHP code directly into the report front end that can pick up your report criteria and transform, summarise and generally manipulate your data before it is pulled out for final reporting. This lends itself to the production of report data that has been filtered or summarised. It also facilitates the ability to perform batch transactions, updates and deletes during report execution and the report output can be the success status of the operation.
• Ability to produce graphs from the reported data. Ability to plot bar, line and pie plots with configurable colours, fonts and sizes.
• Ability to include database images within the report output.
• Ability to run reports in safe or live mode that will prevent users being able to modify the report configurations.
• Ability to publish your report as a web service