New Feature: WHMCS V8.8 and V8.9 support Improvement: Implemented language overrides support, enabling the utilization of customized translations Removed: Support for WHMCS V8.5 and previous Bug Fix: It is now possible to set an empty value for the  "=" and "!=" conditions - case #533 Bug Fix: Fixed "Integrity constraint violation: Column 'rule_id' cannot be null" error that could occur when personnel staff tried to open a section to which access was forbidden Bug Fix: Eliminated "DivisionByZeroError: Division by zero" error that could appear when the "PHP Code" preview contained division operations - case #535

• Bug Fix: Solved problem with deleting the ":daterangeValue" filter for expert widget - case #536
• Bug Fix: Fixed problem with "SMTP Error: Could not connect to SMTP host" when sending reports to emails if the mail server had incorrectly configured SSL certificates - case #537
• Bug Fix: Fixed issue where the scheduled task job for a report was not executed at the customized time of day - case #543
• Bug Fix: Resolved issue where adding columns to the widget could prevent their edition
• Bug Fix: Conditions with "0" values will now be properly displayed when trying to edit them
• Bug Fix: Editing the "IN" condition will no longer clear its "Type"
• Bug Fix: Fixed assorted problems with setting "0" values for most types of conditions
• Bug Fix: Eliminated "Type Errors" from the browser's console that occurred when trying to sort report columns
• Bug Fix: The "Last Day" option label will now be properly displayed on the "Tasks" list
• Bug Fix: Solved problem with the broken "Queue" search functionality in the module's "Dashboard" section
• Bug Fix: Resolved issues with "Unsupported operand types" errors that could occur when creating "Tasks" on a PHP 8.1 server
• Bug Fix: Eliminated "Argument #1 ($string) must be of type string" TypeError when running a cron job on PHP 8.1 server, due to creating a task from a report with empty actions for "Column Customization"
• Bug Fix: Fixed problem with generating CSV report if a client's name contained the "&" character - case #554
• Bug Fix: Other minor code corrections, language and UI adjustments

• Improvement: Added "Payment Method" column in the "Income Per Invoice" report - case #527
• Improvement: Improved access rules will now require fewer restrictions to grant someone permission to view the resource - case #512
• Improvement: If a syntax error occurs when trying to use the PHP code for advanced widgets, it will now display the line number that caused a problem - case #525
• Bug Fix: Corrected SQL query creation for the "IN" condition in the beginner mode - case #503
• Bug Fix: Fixed "syntax error, unexpected '&&' (T_BOOLEAN_AND)" that could occur when creating a custom report in the expert mode - case #504
• Bug Fix: Solved problem that might have prevented tables from being deleted in the beginner mode - case #505
• Bug Fix: Resolved issue that could have deleted the expression when trying to change its order using the arrow button - case #506
• Bug Fix: Corrected conflict error with the Domain Orders Extended For WHMCS module when executing its cron job - case #507
• Bug Fix: Fixed problem with displaying a complete condition text if it contained a dot in its query - case #511
• Bug Fix: Adjusted "Income Per Invoice" report which will now be based on transactions data - case #513
• Bug Fix: Solved problem where granting single rights to either create, edit or delete widgets could block the administrator from managing them - case #520
• Bug Fix: Editing the widget name and description will now properly work after that has been creation - case #521
• Bug Fix: Fixed problem where an extra column could be shown in the report widget if that was included in SQL but not in the specified PHP query - case #522
• Bug Fix: Other minor code corrections

• New Feature: "New Customers And Orders" - a new report displaying the total number of new customers next to new and completed orders within the selected time range
• New Feature: "Product Revenue Per Client" - a new report that provides a summary of service revenue per single or all products for each client - case #380
• New Feature: "Promo Codes Usage Statistics" - a new report that shows usage statistics for each promo code, indicating how often they were applied by clients - case #419
• New Feature: "Ticket Tags" - a new report offering an overview of existing tags assigned to new tickets within a specified date range - case #418
• New Feature: "Services Per Custom Field" - a new report displaying all services filtered by a custom field name and its value - case #328
• New Feature: "Client Per Custom Field" - a new report providing data on clients filtered by a custom field name and value - case #328
• New Feature: Possibility to edit the order of column positions in the beginner mode for custom report creation - case #425
• New Feature: "Custom" filter type for condition creation on the expert mode view which allows providing own SQL query for report filtering - case #494
• Improvement: Added dropdown menu with client name selection to filter the "Client Payment History" report - case #393
• Improvement: Added filtering option to exclude a country from the "Income per Invoice" report - case #393
• Improvement: Added "Company" and "Email" columns to the predefined "Orders Report" - case #486
• Improvement: When creating a condition of "Expression" type, the quotation marks will now be automatically added to the provided "Value" in the generated SQL query
• Improvement: Adjusted naming of the requested resources in the displayed access control logs
• Improvement: Updated Symfony vendor packages used by the module - case #485
• Bug Fix: Adjusted naming generation for CSV files - case #386
• Bug Fix: Corrected multiple data range filtering for reports - case #392
• Bug Fix: Customized columns will now be properly saved for exported and imported reports - case #426
• Bug Fix: Fixed problem with the edition of "Expression" conditions that could be wrongly saved as "Filter" type
• Bug Fix: Many other code corrections, language and UI improvements

