Reportico is a flexible web reporting tool written in PHP that can report on
data from a variety of databases. A browser-driven front end allows the
creation, maintenance and execution of reports. Each report created
using the front end may be saved as an XML definition and saved reports can be organised together
to form a report suite accessible from a front end menu screen.
At the core of each report is an SQL query that generates the data for output, and this may be supplemented with a whole host of custom SQL statements and PHP code to allow complex manipulation of the data before and after it is fetched from the database. See below for a summary of the features of Reportico.
Reportico is designed to be used by developers of database
applications who wish to provide an easy to use and flexible web
reporting facility on top of their data.
Knowledge of SQL is a key requirement for development of reports
in Reportico. Also to tap into the more complex areas of the tool, knowledge of PHP is
a required skillset, since much of the manipulation of data prior to report output is
performed using PHP command calls.
Report output in HTML, PDF or CSV format
Configurable formatting of report output
data
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 look and feel via Stylesheets and
Templates
Support for many databases through PDO extensions and through the ADODB connectivity
class. Supported databases include MySQL,Oracle,Informix,SQLite,SQLServer,PostgresQL
and many others
Definition of groups and associated headers and
trailers
Individual data items 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.
For more complex reports, you may enter PHP code directly
into the report front end that can 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.
Embedding of reports
Ability to produce Graphs from the reported data. The style
and look of the Graphs are configurable with the 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 reports as an XML or JSON API
Filtering reports by web user id
Running multiple reports on a single page
