The Joomla! Extensions Directory ™


Alter Reports Component

Editor's Note
  • This extension requires registration to download.
Complete full-featured tool for preview and download of SQL reports in your Joomla site.

AlterReports was designed as a native Joomla reporting extension which covers all needs and aspects of reports for your website. Using SQL queries with rich filters and conditional statements allows you to view and download reports of your database data in most convenient way.

Advanced customization settings allow to adjust visual presentation of your reports.

Access permissions help to control which reports and which report columns to display for certain usergroups, allow/disallow download formats etc.

Features:

- Viewing and downloading of reports in frontend and backend.
- Nested categories for reports.
- Frontend views of categories (list of categories), category (reports from category) and single report.
- Using different databases for loading reports data.
- Creating of reports by entering SQL query, editing of query with SQL profile and explain results, easy inserting of tags and database tables into query.
- Configurable filters for reports of few types (text field, text area, drop-down lists, checkboxes, radio inputs with either manually entered options or options loaded via SQL query), filter's values can be used in query as via tags.
- Conditional statements for query: certain parts of SQL can be executed only if filter's value was entered.
- Search in report and download selected rows only.
- Ordering of report by column.
- Report can be downloaded in configurable CSV, XLS, XLSX, HTML and XML formats.
- Rich customization of report views, HTML, XLS and XLSX formats (borders, colors, backgrounds etc., separate styles for headings, subheadings, data rows and footer row).
- Subheadings with ability to span above few heading columns.
- Footer row: each column can have custom footer value or auto-calculated values (minimum, maximum, average and sum). XLS reports can have footer values either pre-calculated or have formulas (built-in AVERAGE(), SUM(), MIN(), MAX() or you can use own formula with replaceable tags of column data rows coordinates).
- Each report column can have own style applied for report views, HTML, XLS and XLSX formats.
3-levels of style settings: global settings, individual report settings, column settings: you can easily change styles for all reports.
- Count of report views and downloads.
- Access levels for categories of reports, reports, available formats and columns.
- HTML and PHP pre-processors for columns values: you can wrap a value into HTML code or change it via PHP.

Report Extension

 

Images

 

2014-03-25
Reviews: 1
I purchased the extension for a client project and initially it met 90% of the customer reporting requirements.

I asked support initially for assistance on setup and they helped same day and resolved all issues.

I then asked for some features that were not available and they made changes and included these in a new build the next day.

The product now works exactly as I need and is so feature rich and intuitive that it will be well used going forward for client reporting.

Many thanks for the excellent extension and even better support and customer service.
2014-01-26
Reviews: 2
I am so impressed with this extension, which replaced our old SQL2EXCEL reports.

It works perfectly and its so easy to add new reports. Love the ability to run reports from the back-end as well as front end.

The developers have been professional and superbly quick to respond to any queries and deserve kudos for this.

No Joomla site with any reporting requirement should be without this.

Thanks guys and well done!

Cliff
2013-12-30
Reviews: 1
I have searched for a lightweight but super powerful reporting tool for Joomla for a longtime now and stumbled across this when purchasing another extension from Alterbrains. This would have to be the best reporting extension out there at the moment. Top that off with incredibly helpful and fast support these guys have got it all covered. I just wish i could have given more stars. The features and flexibility written into this extension are amazing. If you need a reporting tool this is a must have.
2013-05-10
Reviews: 10
Of all the extensions I've used over the years to display data from form submissions or anything else I wanted to present in a spreadsheet like format, this is the best by a long ways. Extremely flexible in presentation, layout and filtering of the data. So much control at any level, from the entire report down to just one column of information. The control of the presentation for both front end and backend has a great hierarchy that is easy to comprehend and implement. The support is at the very top of my list of developers, I can count on one hand the extension developers that are of this quality.

This is a bit embarrassing, but I didn't know there was a manual for the product until about my third inquiry into how to do something. And with this extremely robust extension I was still able to figure out almost everything I wanted to do without a manual. Now that I have a manual, I'm really going to have fun.

One last thing, the more you know about MySQL queries, the more you will be able to do with this program. You at least need to know how to make a simple SELECT, FROM, WHERE statement. If that doesn't mean anything to you, you will need to get a less robust extension for displaying your data.