• New Feature: WHMCS V8.7 support
• Removed: Support for WHMCS V8.3 and previous
• Removed: Support for PHP 7.3 version
• Bug Fix: Fixed SQL error for a custom report that might have occurred when using date-based filters - case #473
• Bug Fix: Corrected problem that might have interrupted the proper upgrade of the module to the latest version - case #475
• Bug Fix: Eliminated "TypeError" error that might have appeared after adding a relation to another table - case #476
• Bug Fix: Solved problem with the blank screen that could appear when creating a custom report after changing the "Type" selection to "Filter" - case #477
• Bug Fix: Other minor code corrections

• New Feature: WHMCS V8.5 and V8.6 support
• New Feature: Support for PHP 8.1 version
• New Feature: Access Control - define and create custom permissions that will restrict your personnel to selected resources and specified module actions
• New Feature: Choose from CSV/PDF/XML formats to export the bar/line/pie graphs and data table output for scheduled reports tasks
• Changed: Requires ionCube Loader V12 or later
• Removed: Support for WHMCS V8.2 and previous
• Removed: Support for PHP 7.2 version
• Removed: Obsolete PhantomJS library has been replaced with Headless Chrome/Chromium support - Note: See documentation for more information about required reconfiguration
• Bug Fix: Minor code corrections

• New Feature: WHMCS V8.4 support
• Removed: Support for WHMCS V8.0 and previous
• Bug Fix: Resolved problem with using numbers in the filter names that caused they did not work properly - case #368
• Bug Fix: Eliminated "Auto configuration field" error that might have appeared when trying to generate reports with graphs for certain server SSL setups - case #409
• Bug Fix: Fixed problem with creating relations using "packageid" when trying to join "tblhosting" and "tblproducts" tables in the beginner mode - case #421
• Bug Fix: Added many missing translation entries into the language file
• Bug Fix: Other minor code corrections and UI improvements

• New Feature: WHMCS V8.3 support
• Improvement: Slight changes in the way the module displays SQL results based on the PHP code - case #411
• Bug Fix: Sending reports through mail or FTP/SFTP will now also contain CSV and XML files instead of PDF only- case #412
• Bug Fix: Eliminated "Unable to find the wrapper "phar"" error that might have occurred when trying to proceed "install:phantomjs" command - case #414

• New Feature: WHMCS V8.2 support
• New Feature: "Client Account Statement" predefined report - case #347
• New Feature: "Client Credits" predefined report - case #347
• New Feature: "Sum Total Income Per Custom Field Value" predefined report - case #319
• New Feature: "Upcoming Expiration Services" predefined report - case #374
• New Feature: "Invoice Summary" predefined report - case #307
• New Feature: "Income Per Invoice" predefined report
• New Feature: Generate XML file type reports
• New Feature: Define custom time period for scheduled reports to generate them every or in specified months, days, days in the week, and time - case #341
• New Feature: Decide whether to send task report to email if the generated results do not contain any data - case #389
• New Feature: Use "Custom Table" to add SQL sub-queries into query filters - case #390
• New Feature: SQL queries can now be joined together using the "OR" operator instead of only the "AND" one - case #340
• New Feature: Customize column presentation to hide or replace its content via merge fields and use HTML code e.g. to display its data as URLs to clients' profiles, invoices, products, etc.
• Improvement: Generated PDF reports will now contain information about used filters - case #378
• Improvement: You can now add a single "space" character to the "PHP Code" field when using the expert mode to display SQL query results - case #352
• Improvement: Added "Next 7 Days" and "Next 30 Days" options to data selection for scheduled reports tasks - case #374
• Removed: Support for WHMCS V7.10 and previous
• Removed: Support for PHP 7.1 version
• Bug Fix: Fixed problems with creating scheduled task reports when using the Mozilla Firefox browser
• Bug Fix: Eliminated error that could occur when trying to load the "Client Payment History" report
• Bug Fix: Added assorted missing translations to the language file
• Bug Fix: Many other code corrections and improvements

• New Feature: WHMCS V8.0 and PHP 7.4 support
• Improvement: Added "Opened Date" and "Assigned To" columns for the "Tickets Responding Time" report - case #366
• Bug Fix: Fixed issue that might have stopped importing advanced reports created in Report Generator For WHMCS v3.x version after the module migration to v4.x - case #355

• New Feature: Ability to change the font type for generated reports in the module's "app/Config/settings.json" file - case #342
• Bug Fix: Fixed case, where cron was set to execute actions daily, but the email messages might have been sent every two days - case #332
• Bug Fix: Resolved issue that might have caused task emails not being sent to the chosen administrator - case #334
• Bug Fix: "Sales Summary Per Product" report will no longer display empty data if no product addons are created - case #335
• Bug Fix: Updated date range filter query that caused issues with picking tickets between specified dates - case #339
• Bug Fix: Added missing UTF-8 BOM character when adding the CSV file do ZIP archive - case #343

• New Feature: WHMCS V7.10 support
• Removed: Support for WHMCS V7.7 and previous

