Skip to main content

Alter Reports 3.0.0

Written on .

Warning: this is a major release with changes in SQL query conditional statements and custom layouts. It's better to test the new release on dev environment first.

  • Feature: ability to use {filter.label} placeholder for currently selected option label of dropdowns, checkboxes and radio filter.
  • Fix: inner tabs and headings aligned nicely.
  • Feature: new report PDF setting 'Grouped Row Page Break' to add a page break before grouped row.
  • Feature: new report settings 'Grouped Row Template' and 'Grouped Row PHP Processor' allow to control grouped table row output.
  • Fix: columns ordering in frontend.
  • Feature: {where} tag for main SQL query which is auto-replaced with auto-generated search conditions. Helps if you have sub-queries with WHERE clause.
  • Feature: new setting 'Grouped Row Headings' to display column headings before or after grouped row.
  • Fix: issue with deleting reports/databases since Joomla 3.9.1
  • Feature: new setting 'Show Subheadings' helps to control visibility and position of subheadings row (above or below main headings).
  • Change: PHP 7.x as min.
  • Fix: pagination error with embedded reports.
  • Change: all filter tags inside SQL query conditional statements should be wrapped in {}: /* IF {filterTag} */ but not /* IF filterTag */.
  • Feature: SQL query can include PHP code via <?php ... ?> tags.
  • Feature: SQL query can include PHP code and complex logic, i.e. /* IF (strpos({filterTag}, 'test') === 0 && !empty({filterTag2})) */.
  • Feature: report settings for unused download formats can be globally disabled.
  • Feature: faster and cleaner UI for report edit.
  • Change: new report layouts, please compare with your existing custom layouts with the new layouts.
  • Feature: ability to create and delete report columns manually.
  • Feature: new backend filters layout "joomla" to match the Joomla table filters style.
Terms used:

PHP, Template, Joomla