Jet Reports - Release Notes 2022
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 2022.
See below for the changes that have been made for each chronological release.
Release Notes
Jet Reports 22.4.2 Build #22.4.23039.1
Release Date: February 13, 2023
Jet Reports
Resolved Issues
Corrected and issue in Table Builder where it was not recognizing localized VERT.ZOEKEN() as VLOOKUP(). (4110)
Corrected an issue where in some cases, the Jet Scheduler would encounter a timeout error when running a batch process. (4483)
Corrected an issue when using O365 Authentication the Drilldown Settings were reverting Back to Default Settings. (4583)
Corrected an issue where a 429 error "Too many Requests" was being returned from Business Central, this error is now handled gracefully behind the scenes. (4593)
Corrected an issue with the Cache Tables feature in region issues with SQLite syntax was preventing the feature from working correctly. (4783)
Jet Hub
Resolved Issues
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)
Jet Reports 22.4.1 Build #22.4.23020.1
Release Date: January 23, 2023
Jet Hub
Resolved Issues
Corrected an issue where DataSource= did not work in reports uploaded to the Jet Hub. (4434)
Jet Reports 22.4 Build #22.4.22356.2
Release Date: December 22, 2022
Jet Add-In
No BC Extension updates were associated with this release.
Feature Updates
Jet Reports now supports MSAL, Microsoft Authentication Library. (3715)
Updated the Azure Active Directory authentication methodology to ensure compatibility with Microsoft's new recommended authorization code flow. (2262)
Introduced Feature to add upload capability to F&SCM (4163)
Updates to Jet Installer to support integration with insightsoftware Platform (3894)
Updates to Colors, Fonts, and Icons within Jet Reports to support new Marketing and Branding guides (3710)
Resolved Issues
Corrected an issue where users running a new install of On-Prem for Business Central were unable to install the BC 19 On-Prem version of the Jet Reports extension. (3871)
Improved the error message displayed when running a report which contains a cell with large amounts of text in one cell. (4455)
Corrected an issue where customers using BC on-premise with Jet FOB business objects installed, were unable to upgrade from the BC 14 Extension to BC 15 or higher unless objects were removed prior to the upgrade. (3966)
Corrected an issue where running NL(Picture) against MediaSet type fields in Dynamics NAV SQL data sources would result in an error. (3957)
Corrected an issue where the use of some character sets in Page APIs resulted in a specified path or file name that was too long, resulting in the inability to connect to a BC Cloud environment. (3835)
Corrected an issue in the Jet Scheduler to output to CSV and TXT correctly when only one line is returned. (2589)
Corrected an issue where in some cases, the Jet Scheduler would encounter a timeout error when emailing via SMTP, resulting in the output file failing to send as expected. (1625)
Jet Hub
Feature Updates
Jet Hub now supports MSAL, Microsoft Authentication Library. (3716)
Updates to Colors, Fonts, and Icons within Jet Reports to support new Marketing and Branding guides (3710)
Updates to Jet Installer to support integration with insightsoftware Platform (3894)
Resolved Issues
Corrected an issue where "Run in Background" functionality would result in an error if authenticating against the Jet Service Tier via the Jet Hub. (3758)
Jet Reports 22.3.3 Build 22.3.22315.1
Release Date: November 14, 2022
Jet Add-In
Resolved Issues
Corrected an issue when using the “Values only” option in the Jet Scheduler was not working. (4436)
Jet Reports 22.3.2 Build 22.3.22306.1
Release Date: November 8, 2022
Jet Add-In
Feature Updates
Upgraded permission sets in BC Cloud Extension and permissions to align with Microsoft changes. (3970)
Resolved Issues
Corrected an issue in the Jet Scheduler to output to CSV and TXT correctly when only one line is returned. (2589)
Corrected an issue in the Jet Scheduler when output type is set to CSV. (2744)
Corrected an issue in the Jet Scheduler when editing a task the Selected Named Range was defaulting to the first value. (3048)
Corrected an issue the installer would fail if Jet Hub and Jet Service Tier were installed together and the .NET components were version 5.0.9 or higher. (3460)
Corrected an issue where the Run from Cache button was not being displayed either in the collapsed or expanded view as a Designer. (3578)
Corrected an issue where an error would occur when running a report that used record keys against system tables with a ‘Dynamics 365 Business Central (SQL Server) On-Premises’ data source, (3935)
Corrected an issue where a report would return inaccurate data when using the +CacheTables keyword/functionality. (3941)
Corrected an issue where the batch report wizard would not open correctly. (4074)
Corrected an issue where in some cases, running queries on tables while using a Universal Connector Data Source would result in an error message. (4084)
Corrected and issue with the default data source failed to save or load properly. (4091)
Corrected an issue with CacheTables that degraded the performance by increasing the time it took to run a report. (4093)
Corrected an issue where NP Codeunit was returning an error using ODATA Connection with Web Services. (4094)
Corrected an issue where users were unable to set Database Authentication to a "Shared" setting when using a Dynamics GP Data Source. (4147)
Corrected an issue where Universal data source Configure Literals text values were being cut off. (4236)
Corrected an issue where logging into BC Web Services using the office365 authentication method, the web service instance keeps defaulting back to the BC SaaS default of /v1.0/AzureTenantId. (4326)
Corrected an error during login of a BC Saas Data source. (4356)
Corrected an issue where permissions were not being applied correctly in BC SQL on BC 18+ versions. (4404)
Jet Hub
Resolved Issues
Corrected an issue when user full name field contained a trailing space. (3411)
Corrected an issue where Support for export of blob fields - NL("BinaryText") and NL("Picture") for Business Central Public Cloud was not working. (4205)
Jet Reports 22.3.1 Build 22.3.22271.1
Release Date: September 29, 2022
Jet Add-In
No BC Extension updates were associated with this release.
Resolved Issues
Corrected an issue where using DD/MM/YYYY date formats with SUM and GL functions filtering on date ranges caused incorrect data to be returned in the report. (4208)
Jet Reports 22.3 Build 22.3.22258.1
Release Date: September 19, 2022
Jet Add-In
No BC Extension updates were associated with this release.
Feature Updates
- Updated the default connection for new customers from SOAP to ODATA to begin preparation for Microsoft's upcoming SOAP depreciation. (3502, 3895)
- Enable authentication to NAV or BC OnPrem data sources with Office 365 credentials if multi-factor authentication is enabled on the users Office 365 account. (2218, 3457, 3465)
Resolved Issues
Corrected an issue where period name was removed from the date table in BC Cloud data sources. (4040)
Corrected an issue where reports run in NAV Web Services would crash before completion. (4128)
Corrected an issue where Word Export would not support numerous chart types and would result in error. (4089)
Corrected an issue for non-US regional settings where when filtering a date time, the date did not convert to US format as the web service expected, resulting in an error. (3661)
Corrected an issue with Simulation Mode that displayed unavailable options to users. (3143,3964)
Corrected an issue where the drilldown would return an error when filtering with the 'One Unknown Character' filter. (3552)
Corrected an issue with BC Web Services where reports would not return data after approximately two hours of run-time. (3917)
Corrected an issue where editing a schedule task via the Scheduler would reset the path when configured to output a CSV or TXT file type. (3135)
Jet Hub
Resolved Issues
Corrected an issue where in some cases the cloud authentication screen would display when non-cloud data source is selected. (2778)
Corrected an issue where attempting to run or upload a report against a non-BC Cloud data source forced BC Cloud authentication so long as a shared BC Cloud data source existed. (3065)
Jet Reports 22.2.1 Build 22.2.22236.1
Release Date: August 12, 2022
Jet Add-In
Please install the latest BC Extension (version 1.0.8.24) to utilize this version of Jet Reports Add-In.
You can find the latest BC Extension in App Source for BC Public Cloud or on the insightsoftware downloads page for BC On Prem.
For More information about the BC Extension Update, see the table at the bottom of this page.
Feature Updates
Enabled the TenantID field on the OData configuration option for the BC on premise Web services data source. (3806)
The Jet Reports Browser will now show relationships. (2430, 3919)
Resolved Issues
Corrected an issue where in some cases TableCaching would not return correct results. (1400)
Jet Reports users can use Excel dynamic array formulas. (3713)
Fixed error caused by filtering blank values in security filters for Date and Date and Time fields in Dynamics NAV and Business Central SQL data sources. (3863)
Corrected an issue where users received an NL error when filtering ENUM fields using blank values. (3937)
Corrected an issue where the output file name indicated by a user in the Jet Scheduler, did not actually dictate the output file name and the task to email the output failed. (2779).
Corrected an issue where reports that included Jet functions and a PivotTable would break when switching to Design mode or re-running the report. (3823)
Corrected an issue where refreshing or switching to design mode while running a report, caused customers to encounter a #REF error due to "@" erroneously being added to the function. (2586)
Corrected an issue where in some cases Authentication (other user) was making a call to the SQL server using the current user instead of the user defined in the data source settings. (3454)
Corrected an issue where certain fields were failing to retrieve data when running a report against the Date or Integer table. (3838)
Corrected an issue related to F&SCM where some data entities were not exporting successfully. (3803)
Corrected an issue when in some cases, users received an error when authenticating their BC SaaS data source. (3981)
Jet Reports 22.2 Build 22.2.22175.1
Release Date: June 27, 2022
Jet Add-In
Feature Updates
Updated the Business Central OnPrem language captions to align with Microsoft changes. (3220)
Support for export of blob fields - NL("BinaryText") and NL("Picture") for Business Central Public Cloud. (1913, 3469)
Business Central Web Services data sources now filter on Extensible ENUMs. (3558, 3562, 3928)
The F&SCM connection will automatically refresh the user's token after an extended time period of no activity, eliminating the need to manually refresh the connection. (3344)
Jet Reports complies with BC Universal Code Initiative (3533)
Improved security of the Jet Scheduler by eliminating a potential keylogging activity vulnerability. (3740)
Resolved Issues
Corrected an issue where in some cases users with a BC SaaS data source were receiving an error when the NL first references an NF function in its filter. (3166)
Corrected an issue where in some cases TableCaching would not return correct results. (1400)
Corrected an issue where in some cases Excel was crashing when a user attempted to drag and drop tables/fields from the Jet Browser. (2172, 3817)
Corrected an issue where customers received a drilldown error when using an NL Count function with an NL filter. (2926)
Corrected an issue where scheduled tasks created in the Excel scheduler would not run as a non-admin user, even if they had permission to run scheduled tasks. (3201)
Corrected an issue where in some cases UTC offset was being incorrectly applied to Time type fields. (3862)
Corrected an issue where in some cases Excel would crash and re-load when using the drop downs in the Report Wizard. (3878)
Jet Hub
Feature Updates
- Improved security related to IIS home page(3514)
Jet Reports 22.1.3 Build 22.1.22137.1
Release Date: May 18, 2022
Jet Add-In
Resolved Issues
-
Resolved issues when reporting on flow fields from BC direct SQL data sources. (3518, 3365, 3461, 3510)
- When a user runs a report with an Exist FlowField that is nested, the report will return the correct calculations without error. (3518)
- Business Central on-premise Direct SQL data source will run reports containing FlowFields without error (3510)
- Corrected an issue where Business Central on-premise Direct SQL data source was not recognizing extension FlowFields correctly (3461, 3365)
Jet Reports 22.1.2 Build 22.1.22125.1
Release Date: May 10, 2022
Jet Add-In
Resolved Issues
- Corrected an issue where all Web Services data sources were defaulting to use ODATA Web Services. (3812)
- Corrected an issue where users creating a new Dynamics GP On Premise data source in Jet Reports were unable to authenticate using any method other than Windows Authentication. (3777)
Jet Hub
Resolved Issues
- Corrected an issue where users were unable to use a Jet Data Warehouse data source with Database Authentication in the Jet Hub. (3822)
Jet Reports 22.1.1 Build 22.1.22115.1
Release Date: April 26, 2022
Jet Add-In
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)
Jet Reports 22.1 Build 22.1.22095.4
Release Date: April 12, 2022
Jet Add-In
Feature Updates
- Jet Reports is now compatible with Business Central version 20. (3525)
- Improved Performance when returning to Design Tab after running a report. (3318)
- SaveAsCSV function and SaveAsTxt now support Regional List Separators, for example, a delimiter of a semi-colon instead of a comma. (1958)
- Improved efficiency of retrieving data from the Date Table and Integer Table in Jet Reports. (3118)
- Jet Reports users can select Azure A/D or Database Authentication on the Authentication Tab when the data source is a Jet Data Warehouse. (3323)
- Updated the default connection for new customers from SOAP to ODATA to begin preparation for Microsoft's upcoming SOAP depreciation. (3502)
- Jet Reports can now run against a data warehouse on an SQL Data Pool. (2863)
- Corrected an issue where in some cases the entire zip file was not downloaded when upgrading versions from the Jet Ribbon in Excel. (3756)
Resolved Issues
- Corrected an issue where in some cases NL(Count) would return an ambiguous column error with BC Direct SQL Connection. (1626)
- Corrected an issue where NP Codeunit was returning an error when using the new ODATA connection with web services. (3033)
- Corrected an issue where the Codeunit would not populate when using the new ODATA connection with web services. (3239)
- Corrected an issue in the BC Extension, where in some cases error messages were not being displayed in OData (2827) (Impact: extension only)
Jet Hub
Feature Updates
- Jet Hub users can select Azure A/D or Database Authentication on the Authentication Tab when the data source is a Jet Data Warehouse. (3326)
- Enabled support for TLS 1.2 and 1.3. Please note: Jet Hub will no longer support TLS 1.0 and 1.1. (3417)
- Improved security related to HTTP protocol for session related cookies. (3513)
- Improved error message and HTTP header security. (3515)
- Added the Read-Only Replica Application Intent setting to the Jet Hub data connection, giving customers the ability to connect to the read-only replica of their NAV database on the SQL cluster to run reports. (3203)
- Improved security of Jet Hub Application Start event. (3419)
Installer
Feature Updates
- Improved the verbiage of the Jet Service Tier error message that displays when a user does not have the required access during installation. (2651)
- Updated the Jet Reports installer so that users can now install using an Azure SQL public endpoint when Azure is in a different virtual network. (3425)