What is Reportico?

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.

Who Should Use 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.

Key Requirements

Reportico requires :-

  • A web server such as Apache 1.3 or Apache 2 or IIS
  • PHP5 with PDO support

For further details see the Reportico Installation section.

Key Features

Reportico provides the following features:-

  • 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
  • reporticointro.txt
  • Last modified: 2018/05/04 21:40
  • (external edit)