Alter Reports

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 helps to control which reports and which report columns to display for certain usergroups, allow/disallow download formats.

Extension information

Compatibility:

full

Type:
Commercial
License:
GNU GPL
Demo:
click here
JED page:
click here
See also:
Alter Surveys
Price:
$49.00

  Buy now

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.
  • Current Joomla user-related and GET variables tags in query.
  • Ability to delete selected report rows in backend and frontend.
  • Ability to embed reports into articles via special {reportid=x} tag.
  • Ability to group report rows by column.
  • to be continued... 

 

This extension uses PHPExcel library, GNU Library General Public License (LGPL), version 2.1

Want a new feature? Why not? Please Contact Us!

Requirements

  • PHP 5.3+ & MySQL 5.0.4+
  • Joomla 3.0.2+ installed and running correctly.
  • Bootstrap-based frontend and backend Joomla templates.
  • Depending on your server settings and report properties you may be forced to increase the limit of PHP settings max_input_vars, suhosin.post.max_vars and suhosin.request.max_vars (if Suhosin is installed). The average value for these settings should be about 2000. The reason is that there are too much settings in report edit page.
  • SQL knowledge for sure.

Screenshots

Changelog

Current version:

  • Feature: 'Vertical' report layout - allows to display headings and report data vertically.
  • Fix: once checked checkbox filter always has last option checked.

17 June 2014 - ver. 1.1.8:

  • Feature: calculate footer formulas using initial data unaffected by PHP processors.
  • Feature: new column setting 'Footer PHP Processor' to parse footer value before output.
  • Feature: filter tags and conditional elements in options SQL query for drop-down filter.
  • Feature: GET variables tags like {get->user_id}.
  • Feature: PHPExcel library updated to 1.8.0.

28 April 2014 - ver. 1.1.7:

  • Fix: download of XLS and XML

14 April 2014 - ver. 1.1.6:

  • Feature: {user->levels} user-related query tag with comma-separated user authorized levels.
  • Fix: disappearing titles with tooltips in frontend
  • Fix: table ordering in frontend.
  • Feature: new settings 'Show Limit Box', 'Show Ordering Options' and 'Print Layout'  for Backend View in component settings and report settings.
  • Feature: {VALUE} tag for 'Footer Label' field (ex 'Footer Custom Value').  It allows to display a text with calculations like 'Total: 20' by using label text 'Total: {VALUE}'.
  • Feature: 'Default Value SQL' setting for Calendar filters - now you can load default value from database.
  • Feature: ability to group report rows by column.

03 February 2014 - ver. 1.1.5:

  • Feature: Allowed ordering by multiple fields.
  • Feature: Allowed tags in HTML processing of column value.
  • Feature: /* IF NOT tag */ conditional element.
  • Feature: /* IF tag = ’test value’ */ and /* IF tag != ’test value’ */ conditional elements.
  • Feature: Show 'No Reports' Message setting for category layout.

22 Oct 2013 - ver 1.1.4:

  • Feature: ability to browse and insert table columns into query.
  • Feature: ability to browse and insert user tags into query.
  • Feature: drag-and-drop columns ordering.
  • Change: user tags should be escaped in the query.

10 Oct 2013 - ver. 1.1.3:

  • Added auto-escaping and auto-quoting of user-related tags.
  • Removed IeCursorFix.
  • Added content plugin and ability to embed reports into articles.

27 Sep 2013 - ver. 1.1.2:

  • Fix: issue with multiple drop-down filters loading same options
  • Fix: issue with escaping textual primary keys

18 Sep 2013 - ver. 1.1.1:

  • Added current Joomla user-related tags: {user->id}, {user->name}, {user->username}, {user->email}, {user->registerDate}, {user->lastvisitDate}.
  • Added ability to delete selected report rows in backend and frontend using Primary Key and Primary Table settings.
  • Improved filter name entered by user.
  • Fixed issue with loading data from 3rd-party database.

01 May 2013 - ver. 1.1.0:

  • New Subheadings row 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).

01 Feb 2013 - ver. 1.0.0

Need Help?

If you are in need of help or have any questions regarding our products you may use one of the links below:

Our Newsletter

Get the latest news, product updates and special offers!