Jet Reports - Release Notes 2024
Jet Reports (including the Jet Excel add-in and Jet Hub) receives updates on a regular basis. The following topic covers the release notes for all Jet Reports releases that were released in the year 2024.
To download the PDF for the new features for Jet Reports 24.4, click What's New in Jet Reports.
See below for the changes that have been made for each chronological release.
Release Notes
Jet Reports 24.4.1 Build #24.4.1.0213
Release Date: January 28, 2025
Resolved Issues
Corrected an issue where the AI Assistant was visible for accounts that did not have AI capabilities enabled. (9727)
Corrected an issue where the Dynamics 365 Authentication Tenant field was displayed for non-BC Cloud data sources. (9691)
Corrected an issue where loading ENUM would fail due to an OutOfMemoryException while using the JFX function. (9308)
Corrected an issue where the System.InvalidCastException error occurred when using NAV web service connections. (9089)
Corrected an issue where the DateTime filtering failed to convert to the local time zone in the Direct SQL data sources. (8958)
Features
- Introduced an information icon in Jet Reports under Settings > App Settings > General tab for Simulation mode and Settings > App Settings > Settings Location for Reports Center. This icon provides access to the required documentation. (9597)
Included a license validation process for the Reports Center. If you do not have a license, you cannot select the Reports Center icon available under Settings > App Settings > Settings Location in the Jet Excel add-in.(9582)
Added the Access Reports Center and Upload to Reports Center buttons to the Jet Excel add-in. (9577), (9109), and (7877).
Added tooltips for the Reports Center buttons in the Jet Excel add-in. (9510)
Added the ability to use data sources from Reports Center. This can be achieved by selecting the Reports Center icon available under Settings > App Settings > Settings Location in the Jet Excel add-in. (9475)
Added the Success screen that appears when uploading a report to Reports Center is successful. (9110)
Added the Test Connection button to the Jet Excel add-in for easier connection verifications. (9108)
Updated the timeout error message that occurred while using Business Central Cloud connections. (9080)
Jet Reports 24.4 Build #24.4.0.3233
Release Date: December 10, 2024
Resolved Issues
Corrected an issue where an invalid cast exception error occurs when running reports using Dynamics 365 Business Central (SQL Server) on-premises or Dynamics NAV 2013-2018 (SQL server) data sources. (8676)
Corrected an issue where an invalid filter error occurs when filtering the SUM function against the Enum extension. (8784)
Corrected an issue in the Jet Excel add-in where filtering by the option value did not return results during replication. (8939)
Features
Added the platform command line option for installing the Jet Excel add-in against a Platform account with the MSI installer. (8488)
In the Jet Services installer, removed the option to install Jet Reports in trial mode as it is no longer applicable. (8490)
Added service-to-service authentication for Business Central Cloud in Jet Reports Excel Add-In. (8616)
Added service-to-service authentication for Business Central Cloud in Jet Admin Console. (8617)
Added service-to-service authentication for Business Central Cloud in Jet Hub. (8618)
Added report assistant capabilities to the AI Assistant feature. (8637)
The AI Task pane will now close when the last workbook is closed, leaving no workbooks open. (8638)
The AI Report Assist tab is disabled when it is not configured in the data source. (8893)
Jet Reports 24.3.2 Build #24.3.2.2811
Release Date: October 15, 2024
Resolved Issues
Jet Reports is now compatible with Business Central version 25. (6890)
Corrected the formatting issue in emails received from M365. (7051)
Corrected an issue in the Jet Excel Scheduler that prevented the removal of hidden rows, columns, and sheets in pivot tables. (7503)
Resolved performance degradation issue in Business Central SQL connections. (8104)
Corrected an issue with Cache Tables where option captions were not being returned in certain cases when enabled. (8565)
Corrected an issue where Jet Hub Scheduler emails using M365 authentication were showing HTML characters in the body. (8609)
Corrected an issue where the cell format was being changed from Accounting to Custom when using the Run in Background feature. (8624)
Updated the Business Central Extension by eliminating the user metadata table, as it was deprecated in Business Central 25 by Microsoft. (8662)
Jet Reports 24.3.1 Build #24.3.1.2421
Release Date: September 12, 2024
Jet Reports
Resolved Issues 24.3.1
Corrected Czech translations in Jet Hub. (7441)
Developed a method to enable connections for clients using NAV User Password on BC 24+. (7456)
Corrected an issue where NP(Codeunit) functions were failing when run in the Jet Hub. (8010)
Resolved an issue in Jet Hub where Jet data warehouse and Dynamics GP data sources were not showing authentication settings. (8057)
Corrected an issue where date table was returning datetime values instead of date values. (8065)
Corrected an error in the network connection for Jet Hub Scheduler. (8095)
Corrected an error on BC SQL connections when retrieving extension fields. (8255)
Jet Reports and Jet Hub 24.3 Build #24.3.0.2341
Release Date: August 27, 2024
Jet Reports 24.3
Features 24.3
Updated a hyperlink on the About screen of the Jet Reports Excel Add-In. (7649)
Published BC Extensions under insightsoftware company. (7874)
-
The Jet BC extensions are now linked to the ISW partner account on Microsoft AppSource, allowing Jet extension users to access the latest features and easily identify the extension as part of Insight Software’s offerings. (7874)
Updated the Jet Excel Add-In installer to include a Platform sign-in option during installation, eliminating the need for an activation token for insightsoftware platform accounts. (7786)
Updated the insightsoftware logo in the Jet installers. (7895)
-
Updated AI Doc Assistant to AI Assistant. The AI Assistant has been updated to include an Analysis pane, enhancing its data analysis capabilities. (7755, 7951)
- Added the capability to activate licenses through the insightsoftware platform within the Jet Reports Excel Add-In’s ‘Activate License’ menu. (7967)
Updated the Jet Ribbon for platform users by relocating the login and logout options from the far left to the far right of the ribbon. (7977)
Updated the Jet Icon in the BC Extension. (8339)
Resolved Issues 24.3
Corrected an issue where Batch Function Execution would fail under specific conditions when Cache Tables hint was enabled. (6078)
Corrected an issue where emails were not being sent when scheduling a batched report with recipients selected using named ranges in the Excel Add-In. (7637)
Corrected an issue where a formula with nested NF function returned incorrect results when using non-US regional format. (7711)
Corrected an issue where running pre-cache joins for BC Web Services against a Table function with built-in links caused an error. (7974)
Jet Hub 24.3
Features 24.3
Updated the Jet Services Installer to include a Platform sign-in option during installation, eliminating the need for an activation token for insightsoftware platform accounts. (7786)
Resolved Issues 24.3
Corrected an issue where Jet Hub Scheduler did not recognize AD and O365 users as the same user when modifying their tasks. (7248)
- Resolved an authentication issue that occurred when running Jet Service Tier on a virtual machine (VM) and connecting to it from another machine using the Excel Add-In. (7960)
Jet Reports 24.2.1 Build #24.2.1.1922
Release Date: July 23, 2024
Jet Reports 24.2.1
Resolved Issues 24.2.1
Corrected an issue where the cell format was incorrectly changing from Accounting to Custom. (5068)
Corrected an issue where BC group permissions were not being applied when SQL data sources. (5879)
Corrected an issue where the BC username was returned in lowercase instead of uppercase, as stored in BC. (7577)
Corrected an issue in the Jet Admin Console where Active Directory (AD) Groups were causing existing Jet Administrators to lose their privileges. (7686)
Corrected an issue where NF Functions would not accept integers unless they were wrapped in quotes. (7834)
Corrected an issue where while using NL rows with array functions resulted in an Invalid Table '@@'. error. (7851)
Jet Hub 24.2.1
Resolved Issues 24.2.1
Corrected an issue in Jet Hub where running reports resulted in the Jet.Shared.ReportFatalErrorException error. (7653)
Removed an element in Jet Hub that indicated if scheduled tasks were created but not yet updated from the old scheduler. (7703)
Corrected an issue in Jet Hub where users could not select a report by clicking an image in the status and enabled columns. (7715)
Corrected an issue in Jet Hub Scheduler where the pending changes window did not prompt when users clicked on the new task button. (7718)
Corrected an issue in Jet Hub where sharing reports using Active Directory (AD) Groups was not functioning correctly. (7805)
Corrected an issue where signing into Jet Hub using Microsoft 365 login was resulting in the object reference error. (7797)
Corrected an issue in Jet Hub where the Jet Service Tier would crash when a legacy scheduled monthly task was updated in the new scheduler. (7855)
Jet Reports 24.2 Build #24.2.0.1522
Release Date: June 4, 2024
Jet Reports 24.2
Features 24.2
Jet Reports is now compatible with Business Central version 24. (6736)
The single installer is split into two installers, one installer specifically for Excel Add-In and one installer for Jet Hub, Jet Service Tier, and Jet Admin Console. (6264)
Added the Auto-Fill feature for Report Options Lookup value text fields. (7246)
Added an error message when Platform secret is invalid or expired. (7681)
Updated the release folder structure to make it easier to find essential files. (7739)
Resolved Issues 24.2
Corrected an issue where the MSALCache token for the service database was writing to the incorrect account. (6654)
Corrected an issue with BC data sources using MFA where authentication token was resetting authentication status when trying to upload to the Jet Hub from the Excel add-in. (7001)
Corrected an issue in BC SaaS where Drilldown returns errors against Sales Line and Purchase Line tables. (7032)
Corrected an issue where NL()"filter" functions were returning no results because empty filter error with cache tables enabled. (7129)
Updated error message for GL function when running against data sources that do not support it. (7189)
Corrected an issue that occurred while using CacheTables and sorting included special characters. (7309)
Corrected an issue in BC23+ where Flowfields of Calc type "Exists" don't work when based on another extension field. (7413)
Jet Hub 24.2
Features 24.2
The single installer is split into two installers, one installer specifically for Excel Add-In and one installer for Jet Hub, Jet Service Tier, and Jet Admin Console. (6264)
Removed Beta Tag from the new Jet Hub Scheduler feature and hid the legacy scheduler. (7216)
Added an error message when Platform secret is invalid or expired. (7681)
Jet Reports 24.1.2 Build #24.1.2.1142
Release Date: April 30, 2024
Jet Reports 24.1.2
Resolved Issues 24.1.2
Corrected an issue in Jet Reports where connection was lost or timed out while trying to connect to Jet Analytics Cloud. (7108)
Corrected an issue in BC SaaS where Drilldown was returning incorrect results for the Purchase Line and Sales Line tables. (7032)
Corrected an issue where, when returning extension fields from a linked table using NL(Table) in direct SQL connections to Business Central version 23 or later, a report failed with an invalid field error. (6990)
Corrected an issue where multidimensional cubes could not be filtered by multiple levels of the same hierarchy. (6934)
Corrected an issue where reports from BC SaaS data sources were failing with an index that was outside of the bounds of the array error (black diamonds or batch failures). (7307)
Corrected an issue where reports failed to process empty dates in cache tables. (7128)
Corrected an issue where sorting by extension fields in direct SQL connections to Business Central version 23 or later caused reports to fail with the incorrect field error. (7053)
Updated the error message that is displayed when an incorrect password is entered while using Jet Analysis Services. (6620)
Jet Reports 24.1.1 Build #24.1.1.0811
Release Date: March 25, 2024
Jet Reports 24.1.1
Resolved issues 24.1.
Corrected an issue in the Jet Hub Scheduler where the email body was missing when editing a task. (7122)
Corrected an issue where loading data sources in the Jet Admin Console and Jet Hub was failing due to a permission issue with older Jet Budgets permissions. (6823)
Corrected an issue in Jet Hub where the checkboxes weren't visible due to the incorrectly formatted permission grid for data source permissions. (7031)
Corrected an issue in Jet Hub where modifying an existing schedule task would not update the next run time stamp. (6566)
Corrected an issue in Jet Hub where Administrator rights were not being granted by AAD Groups. (6977)
Jet Hub 24.1.1
Resolved Issues 24.1.1
Corrected an issue where the index was outside the bounds of the array (black diamonds or batch failures) in BC SaaS data sources. (7015)
Corrected an issue where option or enum members were being returned as numbers instead of values for NL First functions with cache tables enabled. (7064)
Corrected an issue where using BC Cloud with cache tables resulted in missing or incorrect data. (7102)
Corrected performance and reports crashing from BC Cloud issues. (7212)
Jet Reports 24.1 Build #24.1.0.0661
Release Date: March 12, 2024
Jet Reports 24.1
Features 24.1
- Administrators can now change culture ID when they run an invalid culture ID error. (6824)
Updated punctuation on the App Settings, Performance tab. (6294)
Added a new SMTP authentication type in Jet Reports that supports OAUTH 2.0, as Microsoft has deprecated basic authentication and plans to discontinue it in the near future. (6580)
Added logging to the Jet Logger to resolve 429 errors that you encounter during Web Service requests. (7030)
Resolved Issues 24.1
Corrected an issue where additional symbols were returned while using binary text function with Jet Data Manager data source. (6739)
Corrected an issue with multi-tenant BC SQL using Windows Auth where permissions validation was not working properly. (6725)
Corrected an issue where #VALUE error was displayed when flow field was used in rows filter and NF function. (6681)
Corrected an issue with Jet Reports where using Cache Tables feature with a BC Cloud data source, was returning to several decimal places, irrespective of the specified format. (6658)
Corrected an issue wherein, when selecting the unhide button on a table builder report, the table function was deleted when switching back to design mode. (6574)
Corrected an issue where BC group permissions were not applied for SQL data sources. (5879)
Corrected an issue where expired web services tokens were not handled properly, resulting in errors. (6775)
Jet Hub 24.1
Features 24.1
Jet Hub is compatible with .Net8. (6600)
Resolved Issues 24.1
Corrected an issue where, the Indirect Sum function in NL("Rows...") did not refresh until the sheet appeared after the referenced NL("sheets"). (1796)
In order to further serve our clients and complement the features included in Jet Reports, a new scheduler is added in beta format. (6254)
Added a new SMTP authentication type in Jet Hub that supports OAUTH 2.0, as Microsoft has deprecated basic authentication and plans to discontinue it in the near future. (6580)
Corrected an issue where signing into Jet Hub without entering a username and password results in the 404 error. (4427)
Corrected an issue when adding a Dynamics GP Data Source in the Jet Hub when selecting authentication was causing an error. (4566)
Corrected an issue where requirement messages were missing from the installer. (4739)
Release Date: November 8, 2022
Feature Updates
- Jet Reports Customers will have the ability to connect to D365 F&SCM data sources. (3397)
When connected via F&SCM, the table builder will display friendly names so that users can easily choose the data they would like to use in their report. (3647)
F&SCM connection will support all languages already supported by Jet. (3541)
While using an F&SCM data source, the field name will display to the user if a field does not have a caption or duplicate captions. (3343)
Jet Reports Customers can use Drill-down functionality with F&SCM data sources. (3719)
D365 F&SCM Universal Connector has been added to the Licensing Portal, which will give users with permission the option to select the connector from the drop-down list. (3641)
Resolved Issues
- Corrected an issue where, in some cases, intermittent data type errors occurred when running a report via SQL Direct Connection to Business Central (3500)
- Corrected an issue where in Business Central and NAV data source types the UTC offset was being incorrectly applied to Time type fields, affecting the timing of scheduled reports (3484)
- Corrected an issue where in some cases a report that included option value fields was not properly translating to the appropriate language when running the report. (3338)
- Corrected an issue where in some cases the date format was displayed incorrectly in the Jet Reports Scheduler. (2459)