• New Feature: WHMCS V7.9 support
• Removed: Support for WHMCS V7.6 and previous
• Bug Fix: Fixed issue with encoding some characters e.g. Arabic ones that could have caused blank page problems - case #305
• Bug Fix: Corrected problem with the report migration that contained certain conditions such as "where ... and ...", "where ... or ..." - case #306

*New Feature: "Tickets Responding Time" report - view the time taken to respond to an open ticket and subsequent replies from a client - case #291 *New Feature: "Server Revenues" report - control servers' monthly maintenance costs, their services' revenues and balance - case #290 *Improvement: Added option to refer to table aliases from SQL queries when creating filters in "Expert" reports - case #292 *Improvement: New notification informing the administrator whether "exec" PHP function required for "PhantomJS" library is enabled in the server's PHP configuration *Bug Fix: Minor corrections to the selected built-in reports

• Improvement: Added option to hide the MetricsCube banner
• Improvement: Slight language adjustments
• Bug Fix: Resolved issue with checking permissions for PhantomjJS library
• Bug Fix: Solved case with database creation after module upgrade from the previous version

• Improvement: Completely rewritten code
• Improvement: Revamped reports creator tool
• Improvement: Rebuilt addon module user interface
• Improvement: Reports can now be sent to any email address instead of to selected staff members only
• Improvement: Reports can now be sent via email and uploaded to an FTP/SFTP server at the same time
• Improvement: Assorted language adjustments
• New Feature: WHMCS V7.8 and PHP 7.3 support
• New Feature: Reports comparison - view any report in a side-by-side view to compare results based on the selected filtering options
• New Feature: Generate tasks on demand - large reports with long preparation time can now be created and sent in the background from the report view using cron jobs
• Removed: Support for WHMCS V7.4 and previous
• Removed: "MRR & Churn Metrics" and "MRR & Churn Per Product" reports
• Changed: Reports creator tool now consists of two widgets: "Beginner" and "Expert" instead of three
• Bug Fix: Various corrections to predefined reports

• New Feature: WHMCS V7.5 support
• New Feature: PHP 7.1 and 7.2 support
• Bug Fix: Fixed problem with sending reports only to the first selected administrator instead of the entire group
• Bug Fix: Removed obsolete 'full_query' function to prevent the 'MRRChurnPerProductReport' problem
• Bug Fix: Resolved incorrect asset loading over HTTP instead of HTTPS
• Bug Fix: Fixed currency conversion for monthly sales reports

• New Feature: Admins list is now in alphabetical order and does not contain disabled accounts
• Bug Fix: Resolved problem with import of custom reports from 3.0 version
• Bug Fix: Corrected 'Affiliate ID' column in predefined 'Orders Report'
• Bug Fix: Data parsed using custom PHP code in 'Advanced Creator' are now saved properly
• Bug Fix: Solved issue with invalid custom filters operation in reports of advanced type

• Bug Fix: Resolved problem of incorrect CSV reports' export caused by line breaks
• Bug Fix: Corrected file saving after custom report creation

• New Feature: WHMCS V7 support
• New Feature: PHP 7 support
• New Feature: Generate reports in CSV format
• Improvement: Expanded range of time periods used upon scheduled report creation
• Improvement: Include filters in reports of PDF/CSV format and while viewing printable version
• Bug Fix: Minor tweaks

• Improvement: Fully rewritten and redesigned module
• Improvement: WYSIWYG creator has been replaced with drag & drop creators - Beginner, Intermediate and Advanced
• New Feature: Schedule reports to be sent via FTP/SFTP
• New Feature: Define type of filters - date range, time period, dropdown, numeric range and text
• New Feature: Search through available tables and fields
• New Feature: Beginner and Intermediate creators - automatically join tables with common relation
• New Feature: Beginner and Intermediate creators - define static conditions
• New Feature: Beginner and Intermediate creators - define conditions between two columns
• New Feature: Beginner and Intermediate creators - use SQL functions easily by choosing desired ones from the list
• New Feature: Beginner and Intermediate creators - skip specified number of first records
• New Report: Unpaid Invoices
• New Report: Client Payment History
• New Report: Sales Summary Per Product
• New Report: Comments On Course Of Ticket Solving
• New Report: Ratings Of Ticket Solving Course
• New Report: Ticket Response Rating
• New Report: Flexible Transactions Report
• Changed: Restrict ability to modify output with PHP language to Intermediate and Advanced creators - previously always available
• Changed: Remove settings to store unfinished section progress in creator – settings are stored by default and can be reset
• Changed: Remove settings to generate reports via Cron Job - optimization issues allowing to generate it via browser have been resolved
• Changed: Remove settings to generate reports using UTF-8 encoding - use it by default
• Changed: Remove definitions settings - store definitions in multi-language files
• Changed: Divide predefined reports into categories
• Removed: Migration from previous version of Report Generator For WHMCS - for the duration of BETA
• Removed: Export reports to CSV or XML - for the duration of BETA
• Removed: Clone report section - for the duration of BETA
• Removed: Support for WHMCS V5

• Bug Fix: Generate PDF reports by cron job