Jet Reports - Release Notes 2023
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 are released in the year 2023.
See below for the changes that have been made for each chronological release.
Release Notes
Jet Reports 23.4.3 Build #23.4.3.0513
Release Date: February 21, 2024
Jet Reports
Resolved Issues
Corrected an issue where date ranges were passed to BC SaaS in local region format rather than being converted to US as expected by BC. (6904)
Jet Reports 23.4.2 Build #23.4.2.0382
Release Date: February 8, 2024
Jet Reports
Resolved Issues
Corrected an error where using the UTC+ time zone with the BC WebService data source resulted in incorrect date filters that resulted in incorrect data. The usage of the UTC+ time zone with the BC WebSwervice data source did not affect datetime filters.
Jet Reports 23.4.1 Build #23.4.1.0252
Release Date: January 31, 2024
Jet Reports
Resolved Issues
Corrected performance degradation issue when running reports against Jet Analytics Cube and Data Warehouse data sources. (6712)
Corrected an issue where attempting to filter using a text field added to an existing base table was failing. (6706)
Corrected an issue where authentication for business central was expiring after two hours. (6655)
Corrected an issue when using a universal data source, filtering was not working using dates and times. (6627)
- Corrected an issue where the company dropdown was not showing results when the number of companies was over 1000. (6608)
Corrected an issue where some extension fields in BC 14.0 and NAV 2018 were inaccessible via SQL direct data sources. (6604)
Corrected recalculation performance issue in Excel. (6598)
Corrected an issue where Batch Function Execution was failing in certain scenarios when Cache Tables hint was enabled. (6078)
Corrected timeout error when installing Jet Service Tier using Azure SQL. (4937)
Corrected time field filters parsing UTC times incorrectly for NAV SQL Data Sources. (4770)
Corrected an issue where Jet was double-parsing UTC dates, resulting in incorrect dates being reported. (6621)
Corrected issues with Business Central Cloud Authentication where credentials were not saved after signing in and the user is asked to perform authentication every time an action is performed. (5972)
Updated generic error message for installation errors to be more descriptive. (6284)
Jet Hub
Resolved Issues
Corrected an issue in Jet Hub where changing a scheduled task owner was not reflecting the change appropriately. (6163)
Corrected a severe performance degradation issue in Jet Hub on the Reports page when using report permissions using AD groups. (4722)
Jet Reports 23.4 Build #23.4.0.3181
Release Date: December 5, 2023
Jet Reports
Resolved Issues
Corrected an issue where SMTP settings were disappearing. (5405)
Corrected an issue where table builder was not identifying the third table and second link of the report. (5616)
Corrected an application error received when using link= in JFX - relationships for tables not populated. (6249)
Corrected an issue where running scheduled tasks using a Business Central Public Cloud data source with MFA enabled resulted in an error. (6420)
Corrected an issue with BC Web Services where dates were returning as SQL default minimum instead of blank when using cache table feature. (6453)
Corrected a "LINQ to entities" error that occurred while creating a folder in the Jet Hub. (6038)
Corrected a #VALUE error that occurred when running a report against an Azure Universal Datasource using cache table feature. (6013)
Corrected an issue where EULA was not being shown during installation if system was in pending restart stage. (5294)
Corrected an issue with the Cache Tables feature where a portion of the closing date was incorrectly removed, which made it appear as if the data was incorrect. (6550)
Features
Replaced Office 365 logo with new Microsoft 365 logo to align with Microsoft name changes. (6457)
Added ability to open the reports stored in Cloud from Jet Reports Queue after running the reports in the background. (6329)
-
Added the following validation message if Folder of reports is selected Folder of Reports” is selected and an HTTPS location is entered in Jet Scheduler:
The input path must be a folder. (6304)
Updated Extension for Business Central to increase performance. (6273)
Updated default page size for data sources from 1 to 10. (6272)
Updated Azure Active Directory to Microsoft Entra ID in Jet Hub to reflect the Microsoft name changes. (6233)
Updated Office 365 to Microsoft 365 in Jet Hub to reflect the Microsoft name changes. (6232)
Updated URL for Jet Basics Registration forms. (6138)
Jet Reports is now compatible with Business Central version 23. (4270)
Updated Data Source Setting for Timeout in BC Web Services to use client entered value and not BC Default value. (6228)
Jet Hub
Resolved Issues
Corrected an issue where a corrupt file was being created if you ran a report that contained a pivot table that had a duplicate column label in its source. (3057)
Corrected an issue in the Jet Hub on the reports page where folders and reports were showing incorrect cases. (6108)
Corrected an issue in Jet Hub where Always Open in Excel Online setting was not working properly. (6046)
Features
Updated Azure Active Directory to Microsoft Entra ID in Jet Hub to reflect the Microsoft name changes. (6233)
Updated Office 365 to Microsoft 365 in Jet Hub to reflect the Microsoft name changes. (6233)
Jet Reports 23.3.1 Build #23.3.1.2922
Release Date: October 24, 2023
Jet Reports
Resolved Issues
Corrected an issue where using GL function with long filters was resulting in an object reference error. (6145)
Corrected an issue where table cache optimization was failing when using dates without dashes or slashes. (6141)
Corrected an issue where batch function execution was failing in certain scenarios when Cache Tables option was enabled. (6078)
Corrected an issue where enabling cache table feature resulted in SQL lite errors in log files. (5984)
Corrected an issue where drilldown on option fields was failing for BC Web clients using non-English Language(5753)
-
Corrected an issue where, while returning the record ID field from the record link table, an error message similar to the following was displayed:
Fields of type 'GUID' are not supported in RecordID fields. (5687)
Corrected an issue where an error message was displayed when trying to use a record key on the user table in BC SQL. (5676)
Corrected an issue where Scheduled tasks were not refreshing pivot charts if data source table is on a hidden sheet and the output method is Web Page by Sheet. (3387)
Corrected an issue where current connector was showing as unlicensed when it was licensed. (3020)
Corrected an issue where values were returned with an equal sign using Static Batch Function Execution. (1193)
Corrected an issue where running functions with the NAV and BC Direct SQL data sources produced unfriendly error messages. (6397)
Corrected behavior with Business Central Cloud Authentication where user has to sign in every time he runs a report or tests a connection. (5972)
- Corrected the issues with the Jet ribbon that occurred after renaming Jet to Jet Reports. (5854)
-
Corrected an issue where running the reports resulting in the following error:
SELECT DISTINCT "Capacity Type"' is not a valid Data Source name. (5813)
Corrected an issue where SSL Checkbox in SMTP settings was automatically unchecked if Use Advanced Settings was selected. (5696)
Corrected Danish translations in Jet Reports. (5982)
Features
Updated Jet Reports to handle new change in BC 23 new table extension model. (6241)
Updated support links to navigate to the new documentation site. (5346)
Jet Hub
Resolved Issues
Corrected an issue where the running animation was missing when running a report. (6039)
Corrected an issue with Jet Hub Scheduler where the initial "Next Run" time was not set properly for monthly tasks. (5671)
Corrected an issue where, while accessing the data source, you would be prompted with Windows credentials, even though the data source you selected uses a non-Windows authentication method. (5038)
Corrected button styling across the Excel application. (6231)
Corrected an issue where buttons were missing in Jet Hub while trying to open a report. (6083)
Corrected an issue where uploading reports in Jet Hub resulted in 404 error. (5934)
Corrected an issue where signing into Jet Hub from the Excel ribbon was failing. (5758)
Jet Reports 23.3 Build #23.3.0.2321
Release Date: September 5, 2023
Jet Reports
Resolved Issues
Corrected an issue where trying to start the trial version resulted in an error. (5817)
Corrected an issue where selecting the Pivot table button associated to a cube data source resulted an error (5751)
Corrected an issue where the GL Budget field resulted in #Value (in conjunction with NL rows) when the cache table feature was enabled. (5750)
Corrected an error producing #VALUEs in certain reports when cache table feature is enabled. (5679)
Corrected an issue where columns and rows were not hidden on the first sheet when exporting pivot table as CSV. (5677)
Corrected an issue where Excel sheets were being duplicated in Jet Reports. (2108)
Corrected an issue where complete data was not shown in the Jet Trial window.
Corrected an issue where signing into the Jet Reports through Platform via Excel Ribbon was resulting into an error. (5784)
Corrected the incorrect styling of the cancel button in the Jet Admin Console (5777).
Corrected an issue where the text color was not readable in the Table Builder function. (5629)
Corrected missing translations for "No Data Source". (5514)
Corrected an issue where running the audit command in Jet Services Administration Shell was resulting in an error. (5227)
Features
Updated the default browser size of the window so that the entire content is visible. (5818)
Added company list in the alphabetical in the Company drop down on the Data Source Settings page. (5736)
Updated the Word Jet add-in ribbon icons to match the new ISW style. (5735)
Updated ribbon for Jet Reports Word add-in. (5734)
Upgraded NuGet.CommandLine package to the latest version. (5631)
Upgraded WebView2 and i18next packages to display web pages using chrome engine instead of IE 7 engine. (5613)
Updated null checks in authentication code for Jet Reports. (5557)
Updated Jet package to the latest ISW Platform package. (5519)
Updated Jet Reports application links from HTTP to HTTPS protocol. (5509)
Updated code to follow new coding standards regarding asynchronous calls. (5477)
Improved performance of the GL Function using a BC SaaS data source. (5475)
Updated JetScheduler SortType code to align with ISW Coding Standards. (5413)
Improved performance of Batch Execution function. (5383)
Updated regular expression usage to have timeouts in Jet Reports. (5374)
Updated the Jet Reports Excel Add-In Logos. (5349)
Jet Hub
Resolved Issues
Resolved 404 errors in developer console when loading Jet Hub. (5782)
Features
Upgraded NodeJS version to the latest version. (5296)
Upgraded jQuery packages in web projects. (3797, 5209)
Updated backend web package for security remediations. (5208)
Updated internal packages to the latest version. (4616, 4617)
Jet Reports 23.2.1 Build #23.2.1.2082
Release Date: August 1, 2023
Jet Reports
Resolved Issues
Corrected an issue where some translations were not functioning properly. (5670)
Corrected an issue where Dashboard mode not working as expected. (5669)
Corrected a problem where the Database and Company fields were empty after connecting to the SQL Server in the GP Updater and Caption Editor tools. (5602)
Corrected a problem where the universal data source couldn't connect to the database. (5496)
Corrected the scheduler animations to update automatically. (5404)
Corrected an issue that caused the Jet Reports for BC 14 Webservices to report that a Base-64 char array or string had an invalid length when using the BinaryText function. (4727)
Corrected an issue where the option field would sometimes return the wrong result when the first choice was a number. (3980)
Corrected an issue where the wrong functions were running while using Taiwanese traditional Chinese characters. (3494)
Corrected the size of the Install Update text box to be more appropriate. (5552)
Corrected size of the Upgrade Available dialog box. (5549)
Corrected issue where build number was not displaying correctly. (5548)
- Corrected the size of the Authentication dialog box in the Upload Report section. (5530)
Corrected an issue where querying for employee images resulted in an error. (5494, 5069)
Corrected an issue where running the Audit command in the Jet Services Administration Shell resulted in an error. (5227)
Corrected an issue where case sensitivity of CODE type fields in SQLite caused missing data when utilizing the CacheTables feature. (4908, 5515, 5622).
Corrected issue where Database dropdown was blank in Jet Administrator Console. (5815)
Corrected an issue where file explorer was not working when Run was running in background. (5755)
Jet Hub
Resolved Issues
Corrected a serious performance issue with Jet Hub's reports page that occurs when utilizing AD groups for report permissions. (4722)
Corrected an issue that prevented users with multi-domain installations utilizing on-premise Active Directory authentication from sharing group data sources with organizations outside of the primary domain.
Corrected an invalid value error in Area Code when downloading report from Jet Hub using BC Web Service data source. (5609)
Corrected color for "Delete" buttons so they are more visible. (5551)
Corrected a issue in Jet Hub that prevented a user with app permissions from changing the owner role. (3060)
Corrected a Jet Hub problem that appeared while opening a worksheet in Excel Online when another worksheet was already open. (4929)
Jet Reports 23.2 Build #23.2.0.23150.1
Release Date: June 13, 2023
Jet Reports
Resolved Issues
Corrected an issue where less than filter was using incorrect value in direct SQL connection. (4587)
Corrected an issue where additional symbols were returned when retrieving notes from BC using the NL(“BinaryText”) function. (3809)
Corrected an issue where incorrect functions were running when using Chinese (traditional, Taiwan). (3494)
Moved MSALCache File to %appdata% folder to allow multiple users to use a shared device to connect to the data source. (5487)
Corrected the database schema issue when upgrading the Jet Services database from an older version. (5507)
Corrected an issue where translations were missing in the Jet Ribbon. (5395)
Corrected wording in the About section of Jet Reports. (5378)
Corrected an issue where dashboard tables were still appearing in the database after the upgrade. (5361)
Corrected an incorrect error message in Jet Service Tier when logging in using database authentication. (5347)
Correct error message when trying to access data source with incorrect permission set. (5242)
Corrected an issue where the initial user was being created as an AD user when selecting Azure AD as the authentication type. (5217)
Corrected an issue where cache tables were not working when key= was used. (4907)
Features
Installer UI is updated to match the color and design standards at insightsoftware. (5056, 5153, 5384)
Installer UI is updated with new notification/warning window to match standards set forth at insightsoftware. (5148)
Added a check to look for Windows Group during Active directory login to improve performance. (5143)
Updated the .Net Core version in the installer to .NET 6.0.16 as .NET Core 5.0.17 is deprecated by Microsoft. (5126)
Created Enable CacheTables option that would be enabled by default on the Performance Enhancement tab. (4772)
Updated Installer to include config files for all installed applications for Jet. (4543)
Jet Hub
Resolved Issues
Corrected an issue where AAD installations of the Jet Hub were not using Windows authentication in data sources correctly. (5225)
Features
Updated the .Net Core version in installer to .NET 6.0.16 as .NET Core 5.0.17 is deprecated by Microsoft. (5126)
Jet Reports 23.1.1 Build #23.1.23117.1
Release Date: May 3, 2023
Jet Reports
Resolved Issues
Corrected an issue where some extension fields in BC 14.0 and NAV 2018 were inaccessible via SQL direct data sources. (4172)
Corrected an error message when using ODATA connection to Jet Codeunits. (4896)
Corrected an issue where re-running reports in Report Mode causes Lookup functions to be calculated. (4909)
Corrected an issue where, in some cases, authentication (another user) was making a call to the SQL server using the current user instead of the user defined in the data source settings. (5243)
Corrected functionality for multi-threading in the batch execution function to resolve black diamond issue. (5244)
Corrected a connection issue when using NAV User Password with NAV or BC web service On-Premise data source in Jet Hub. (5292)
Corrected an index error while authenticating NAV/BC via Office365 authentication methods (BC SaaS and BC On-Premise). (5300)
Corrected an issue with BC extension fields or flow fields that was not working properly. (5302)
Corrected an issue where selecting Azure Active Directory during a platform installation was crashing the installer. (5350)
Features
Added timeout for download site call. (5106)
Updated Table Builder Screen to match UI Standards. (5214)
Updated error message for shared data source to not say Microsoft Dynamics Nav when it is not a NAV data source. (2503)
Updated publisher information for installed application. (4852)
Jet Reports is now compatible with Business Central version 22. (4270)
Updated Cookie Settings for Jet Hub to enhance security. (5050)
Added logs to help diagnose a potential issue for F&SCM Data Sources. (5078)
Introduced table relationship predictions in JFX and table builder for BC SaaS. (4075, 5053)
Jet Hub
Resolved Issues
- Corrected an issue in the Jet Hub where, when editing a user, the Username label was being shortened. (2200)
- Corrected an issue where data source help link was not working. (2479)
- Corrected an issue when logging in with a group user into Jet Hub resulted in the following error: Access Denied was received in the Excel add-in with an "ERR_TOO_MANY_REDIRECTS" error. (3415, 5021)
- Corrected an error message in Jet Hub to be more descriptive when connecting to Azure Active Directory. (5200)
Jet Reports 23.1 Build #23.1.23090.1
Release Date: March 31, 2023
Jet Reports
Resolved Issues
Corrected an issue where sheets created using NL (Sheets) with strings starting with C or R resulted in the HRESULT error. (3152)
Corrected an issue that occurred while signing into a BC SaaS data source. (4356)
Corrected an issue where the dimensions and measures for the cube data source did not appear. (4464)
Corrected an issue where using NL (picture) with BC web services and data sources resulted in an error. (4467, 4537, 4728)
Corrected an issue with the platform installation that was preventing the proper synchronization of data sources. (4539)
Corrected an issue where filtering using special characters for the Option Type field was not allowed. (4580)
Corrected an issue where performing SUM for the Duration field results in the numeric error.(4771)
Corrected an issue where, after the successful Azure Active Directory Auth test connection for the data warehouse, the connection string error occurred. (4872)
Corrected the port field in ODATA Web Services from "SOAP services port" to "Web services port". (5025)
Corrected an issue where non-disabled items on the Data Source Settings screen were not available. (5082)
Corrected extra white space on the Data Source Authentication settings screen for GP Data Sources. (5086)
Features
Added the ability to upload a report to Jet Hub from a location that is synced with OneDrive. (2937, 4964, 5060)
Updated orders mail Id from orders@jetglobal.com to orders@insightsoftware.com in Jet Reports. (2952)
Added the application intent setting to the Jet Admin Console. (3205)
Multi-threading performance is enhanced when NF functions are used on a flow field with flow filters, while the execution of batch functions during internal testing led to a 500% performance increase. (3452, 4002, 4057)
Deprecated Jet Dashboard Builder from Jet Reports. (3792, 3795, 4335, 4586)
Deprecated Jet Budgets from Jet Reports. (4454, 4693, 4694, 4695)
Enhanced Installer UI as per new UI guidelines. (4752, 4959)
Removed SQL Native Client in favor of MSAL Library to align with the Microsoft standards. (3875, 3876, 4366, 4392, 4591)
Implemented MFA with Azure Active Directory Authentication for Jet Reports and admin console. (3842, 3881, 3903, 4176)
Implemented Azure Active Directory service-to-service authentication for Jet Data Warehouse. (4179, 4180)
Replaced System.Data.SqlClient dependency with Microsoft.Data.SqlClient. (4204)
Replaced OLEDB interop connection with Microsoft.Data.SqlClient API. (4272)
Increased usability by updating an error message associated with BC Cloud NL("Picture"). (3920)
Deleted all references to the Jet Reports Financials activation URLs, which are no longer supported. (3932)
GL() function performance on the Business Central public cloud has been improved when using Analysis Views. (3437, 3967, 4022)
Updated internal packages to the latest version for Jet Reports. (4617)
Jet Hub
Resolved Issues
Corrected an issue where user was unable to sign in to Jet Hub when the Azure Active Directory connection was disconnected. (4557)
Corrected an issue, where, if you try to upload reports without selecting the data source, signing in to the application occurs. (4686)
Corrected an issue where adding a user to Azure Active Directory failed if the email field was empty. (4906)
Corrected an issue in the Jet Hub where File input fields were displayed in the incorrect location. (5072)
Features
Users who access a Jet Report with a pivot table from Jet Hub will now see a warning notice informing them that they must manually refresh the table for the most recent data. (2324)
For NAV and BC On-Premise data sources, Microsoft 365 Authentication has been implemented in the Jet Hub (3464, 3467, 3900)
Implemented MFA with Azure Active Directory in Jet Hub for Jet Data Warehouse. (3880, 3902)
The BC Cloud MFA settings are now available on the Data Source Settings page. (4865)
Implemented service-to-service Authentication for Azure Active Directory, a prerequisite for the multifactor authentication with Azure Active Directory in Jet Hub. (4746)