Skip to main content

Alter Reports

Alter Reports
Compatibility:

5.x maintained

4.x maintained

3.x not maintained

Type:
Commercial
License:
GNU GPL
Demo:
Extension Demo
JED:
Extension JED Page
See also:
Alter Surveys
Translations:
Extension Translations
Price:
$59.00

  Buy now

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.

  • View and download reports in both 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. Standard Joomla database drivers are supported including MSSQL via 'Microsoft SQL Server Driver for PHP'.
  • 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, PDF, HTML and XML formats. PDF documents can be customized via custom HTML templates.
  • 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, PDF, 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 with conditional elements in query (query can be different for user with different usergroups).
  • Ability to delete selected report rows in backend and frontend.
  • Ability to embed reports into articles via special {reportid=x} tag (Joomla content plugin is included).
  • Ability to group report rows by column.
  • Ability to email reports via special link (great feature to receive reports scheduled by a cronjob).
  • Import/Export of reports in XML - helps to transfer your reports between local and live servers.
  • Custom .ttf fonts support for HTML-based reports including PDF (fonts are embedded into .pdf documents).
  • Selection of PDF generation engine: either server-independent 'dompdf' or more powerful 'wkhtmltopdf' engine can be used. 'wkhtmltopdf' engine requires wkhtmltopdf library to be installed on your server.
  • Repeatable page header and footer for PDF.
  • to be continued... 

 

This extension uses PHPOffice/PhpSpreadsheet (MIT License).

This extension uses DOMPDF library (GNU Lesser General Public License v2.1).

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

  • Joomla 4.4 and higher.
  • PHP 8.1 and higher, Mbstring extension, MySQL >=5.7.
  • Bootstrap 5 frontend/backend template.
  • Enabled 'Editor - CodeMirror' Joomla plugin.
  • 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 5000. The reason is that there are too much settings in report edit page.
  • PHP settings max_exec_time and memory_limit should be also increased depending on downloaded report size and complexity, especially for generating of PDF or XLS downloads.
  • SQL knowledge for sure.
  • MSSQL reports require SQL Server 2008 or 2012 and PHP extension 'Microsoft SQL Server Driver for PHP' (https://www.php.net/manual/en/book.sqlsrv.php).
  • 'wkhtmltopdf' PDF engine requires wkhtmltopdf library installed on your server.