Changelog
v4.4.2
Released February 15th, 2024
Latest Version
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
Previous Versions
v4.4.1
Released July 17th, 2023
View/hide detailed changelog
- 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
v4.4.0
Released May 24th, 2023
View/hide detailed changelog
- 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
v4.3.1
Released January 26th, 2023
View/hide detailed changelog
- 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
v4.3.0
Released November 3rd, 2022
View/hide detailed changelog
- 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
v4.2.2
Released March 22nd, 2022
View/hide detailed changelog
- 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
v4.2.1
Released November 26th, 2021
View/hide detailed changelog
- 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
v4.2.0
Released August 4th, 2021
View/hide detailed changelog
- 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
v4.1.4
Released August 26th, 2020
View/hide detailed changelog
- 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
v4.1.3
Released June 17th, 2020
View/hide detailed changelog
- 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
v4.1.1
Released November 29th, 2019
View/hide detailed changelog
- 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
v4.1.0
Released September 4th, 2019
View/hide detailed changelog
*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
v4.0.1
Released August 7th, 2019
View/hide detailed changelog
- 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
v4.0.0
Released July 31st, 2019
View/hide detailed changelog
- 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
v3.1.3
Released April 16th, 2018
View/hide detailed changelog
- 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
v3.1.2
Released June 1st, 2017
View/hide detailed changelog
- 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
v3.1.1
Released March 10th, 2017
View/hide detailed changelog
- Bug Fix: Resolved problem of incorrect CSV reports' export caused by line breaks
- Bug Fix: Corrected file saving after custom report creation
v3.1.0
Released January 25th, 2017
View/hide detailed changelog
- 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
v3.0.0
Released September 14th, 2016
View/hide detailed changelog
- 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
Dean Wolf @dean7477
I have used multiple products from M.G. over the years. Solid products and highly helpful!
sameh soliman @sameh1823
i used report module to make the most important reports to help me with our staff, really it's great support and product updated.
Kyle Keehan @kyle1205
Great product. Solved all our data reporting needs. We recommend this product for anyone looking for comprehensive data study!
Vladimir Duka @vladimir1069
With these module you have no need to know SQL, because support drag&drop functions. Great module, I couldn't ask for more.
Cleverson Andrade @Cleverson
Hello, I have done several reports on the system and I can consider it great for my all of my decisions. I recommend!
Collin Biedenkapp @turbofandude
We bought this to get better insights on a per-product basis and it worked perfectly. Fantastic support as well, and we were pleasantly surprised by the thorough default options for reports.
Ali Davachi @valuereseller
Horrible company to work with. Stretched out support to prevent refunds and didn't show for multiple sessions. Lots of report writers out there that are better than this (EMS MySQL Manager)
Jason Bach @MosaicData
The Report Generator gives us much better insight into the numbers within WHMCS. It allows us to build very useful KPIs and other analytics that we can use to measure our financial performance as well as the efficiency of our staff and company overall. Highly recommended. Great Support.
Mr Roger @mrroger
great support. great product, very flexible able to create unlimited different reports with basically any information from whmcs