The Joomla! Extensions Directory ™


Reportico ComponentModule

Reportico allows you to display database-driven tabular reports within your Joomla! web pages. Pass reportico a simple SQL statements ( or chains of SQL statements ) to generate report results. Reports can embedded in Joomla! articles or produced from links in articles or reports can be selected from a report suite menu which user can run. Design reports and report suites using the Joomla! administrator Reportico report designer.

Reportico allows you to control whether web pages present reports menus, access to report criteria entry or just the output of report. You can add your own report criteria to allow users to filter by date range, database driven lookups, checkboxes or radio buttons.

As well as web pages, Reportico can generate data in PDF and CVS formats.

Reportico supports groups, charts and complex custom expressions by including PHP code within report definitions.

Create a simple report with a single SQL statement and then get more complex with the addition of expressions, styling options and custom SQLs statements and custom PHP code which can manipulate and filter report data prior to report generation.

New in Reportico 4.0 :-
Bootstrap aware reports that complement your Bootstrap compatible Joomla! website template.
Ability to generate sortable, searchable results in dynamic grids.
Improved HTML charts including new Area Chart.
Ability to hide more of the Reportico criteria options to simplify the pages.

Report Extension

 

Images

 

2014-03-25
Reviews: 2
I setup additional tables using Crosstech's Content Builder CCK for a non-government organization, which needed a super easy way to track & update data and print out reports based on this data. Content Builder CCK did the trick for the web-based data management system, but then I really needed a PDF printout function for this management team. Most of these people are not very computer savvy, so simplicity was a foremost consideration. After doing some research on the Joomla! extensions directory I came across Reportico. I set it up first as the standalone product, but then installed the Joomla! component. These are essentially the same, only the Joomla! version allows you to access the Reportico tool through he tJoomla! component menu. Plus the Joomla! version has a sophisticated module. I didn't need the module, at least with this project. All I wanted (and prayed for) was a link so the users could simply click and print. What is so wonderful about this tool is once you have it setup, you can copy and modify the XML files and drop them into your project directory and presto, reports are instantaneously ready to be linked to a menu or button or whatever design you prefer. I had more than 50 reports to build because each report displayed slightly different data. The initial report took me about 3 hours to create (query, formatting, etc), so you can imagine my dismay over the idea of having to create 50 reports. Reportico cut that time down to ~5 minutes per report. All I had to is copy the original XML file, and then search and replace particular tables (could be fields or tables), and then create links for the front end users to simply click and print. The PDF reports are dynamic and execute perfectly every time. The management team I built this system for could not be more pleased with the ease and simplicity of this reporting system. I could not be more pleased with how much time I saved. Not to mention there is so much more you can do with this tool. I'm incorporating it for all my projects requiring reporting, especially for users who need a PDF printout (which is almost always the case). I give Reportico a 5-star!
2013-08-20
Reviews: 1
I downloaded the free non-joomla script for try-out and was fascinated how easy it was to generate any kind of reports or statistics from a given database connection. So I purchased for a little of 5$ the Reortico Joomla extension including the associated Joomla module. Installation was smooth as silk. With this extension I was able to embed statistics in table form and graphs of another third part Joomla directory extension, what I used as a base for a survey database and display it in a nice formatted way. You will need a bit time to find out all its possibilities and Peter, the developer, was giving such great support. Believe me after searching and trying so many different database report tools, I must admit it is the best available for Joomla.