Tags

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.

• Fix: inherit all current GET variables for report URL in order to preserve filtering based on these variables.
• Fix: bloated columns. Please re-save a report with broken columns.

• Feature: column types. We started with two column types: "Common" and "Row Number". Common column provides current behavior. Row Number column displays row numbers, you can disable "Row Numbers" option, add "Row Number" column and apply custom position/style easily. More column types are coming...
• Feature: display global component setting value if a report setting is inherited.

Fix/change: column names can only contain numbers, a-z, A-Z letters and underscore. Once a report is edited and bad column names exist, they are auto-renamed to correct format. You need to update the column names in SELECT clause of SQL query to match the new correct names. Remember, you can use column Heading property for displayed column heading which can include any chars.

• Feature: new filter setting "PHP Processor" helps with custom filter modifications.
• Change: MSSQL driver removed, please use Microsoft SQL Server Driver for PHP.
• Feature: frontend reports category view can filter reports by tags.
• Change: frontend reports with un-authorized "view" and "view own" permissions are now displayed with special customizable layout ("you are not authorized to view this report" message by default).
• Feature: new "Date" column type with customizable display format.
• Feature: Joomla 4 compatibility.

• Change: row repeatable backgrounds moved to "Table Style".
• Feature: "Repeatable Backgrounds" for columns (we already had the same feature but for rows).
• Feature: new frontend/backend advanced settings "Preserve Pagination" and "Preserve Ordering" control the data stored in used session.
• Fix: MSSQL 2012 queries.
• Fix: search filter not applied for downloads.

• Feature: new column setting "Advanced > Heading HTML Template" helps to use HTML instead of plain text for report column headings.
• Feature: backend menu item types.
• Feature: multiple filters in backend reports view.
• Change: PHP 7.4 as min.
• Feature: repeatable page header and footer for PDF.

• Feature: new column setting "Heading PHP Processor" to execute PHP code and change the column heading.
• Feature: new Advanced report setting "Rows PHP Processor" to execute PHP after the report rows load.
• Feature: new "list-fancy-select" Dropdown filter select for Joomla4, see example in our demo report Continent filter.
• Feature: new "Task - Alter Reports" task plugin for Joomla 4 to schedule emails with reports.

• Fix: report edit issue with a site in subfolder.
• Fix: PDF "Grouped Row Page Break" setting not applied.
• Feature: new "Grouped Row Style" settings to apply custom styles for grouped rows.
• Feature: new PDF setting "Repeat Headings" allows to repeat table headings on each page (enabled by default).
• Feature: Grouping settings for XLS format.

• Change: Joomla 3 support dropped.
• Change: PHP 8.0 as min.
• Feature: new setting "XLS > Grouping > Empty Rows" helps to add empty rows before grouped row in XLS.

• Feature: new Language column type to display the Joomla content language information with title and flag, just like in native Joomla components.
• Feature: Joomla 5 compatibility.
• Change: Joomla 4.4 as min, PHP 8.1 as min.

• Fix: calendar filter "Select All" and "Clear All" links not displayed.
• Fix: saving changed report columns data.

• Feature: new option "Inherit from report" for database selection of filter values helps to use the same database for all filters.
• Fix: error after importing reports with configured database connections.

• Feature: new settings "Minimum Width" and "Maximum Width" for column styles.
• Fix: sqlsrv driver connection issue with self-signed SSL certificate.
• Feature: custom layouts for XLS(x) downloads.

• Feature: new Advanced report setting "Delete PHP Processor" for custom PHP code to delete rows.
• Fix: restored SQL color scheme for report SQL query editor.
• Feature: new advanced report setting "Preload Query" allows to execute a custom query before the main load query, e.g. to create a temporary table.
• Feature: new report settings "Frontend/Backend List > Advanced > Require Any Filter" helps to not load report rows until any filter has value.
• Feature: Joomla 6 support added.
• Change: Joomla 4 support dropped, Joomla 5.4 as min, PHP 8.3 as min.