Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Jet Reports - Release Notes

Jet Reports (including the Jet Excel add-in and Jet Hub) receives updates on a regular basis.

Click this link to see What's New in the most recent Major release of Jet Reports.

See below for the changes that have been made for each chronological release.

Release Notes

Jet Reports 24.1.2 Build #24.1.2.1142

Release Date: April 30, 2024

Jet Reports

Resolved Issues

  • 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 Hub

Resolved issues

  • 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 Reports 24.1.1 Build #24.1.1.0811

Release Date: March 25, 2024

Jet Reports

Resolved Issues

  • 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

Resolved Issues

  • 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)

Features

  • 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)

Jet Hub

Resolved Issues

  • 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)

Features

  • Jet Hub is compatible with .Net8. (6600)

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)

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)

Jet Reports 21.4.2 Build 21.4.22025.1

Release Date: January 27, 2022

Jet Add-In

Resolved Issues

  • Corrected an issue where in some languages the weekday was not displaying correctly in the Jet Reports Scheduler. (2125)
  • Corrected an issue where Business Central on-premise Direct SQL data source was not displaying extended ENUM option captions in report. (3422)
  • Corrected an issue with expired tokens where users were receiving the incorrect error message and were not being prompted to re-authenticate their account against the Jet Service Tier. (3158)
  • Corrected an issue where the NL(Sheets) function with embedded NF() did not work with the following data sources: 'Dynamics NAV 2013-2018 (SQL Server)' & 'Dynamics 365 Business Central (SQL Server) on-premise'. (3233)

Jet Reports 21.4.1 Build 21.4.21337.1

Release Date: December 20, 2021

Jet Add-In

Resolved Issues (impact: extension only)

  • Corrected an issue where security filters were preventing data from being returned. (3367)

Jet Reports 21.4.1 Build 21.4.21337.1

Release Date: December 09, 2021

Jet Add-In

Feature Updates

  • Enhanced filters to allow multiple filter values against the same field when running against BC Public Cloud. (3316)
  • To make the process of scheduling and distributing batch reports faster and easier for users, Jet Reports introduces a new report scheduling wizard. The new wizard walks the user through a series of simple questions to complete a batch schedule and report template for them. The new Batch Report Wizard button can be found on the Jet Ribbon in the Tools section beside the Report Wizard button. (3360)
  • Improved the verbiage on the Email Tab of the scheduler to reflect an Error Notification. (3395)

Resolved Issues

  • Corrected an issue where using NL(BinaryText) function would return an error or not return data. (3385)
  • Corrected an issue where Jet Basics would not function without the trial running and give an error. (3405)
  • Corrected options for CC and BCC on the scheduler (3479)

Jet Reports 21.4 Build 21.4.21281.3

Release Date: October 12, 2021

Jet Hub

Resolved Issues

  • Updated Jet Hub so that if TLS 1.0 and 1.1 are disabled with TLS 1.2 enabled, O365, Azure, and Basic user logins will work. (2273)

Jet Add-In

Feature Updates

  • To help users identify and correct potential errors more quickly when scheduling and distributing batch reports, Jet Reports has added the ability to send a user an email indicating an error has occurred with a report. This can be found in the Schedule Task window on the Email Tab. (3302)
  • When a new BC Cloud connection is created, the page size (MB) setting will now default to 1 instead of .1. This will improve performance for large reports that take advantage of batch execution. This change will not affect cloud connections that already exist. (2786)

Resolved Issues

  • Corrected an issue where Jet was not properly handling decimal values in regions where a comma is used instead of a decimal. (3348)
  • Fixed an issue so that NL(Sum) and NL(Count) return the same data as NL(Rows) when considering time localization with date/time fields in the database. (3207)

Installer

Resolved Issues

  • Updated the installer to allow upgrade of the Jet Service Tier on an Azure SQL instance. (3184)

Licensing

Resolved Issues

  • Corrected an issue where if TLS 1.0 or 1.1 are disabled, you cannot activate the Jet license. (2201)

Jet Reports 21.3.1 Build 21.3.21244.1

Release Date: September 2, 2021

Jet Hub

Resolved Issues

  • Corrected an issue causing an object reference error when running nested functions against BC Odata connection. (3101)
  • Corrected an issue when attempting to download files with certain Japanese characters in the filename would result in the file downloading with a numeric filename instead. (3137)

Jet Add-In

Feature Updates

  • When a new BC Cloud connection is created, the page size (MB) setting will now default to 1 instead of .1. This will improve performance for large reports that take advantage of batch execution. This change will not affect cloud connections that already exist. (2786)

Resolved Issues

  • Corrected an issue causing an error to be returned when using Limit= with a BC Web Services connection. (3253)
  • Corrected an issue causing a BC on-premise Direct SQL data source to not recognize extension FlowFields correctly. (3254)
  • Corrected an issue where an invalid field error would be thrown when a report uses a FlowField in Nav. (3285)
  • Corrected an issue causing an object reference error when running nested functions against BC Odata connection. (3289)

Jet Reports 21.3 Build 21.3.21200.5

Release Date: July 23, 2021

Technology Upgrades

  • This release includes upgrades to Microsoft .NET Core 5.0 and Microsoft .NET framework 4.8. The installation of this Jet release will automatically install these needed upgrades before installing Jet Reports release 21.3.

Jet Hub

Feature Updates

  • Added the ability to turn on/off logging from the Jet Hub under Settings->Logging. (2282)

Resolved Issues

  • Corrected an issue so conditional formatting will be applied on a report with Dutch language. (2124)
  • Corrected an issue where selecting Open in Excel Online was not working in Chrome. (2422)
  • Corrected an issue to prevent getting a credential error when using an on-premise data sources with an Azure AD or basic authentication Jet Service installation. (3163)
  • Corrected an issue where weekly tasks would duplicate one day but leaving out another day (3228)

Jet Add-In

Feature Updates

  • Enhanced the NL First function to return the same results when run against Web Services or Direct SQL when sort is not provided. (3170)
  • Enhanced the Evaluate Function to return the same results when using Web Services or Direst SQL connections to Business Central. (3171)

Resolved Issues

  • Corrected an issue where NL(First) and NL(Last) could produce incorrect results when using Web Services vs Direct SQL. (1323)
  • Corrected an issue when using Table Builder and linking from a custom field to link to another table so an "invalid column name" error is no longer issued and the link works correctly. (2761)
  • Corrected an issue where a formula with nested NF function didn't return the correct results when using German regional format. (2792)
  • Corrected an issue caused cells to return when #Value when using OData BC Connector with a large number of GL Functions. (2867)
  • Corrected an issue where the Check for Updated Version was not properly displaying a message that an updated version of Jet Reports was available. (3198)

Jet Services Administration Shell

Feature Updates

  • Added the ability to turn on/off logging from the Jet Services Administration Shell using the command Set-LoggingOnOff. If a 1 is provided after the command, logging will be turned on. If a 0 is provided after the command, logging will be turned off. If a value of is not provided, you will get a message on the values to provide. (3181)

Jet Reports 21.2.2 Build 21.2.21159.1 Release Date: June 11, 2021

Jet Add-In

Resolved Issues

  • 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. (1601)
  • Significantly Improved performance when using a Direct SQL connection on BC databases with a large number of companies. (2777)

Jet Reports 21.2.1 Build 21.2.21146.1 Release Date: May 26, 2021

Jet Add-In

Feature Updates

  • Changed the program to allow entering a user for a scheduled task that is not the current user. (2318)

Resolved Issues

  • Corrected an issue that would cause an error when trying to run a report that included a table which has a table extension installed. (1716)
  • Made a change so that when a metadata key error is experienced, Jet will make a log entry instead of generating an error. (2602)
  • Corrected an issue where in some circumstances an error would be issued when running a report with an extension field. (2794)
  • Made a change so that Enum fields can now be seen and used. (2795)
  • Corrected an issue so when connecting to a BC data source via ODATA where the company contains an ampersand, the connection will be successful. (3196)

Jet Reports 21.2 Build 21.2.21112.1 Release Date: April 27, 2021

Jet Security Protocols

  • Enhanced Jet to work correctly with TSL 1.2. (3019)

This enhancement has resolved the following issues:

      • Corrected an issue accessing Cubes over IIS connection where an error "Could not create SSL/TLS secure channel". (2927)
      • Corrected an issue where Jet Hub Scheduler would not run tasks when only TLS 1.2 is enabled. (2270)

Jet Hub

Resolved Issues

  • Corrected an issue where refresh tokens were duplicated causing the error "An item with the same key has already been added" to occur. (3088)
  • Corrected an issue when scheduling tasks so that the day/time selected would be saved correctly. (2919)

Jet Add-In

Feature Updates

  • Enhanced the Table Browser to hide tables the user does not have permission to access. (2729)
  • Improved Jet Reports performance when running in a multi-core environment. (2787)

Resolved Issues

  • Changed the program so that connection with ODATA does not give an error if the user does not have permissions to the table. (2662)
  • Users can now be added from another domain in the Jet Service Tier. (2707)
  • Corrected an issue where in some circumstances, you would get an error when activating the Jet Basics Trial. (2745)
  • Made a change so that Enum fields can now be seen and used. (2795)
  • When pulling source document field from Warehouse receipt line table, the value returned is now correct. This was due to a change in BC SaaS 17.1. (2833)
  • When using a BC SQL data source, if the table extension is off a non-standard table such as one from a third-party app, the extension table/fields are now shown in the browser and can be pulled in an NL function. (2868)

Jet Reports 21.1 Build 21.1.21021.1 Release Date: February 2, 2021

Jet Hub

Feature Updates

  • Jet Hub has been updated to allow multifactor authentication for Business Central Web Services data sources.  Administrators can enable this feature via the settings tab within the Jet Hub. Detailed instructions on setting up multifactor authentication can be found here: Enabling Multi-factor authentication for BC Cloud Web Services data sources within the Jet Hub . (2677)
  • The expanded implementation of the ODATA toggle for connectivity is extended to Jet Hub and JET ADMIN CONSOLE. (2678)

Jet Add-In

Resolved Issues

  • Corrected an issue where filtering on timefield could return incorrect results. (1575)
  • Eliminated an error that occurred when running reports from BC's item table with a deprecated extension field. (2087)
  • Jet Tab now loads correctly when running Excel via "Run as Administrator". (2738)
  • Corrected an issue where the output type of .xlsm was not always handled correctly. (1605)
  • Corrected a blank filter error that would occur when using BC Web Services but would not occur using a Direct SQL Connection. (2305)

Jet Reports 20.8 Build 20.8.20353.1 December 18, 2020

Changes since 20.8.20297.3

Excel Add-in Implemented additional telemetry to the Jet Reports add-in. This is used to enhance our understanding of application usage. Added clarity to the error message when internet is not available to the user.

Jet Reports 20.8 Build 20.8.20297.3

October 29, 2020

Changes since 20.7.20295.1

Excel Add-in

New Connector for Jet Reports into Microsoft Business Central In version 20.8 .  We are making available a new connector for Business Central, based on the OData API. This new connector is significantly faster than the existing SOAP connection.  The new connector installs in minutes, requiring the installation of an extension to Business Central. You can access the new OData connector through our Early Adopter Program until we release the next version of Jet Reports in Q1, 2021. Jet partners and customers interested in using the new connector should contact insightsoftware support and request access to the installer for the extension.  The new connector is available for users of Jet 20.8 and Business Central 16 and above. At the end of the Early Adopter Program, we plan to publish the extension through Microsoft AppSource.   Additionally, we have validated this version of Jet Reports against Business Central, 2020 Wave 2.

Jet Reports 20.7.2 Build 20.7.20295.1

October 29, 2020

Changes since 20.7.20246.2

Excel Add-in

Certification with Microsoft Business Central, 2020 Wave 2 .  We have validated this version of Jet Reports against Business Central, 2020 Wave 2.

Jet Reports 20.7.1 Build 20.7.20246.2

September 3, 2020

Changes since 20.7.20210.6

Jet Hub

Fixed Issue - Authenticating users against a BC data source in the Jet Hub doesn't work for anyone other than the user that created the data source

Excel Add-in

Fixed Issue - Attempting to install Client Components or All Components on a machine with Excel is not possible Fixed Issue - Cannot install Jet Hub without Jet Service Tier selected

Jet Reports 20.7 Build 20.7.20210.6

July 28, 2020

Initial release of Jet Reports 20.7

Jet Reports

  • Simplified installation process: The Jet Reports install process has been streamlined to make installation quicker, easier, and more intuitive.

  • Rebranded Excel Add-in: The look- and- feel of the Jet Reports Excel-add-in has been updated with fresh new icons for a cleaner interface, while bringing it in line with insightsoftware’s brand.

  • Connect to read-only NAV databases: Jet Reports administrators can now configure the Application Intent parameter of the SQL connection, enabling them to use the read-only replica of the NAV database in Azure.

Jet Hub

  • Seamless authentication with Business Central Cloud for Jet Hub Users: When a user receives a shared report through the Jet Hub that they want to refresh against Business Central Cloud, they will now be prompted to enter their Business Central credentials via the Hub and they will then be able to refresh reports against their profile.

Jet Hub

Fixed Issue - German translations are both incorrect and missing in the Jet Hub Scheduler

Fixed Issue - Jet Hub Report Options adding time onto date erroneously

Fixed Issue - Trying to Add a Basic Authentication user Edits the last user you were selected on if you don't deselect them first.

Fixed Issue - Grid check-boxes do not display in Jet Hub when using IE/Edge

Added support for using Azure proxy for both Authentication and Reporting while connecting to BC Cloud

Excel Add-In

Fixed Issue - Query does not seem to bring all results from the table

Fixed Issue - Jet Function Evaluation issue with versions 20.4 and later

Fixed Issue - Customized Drill-down view settings wiped out if user drills down on cell with no records

Fixed Issue - Jet Reports - Using Binary Text in NL function - special danish character turn into strange symbol

Added support for using Azure proxy for both Authentication and Reporting while connecting to BC Cloud

Jet Reports 20.6.1 Build 20.6.20143.4

May 26, 2020

Changes since 20.6.20126.5

Excel Add-In Change to support TLS 1.2 for JRDS. Change to support TLS 1.2 for Office365 SMTP in Jet Scheduler SMTP settings.

Jet Reports 20.6 Build 20.6.20126.5

May 5, 2020

Initial release of Jet Reports 20.6

Jet Reports

Jet Hub

Dynamics 365 Business Central 2020 Release Wave 1 (BC16) Compatible

Jet 20.6 has been verified Against Business Central Release Wave 1, 2020, both On-Premise and Cloud!

Jet Basics

Updated Jet Basics Trial Version

Jet Basics now includes a free trial enabling users to get a taste for some of the more advanced report creation capabilities that were previously only available in Jet Reports. To continue using these capabilities after their trial period ends, users will have the option to upgrade to Jet Reports

Excel Add-In

Fixed issue - Date Table not accessible with Business Central On-Premises Data Source.

Fixed issue - Users in other cultures cannot connect to BC.

Jet Hub

Fixed issue - Culture ID 9 (0x0009) is a neutral culture.

Jet Reports 20.5 Build 20.5.20042.1

February 11, 2020

Initial release of Jet Reports 20.5

Jet Reports

Enhanced query handling for Business Central

Microsoft has implemented new API limits for Business Central customers to ensure that no single client can consume too many resources and become a "noisy neighbor." For Jet Reports users, this change could cause some larger queries to time out and return an error message.

To work with these new API limits, Version 20.5 introduces a query orchestrator to smooth out query requests, verify that results have been returned, and handle any timeouts and retries as necessary.

The query orchestrator can identify longer queries that may time out, and it breaks these up into a series of smaller queries to run individually. It then smartly and seamlessly blends the results into a single dataset for display, so end-users can continue to refresh their reports without interruption.

Jet Reports

Support for Business Central multi-tenant environments

When customers deploy Business Central multi-tenant environments and define their credentials centrally, they can now select which tenant they want to authenticate against when using Jet Reports. This enables customers to:

  • Switch between tenants, so they arer no longer limited to the default tenant in which their central credentials were defined.
  • Switch between production environments, so they are no longer limited to their default environment.

Jet Budgets

Simplified set-up of budget security

Budget administrators can now add groups of users from Active Directory or Azure Active Directory, rather than adding users one at a time. When adding a group, users within that group are given the role of budget user, budget viewer, budget contributor or approver, or budget owner.

Jet Budgets

Streamlined navigation of budget lists

For organizations managing large numbers of budgets, Version 20.5 makes it faster and easier to navigate and search through lists of budgets. By adding pagination, users can select the number of results (budgets) shown per page and then easily navigate between pages. The existing search box, which makes it easy to search for a budget by name, now works in sync with the pagination function.

Jet Budgets

Faster rendering of content in the budget overview page

Performance enhancements in Version 20.5 speed up the rendering of content in the budget overview page.

Jet Hub

Updated branding

With Version 20.5, the look and feel of Jet Hub has been updated to use insightsoftware branding.

Jet Reports 20.4 Build 20.4.19336.1

December 4, 2019

Changes since 20.4.19301.1

Jet Budgets Fixed an issue preventing users from copying custom budgets.

Excel Add-In Fixed an issue where Jet was not recognizing customized permissions from the Tenant when connecting to Business Central.

Fixed issue that was preventing the Excel Add-in Scheduler from working with command-line substitutions.

Fixed issues that prevented settings from being saved in the Jet Scheduler task.

Jet Reports 20.4 Build 20.4.19301.1

October 29, 2019

Initial release of Jet Reports 20.4

Jet Budgets Performance Improvements

The objective of this feature is to improve the user experience when using Jet Budgets by reducing the bottleneck situations that may cause a degradation of performance. The feature encompasses several enhancements and they respond to specific feedback from current users.

Enhance Scheduler Task Editor

This is the conclusion of the work started in release 20.3 to enhance the new Report Scheduler made available with release 20.2. The scheduler is used to schedule and automate the distribution of reports to selected recipients across the organization.

Extend Jet Budget Security and Permissions

This feature increases the options available to assign responsibilities over a give budget or work items of a budget.

Enable Jet Budgets Read Only Users

This release introduce the Budget Viewer. They are users given the ability to access a given budget and report on its numbers without the ability to add or modify anything. The budget viewers can run reports using the GL( JetBudget ) function. These users will also have access to the Overview page of the budget.

Administrators can edit existing users to give them this permission, even after they have been added the budget with a different role

To assign a user as Viewer, there is a new checkbox in the menu listing the users assigned to a budget.

GP Scalability

Improved scalability in GP GL function with a segment or category filter that selected too many accounts could cause SQL Server to create a query plan.

Jet Reports 20.3 Build 20.3.19276.1

October 4, 2019

Changes since 20.3.19268.1

Jet Excel Add-In Fixed issue where Jet Dynamics 365 Business Central (Web Services public cloud) datasources could not connect.

Jet Reports 20.3 Build 20.3.19268.1

October 2, 2019

Changes since 20.3.19246.1

Jet Budgets Fixed issue where Jet Budgets cannot be copied. Fixed issue where Jet Budgets searching doesn’t work. Fixed issue where budget dimensions with many values (1100+) do not display properly in the dropdown for "Split Rows By Dimension" Fixed performance issue when loading the Overview Page in Jet Budgets.

Jet Reports 20.3 Build 20.3.19246.1

September 4, 2019

Changes since 20.3.19227.2

Excel Add-In Fixed issue where evaluating a formula in the Jfx could freeze Excel. Fixed issue where Excel crashed when closing the Jfx in certain cases when using a BC public cloud data source. Fixed issue where the default page size was too large for BC public cloud data sources due to changes by Microsoft. Fixed issue to allow reinstallation of the Jet Service Tier when the authentication type is AAD. Fixed issue to allow users to install different authentication types.

Jet Hub

Fixed issue where some user names were being displayed as blank in the Jet Hub data source permissions view.

Jet Reports 20.3 Build 20.3.19227.2

August 17, 2019

Changes since 20.3.19214.1

Excel Add-In Fixed issue where customers using a Business Central Public Cloud data source may receive a 429 error due to resource throttling imposed by Microsoft. Fixed an issue where named ranges were not being shown in the Scheduler. Fixed an issue where NP(Eval) was causing error in certain languages. Fixed an issue where underscores were not allowed when specifying the JST host name.

Jet Hub

Fixed an issue where a changed password for an AD user was not prompting them to update their password in the Hub.

Jet Reports 20.3 Build 20.3.19214.1

August 6, 2019

Initial release of Jet Reports 20.3

Jet Reports Performance Improvements

In our effort to continue to deliver better performance to our customers we have leveraged additional functionality in Excel to harness asynchronous handling of functions . This has resulted in greatly improved performance , especially for longer-running reports.

Jet Budgets support for non-Dynamics data sources.

Jet Reports 20.3 supports Budgets for custom data sources . This is a great benefit to those customers who are not using Dynamics Business Central, NAV or GP.

"Basic User" Authentication within Jet Hub and the Jet Reports Excel add-in

For those organizations using neither Active Directory nor Azure Active Directory, the Jet Installer, Jet Hub, and Jet Reports all now support the creation and use of "Basic User" Authentication where user accounts can be defined within Jet Hub and used in Jet Reports to connect to the Jet Service Tier.

Updated Jet Scheduler Task List within the Jet Reports Excel add-in

Continuing with efforts to bring all the Jet add-in features in line with a consistent look as well as providing intuitive and easy to use interactions, the interface for the Jet Scheduler Task List has been improved.

Improved Data Source Management within Jet Hub

Jet Reports 20.3 includes more Data Source types and an updated user interface for Assigning User Permissions to data sources from directly within Jet Hub .

Jet Reports 2019 R2 Build 20.2.19183.2

July 9, 2019

Changes since 20.2.19154.1

Jet Hub

Added missing translations to some areas of the Jet Hub. Fixed an issue where scrolling for report options in the Hub did not work as expected.

Excel Add-In Fixed issue when closing periods were used in the start or end periods of a GL function.

Jet Budgets Fixed issue where column sizing was not correct for the budget overview.

Jet Installer Fixed an issue where the IIS AppPool would not stop on install/uninstall.

Jet Reports 2019 R2 Build 20.2.19154.1

June 10, 2019

Changes since 20.1.19133.1

Jet Hub Added ability to manage all permissions for all data sources Added ability to create an on-premises Business Central data source using web services. Added ability to create an on-premises Business Central data source using direct SQL. Added ability to support and run reports with slicers in Pivot Tables. Added ability to provide Office 365 (O365) user mapping in the Jet Hub.

Fixed an issue were auto fill periodically overwrote data source credentials Fixed an issue where navigating to “\login” produced a blank page. Fixed an issue where selecting all reports and then selecting an element out side of the list would clear the selection. Fixed an issue where not all report runs could be scrolled to in the run history tab. Fixed an issue where a user would be routed to the login screen after opting to ‘stay logged in’ after inactivity. Fixed an issue where the database field would be empty for Business Central direct sql connection types. Fixed an issue where some check boxes were unavailable in the permissions tab of the Jet Hub. Fixed an issue where hidden rows/columns were not hidden with reports containing a pivot table. Fixed an issue where a pivot table run in the Jet Hub would corrupt the work book.

Excel Add-In Fixed an issue where the Jet Browser could not remove all ‘Favorites’ unless you manually deleted the ‘Favorites’ xml. Fixed an issue where a Jet Service Tier connection error was generated if a user did not have 'create' data source permissions. Fixed an issue where favorites were not saved in the Browser if using a C/Front data source. Fixed an issue where the table builder produced inconsistent results. Fixed an issue where the Report wizard did not specify the company if the default data source was not used. Fixed an issue where users using the Report wizard could not select a filtered item in a table drop down. Fixed an issue where occasionally saving favorites in the report wizard closed excel. Fixed an issue where the Browser would not save favorites when a GP data source was used.

Jet Budgets Added ability to enter a custom date range when creating a budget.

Jet Dashboard Builder Fixed an issue where the Jet Activation window opened each time the Jet Dashboard Builder was opened.

Jet Installer Fixed an issue where some SSL configurations did not update when modifying the Jet installation.

Jet Reports 2019 R2 Build 20.1.19133.1

May 20, 2019

Changes since 20.0.19116.1

Jet Hub Added ability to discard changes when editing a data source within the Jet Hub. Fixed an issue where a report with Pivot Tables would take longer to run in the Jet Hub. Fixed an issue where a double sign-in would occur if your initial setting timed out. Fixed an issue where a report containing a pivot table would throw an exception when run in the Jet Hub. Fixed an issue where the last drop-down in the data sources page would open out of view. Fixed an issue where 'New Data Source' was displayed when only editing a data source. Fixed an issue where reports with Pivot tables would become corrupted when ran through the Jet Hub. Fixed an issue where no warning was displayed when SMTP was not setup on a scheduled task. Fixed an issue where responding on a sent invite would generate an uninformative error. Fixed an issue where using a C/Front-based data source for budget creation would generate an error. Fixed an issue where selecting a data source type during creation did not enable the connection method drop down list. Fixed an issue where a “no records“ error was shown briefly when loading data. Fixed an issue where a duplicate “pending changes” error was displayed when navigating tabs.

Excel Add-In Added new icons for the JetMessage dialog boxes. Fixed an issue where Business Central data sources were still selectable when disabled in the combo box list. Fixed an issue where importing a favorites list would produce an error. Fixed an issue where unlicensed data types were not grayed out. Fixed an issue where pressing 'tab' had inconsistent performance when using the Browser with a Dynamics NAV data source. Fixed an issue with the screen display of the Snippets icon. Fixed an issue where cancelling the OAuth page would generate an exception. Fixed an issue where a pivot table in cell ‘A1’ would generate an error. Fixed an issue where no reference to Office 365 account error would be shown in the settings after login. Fixed an issue where selecting ‘New Worksheet’ would insert a table in cell ‘A1’. Fixed an issue where an error message was shown when opening the Jet License Activation window. Fixed an issue where a generic error was displayed when a user chose windows Auth in an Azure Active Directory set up. Fixed an issue where the Snippets window did not have the updated styling. Fixed an issue where toggling the master favorites automatically deselects all fields. Fixed an issue where scrolling up the report wizard list would deselect previously selected fields. Fixed an issue where adding a new folder/snippet in the Snippets window would generate an exception. Fixed an issue where selected text in the Fast Financials window would turn all text white. Fixed an issue where Report Wizard filter selection would generate an exception.

Jet Budgets Fixed an issue where some fields in work Item creation would go past the display bounds of the browser. Fixed an issue where work items using online entry would not save budget numbers. Fixed an issue where users could not scroll horizontally on budget overview.

Jet Dashboard Builder Fixed an issue where the dashboard builder provided an uninformative error when the license failed to validate. Fixed an issue where the application settings window would appear every time the Dashboard Builder was launched.

Jet Installer Added windows icons in installer to match our new brand. Fixed an issue where JetReports.exe was not removed when Jet Reports is uninstalled Fixed an issue where the Jet Service Tier was not reading the activation code from the registry. Fixed an issue where multiple errors were generated if the Jet Services database is being used by another process upon installation. Fixed an issue where Jet Service Tier binding certificate would log to a temp file. Fixed an issue where a database user could be added on install even if the user already exists. Fixed an issue where the SSL certificate would not persist on upgrade.

Export to Word Added ability to generate a Word Document when still in design mode. Fixed an issue where a red box was visible around a named range after the issue was already resolved. Fixed an issue where the Configure Work Export window initialized off screen on some high resolution devices. Fixed an issue where errors would not clear after they have been resolved.

Jet Reports 2019 R2 Build 20.0.19116.1

April 29, 2019

Initial release of Jet Reports 2019 R2

Jet Browser Update

Continuing with efforts to bring all the Jet add-in features in line with a consistent look as well as providing intuitive and easy to use interactions, the interface for the Jet Browser tool has been updated.

Updated Pivot Tables for OLAP Cubes

Jet 2019 R2 includes an updated user interface for creating Pivot Tables from OLAP cubes .  This includes is a more consistent visual design and better navigation to walk you through creating and inserting your Pivot Table

OLAP Cubes in Azure Analysis Services

Another area updated in Jet 2019 R2 is added support for OLAP cubes residing in Azure Analysis Services .

Business Central (on premises)

With Jet 2019 R2, we continue to extend functionality to increasingly support more features and deployment options for Dynamics 365 Business Central.  We've now included support for on-premises Business Central installations.

Office 365 Authentication

Jet 2019 R2 provides the ability to sign in to Jet Hub, as well as the Excel add-in, using Office 365 (or Azure Active Directory ) account credentials.

MS Word Integration

Jet is excited to include integration with Microsoft Word in Jet 2019 R2.  This new feature will give you a faster and easier way to generate Microsoft Word documents using Jet data.  A great time-saver for producing executive reports, financial statements, cover sheets, invoices, and billing statements.  No more cutting and pasting errors!

Jet Hub Redesign

Jet 2019 R2 includes several requested improvements to the user interface of Jet Hub , which incorporate an intuitive design and improved navigation to make managing reports and folders more efficient.
User Administration in Jet Hub In our effort to reduce the number of applications required to use and support Jet Reports, Jet 2019 R2 adds the ability to create and manage users and groups directly in Jet Hub.
Data Source Administration in Jet Hub In addition to being able to administer user and groups within Jet Hub, Jet 2019 R2 includes the ability to create and manage data sources in Jet Hub.
Jet Budgets Usability Improvements

Based on feedback, several interface and functionality improvements have been made to help Jet Budgets users get the most from their Budget process.

Copying a budget now includes e-mail reminders and the ability to add new dimensions.  Saving and submitting numbers for approval can now be done from Excel.  Formulas can now be saved when using Excel Online for data entry. Configuring reminders is now more intuitive, and zeros and blanks are no longer preserved in budget entries.

Jet Reports 2019 Build 19.8.19072.1

March 18, 2019

Changes since 19.7.19044.1

Excel Add-In Fixed an issue where in some cases batch execution optimization would throw an error.

Jet Budgets Fixed an issue where uploading a budget had slow performance. Fixed an issue where G/L accounts would fail to load when using excessive totaling accounts. Fixed an issue where the account structure for Spanish databases would have incorrect indentation. Fixed an issue where a budget that is saved without numbers did not save the entire form.

Jet Reports 2019 Build 19.7.19044.1

February 25, 2019

Changes since 19.6.19018.1

Jet Hub Fixed an issue where a local system user could not create a scheduled task. Fixed an issue where a user's email was being updated when a group with the same ID was updated.

Excel Add-In Fixed an issue where Lookups with nested arrays occasionally failed to load data. Fixed an issue where a custom FlowField in a NAV 2018 extension would fail to work. Fixed an issue in the Browser where un-favoriting a field would also un-favorite a table. Fixed an issue in the Browser where un-favoriting a field would deselect non-favorited fields from other tables. Fixed an issue in the Browser where favoriting a field and proceeding to select a different field would produce invalid information. Fixed an issue where loading a field from an extension with a duplicate key would produce an error when querying tables and fields. Fixed an issue in the Browser where having Favorites enabled would still show all of the fields. Fixed an issue where a user could not highlight the license tab within the application settings.

Jet Reports Financials Fixed an issue where Jet Reports Financials would not prompt for a new sign-in after a user changed their password on the Business Central tenant.

Jet Budgets Fixed an issue where uploading a Budget work item would not translate the 'save message' content.

Jet Reports 2019 Build 19.6.19018.1

February 4, 2019

Changes since 19.5.19011.1

Jet Budgets

Fixed an issue where budget numbers were occasionally not saved to the server when using an Excel entry. Fixed an issue where changes made to an approver to a work item did not appear in the overview after approval.

Jet Hub Fixed an issue where canceling a bulk of report uploads would periodically not work properly. Fixed an issue where changing a scheduled task owner from a domain user to a local user profile would throw an error.

Background Reporting Fixed an issue where report options within a report would generate an exception when run contextually.

Excel Add-In The Jet Browser now shows all fields in a favorite table when no fields from that table have been favorited. Fixed an issue where the scheduler window would re-size on high resolution devices. Fixed an issue where the Report Wizard would add a data source filter for the default data source. Fixed an issue where cell references that are manually entered are created as relative ranges instead of absolute ranges. Fixed an issue where excel would occasionally crash when batch function execution was enabled while running reports. Fixed an issue where table builder formulas were not working as expected. Fixed an issue where a web service data source would generate an error with the latest Jet Business Objects in NAV 2017/2018.

Jet Reports 2019 Build 19.5.19011.1

January 14, 2019

Changes since 19.4.18353.1

Jet Budgets

Fixed an issue in Jet Budgets where a budget owner would not receive an email notification when renaming a work item. Fixed an issue in Jet Budgets where saving values to a budget that produces an error would sometimes lock Excel. Fixed an issue in reminders where dismissing an error message would dismiss all other error messages. Fixed an issue where dimensions with large numbers of values could not be added as a "Split by Dimension". Fixed an issue where budget dimensions with codes beginning with numbers or special characters could not be used in "Split by Dimension"..

Jet Hub Fixed an issue where workbooks with multiple sheets would sometimes fail to replicate properly. Fixed an issue where attempting to add a local domain group would sometimes show an unrelated error message. Fixed an issue where clicking "Continue" on the session timeout dialog could sometimes till result in the user being logged out. Fixed an issue where wildcard characters were not supported in the Search function. Fixed an issue where running a report containing the =VLookup Excel function would cause #REF! to appear in cells. Fixed an issue where uploading reports that contain #REF! would cause an error to occur. Fixed an issue where TinyInt fields from Data Warehouse data sources would produce errors.

Background Reporting Fixed an issue where new workbooks would sometimes switch into report mode after running in the background and then opening the Jfx.

Excel Add-In Fixed an issue where data could not be retrieved from a server where TLS 1.2 was enabled. Fixed an issue where the group page of the Report Wizard did not resize correctly. Fixed an issue where formulas added to the Table Builder that contain Jet functions were not being converted properly to values. Fixed an issue where pivot tables were sometimes not updating correctly unless they were manually refreshed. Fixed an issue where NL(Sheets) would sometimes exhibit poor performance, causing unexpected behavior within Excel. Fixed an issue where the licensing window contained gray text. Fixed an issue where minimizing the "insert Named Range" window from the Jfx would sometimes force the user to close Excel in order to use it. Fixed an issue in the Report Wizard where using "Select All" would remain active when switching tables within the same data source. Fixed an issue where stored user data would sometimes evaluate incorrectly. Fixed an issue in the Report Wizard where selecting the Total Page after changing the table would leave the Report Wizard in an unusable state. Fixed an issue where cancelling some running reports would activate a random worksheet in the workbook. Fixed an issue where a scheduled report would fail if it contained a Pivot Table that is set to "Refresh data when opening the file". Fixed an issue where some reports containing #REF! would never complete. Fixed an issue where Business Central data sources would sometimes return bad data when Batch Function Optimization is enabled. Fixed an issue where some reports would return #VALUE! cells when run against NAV SQL data sources in certain circumstances Fixed an issue where the installer would sometimes exit with a SQL error when configuring the Jet Services database.

Jet Dashboard Builder Fixed an issue where Dutch translations were incorrect for relative dates. Fixed an issue with some Japanese translations in some areas of the Dashboard Builder.

Jet Reports 2019 Build 19.4.18353.1

January 2, 2019

Changes since 19.3.18339.1

Jet Hub Fixed an issue where uploading a large report to Jet Hub would constantly make the page to refresh. Fixed an issue where the search function in Jet Hub would not return the correct values. Fixed an issue where SMTP emails could not be sent under certain SSL configurations.

Background Reporting Fixed an issue where the run-times were cut off in the background reporting tray application. Fixed an issue where an error window was opened behind the report options window blocking user interaction. Fixed an issue where the 'View Error' text would be cut-off if an error is caught.

Excel Add-In Fixed an issue where Jet Functions wrapped in Excel functions would not convert to values. Fixed an issue where running reports with the batch execution turned off would cause some cells to #VALUE!. Fixed an issue where inserting a second named range in the Jfx window would generate a null value exception. Fixed an issue where opening and closing Fast Financials quickly would throw an error message. Fixed an issue where selecting the 'Fields' tab in the Report Wizard would not change the contents of the page. Fixed an issue where selecting an invalid data source would allow the selection of a previous data source field. Fixed an issue where canceling a report as a 'Viewer' would move the report into a partial 'Design' mode. Fixed an issue where the Report Wizard would create an invalid report for tables that do not contain a primary key. Fixed an issue where the XLL add-in would not load when the System time format is set to English(Switzerland). Fixed an issue where the GL function with an 'Exclude Close = True' would not work with UK Dynamics NAV databases. Fixed an issue where loading an extension table would cause a duplicate key error. Fixed an issue where the Report Wizard would not work with Cube data sources. Fixed an issue where NL(Table) functions would not expand the results on alternative runs when run in 'Report Mode'. Fixed an issue where the first column returned from an NL(Table) would be named ' 0'.

Jet Administration Console Fixed an issue where an unnecessary Tool Tip was in the header.

Jet Reports 2019 Build 19.3.18339.1

December 6, 2018

Changes since 19.2.18311.1

Jet Installer Fixed an issue where upgrading from Jet Reports Financials to Jet Reports will not select the correct code units.

Jet Budgets Fixed an issue where calendar selected will default to the initially selected date. Fixed an issue where an error is displayed when deleting a Budget reminder. Fixed an issue where submitting a work item error will show in the incorrect area initially. Fixed an issue where large budget item numbers are totaling with the incorrect format. Fixed an issue where a budget Owner will receive an email notification when un-submitting a self assigned item.

Jet Hub Fixed an issue where the invalid credential error message is not displayed for some contents in the scheduler. Fixed an issue where there is no option to re-authenticate a scheduled task. Fixed an issue where data source settings in Jet Hub are not interactive. Fixed an issue where a user cannot create new scheduled tasks. Fixed an issue where the Norwegian language was not displayed as a Jet Hub language option.

Background Reporting Fixed an issue where background reporting does not work for consecutive users on a terminal server.

Excel Add-In Fixed an issue where opening a CSV file will produce an error and disable the Jet AddIn while an excel session is open. Fixed an issue where field selection is disabled after opening the Report Wizard with an invalid data source. Fixed an issue where invalid #Ref! is returned when moving to design mode after running a report that contains a NL(Table) and Fast financials data. Fixed an issue where functions with date filters will produce errors for reports using Business Central data sources. Fixed an issue where canceling a report run during row expansion will bring back bad data. Fixed an issue where the favorites icon is not visible in the browser. Fixed an issue where successfully changing between cube data sources will display an error. Fixed an issue where Report Wizard does not sort correctly. Fixed an issue where the Options and progress window do not appear for a some Excel 2016 users. Fixed an issue where the GL function in Hungarian returns #Name!. Fixed an issue where the Drilldown against a web service data source into a Jet Data Grid will produce an error upon scrolling. Fixed an issue where the JFX button will force close Excel after closing out of the data source settings window. Fixed an issue where Nav SQL data source cannot connect to Nav 2018

Dashboard Builder Fixed an issue where an error is thrown when switching between tabs with a slicer that returns no data. Fixed an issue where slicer data will be cleared when every item is selected.

Jet Reports 2019 Build 19.2.18311.1

November 12, 2018

Changes since 19.1.18296.2

Jet Installer Fixed an issue where Active Directory queries can throw exceptions for users in certain domain configurations. Fixed an issue where installation will fail on a non-domain connected machine.

Jet Service Tier Fixed an issue where the initial Jet Service Tier authentication is slow.

Jet Budgets Fixed an issue where an incorrect 'Last Modified Date' may be displayed in the Budget drill down. Fixed an issue where an error message is displayed after closing an assignment entry form during the send assignment process. Fixed an issue where the Budget help link directs the user to the generic Jet Hub support page. Fixed an issue where some fields will not be displayed correctly on budget/Work Item screens for users with the Microsoft Edge web browser. Fixed an issue where clicking on 'Save in Budget' will move the current window behind Excel and to the foreground. Fixed an issue where the Work Item count in the details panel for Sections does not update. Fixed an issue where the 'Last Submission' field in the work item details panel is always in UTC time. Fixed an issue where a budget owner is not able to open Budgets in Excel that are pending approval. Fixed an issue where marking a Jet Budget excel file as owner will make the contributor receive a File not found error. Fixed an issue where a long budget description will throw an error. Fixed an issue where date formats are showing incorrectly when previewing a Budget Work Item. Fixed an issue where no data validation exists when using Copy-Paste in an online work item data entry form.

Jet Hub Fixed an issue where an error message is not shown in Jet Hub if an unsupported Excel function is used. Fixed an issue where opening a large report in OneDrive For Business will fail. Fixed an issue where no error would display if a large report fails to upload. Fixed an issue where not enough information was shared when running a report that uses an incorrect Excel function. Fixed an issue where an error message does not inform the user that a non-supported Excel function was used. Fixed an issue where a report that uploaded with an error can then be run by the user. Fixed an issue where a Report will produce #N/A because a string is not being interpreted as a date properly. Fixed an issue where a user will be directed back to the login page when clicking on the 'Report List' button after being logged out for inactivity. Fixed an issue where the Excel function '=LOOKUP()' will produce #N/A on the report if run through Jet Hub. Fixed an issue in Microsoft Edge where some fields will not be displayed correctly on Budget/Work Item screens. Fixed an issue where the Date picker is missing the current date selection. Fixed an issue where clicking on 'Back to Reports List' navigates you to the scheduled task details and not the folder you were previously at. Fixed an issue where the fill color of a cell is not persisting in the report after being run in Jet Hub. Fixed an issue where a cell will return #N/A when a excel '=MATCH()' function is used. Fixed an issue where the upload icon in the header is overlapping the change view buttons.

Background Reporting Fixed an issue where background reporting with a Dynamics Nav data source will ignore 'Company=' filters.

Excel Add-In Fixed an issue where 'What' drop down in the Jfx window displayed the incorrect GL Balance description. Fixed an issue where text gets distorted when dragging an item from the Report Wizard. Fixed an issue where the 'X' is not displayed in the Report Wizard drop down window. Fixed an issue where a field cannot be unchecked after a user performs 'Select-All' in the report wizard. Fixed an issue where an NL function will not calculate if the CalcFormula is too long. Fixed an issue where the Jfx window is taking much longer to open than previous versions. Fixed an issue where the Format Options are not reset after a user changes the Data Source, Company or Table. Fixed an issue where field selection using the keyboard will not indicate if you have selected all the items in the Report Wizard field list. Fixed an issue where switching the data source upon launch of the Report Wizard will disable the ability to select fields. Fixed an issue where the GL(JetBudget) function runs very slow. Fixed an issue where a report with +Values, a Jet Function, and column and sheet replication will throw an error after running. Fixed an issue where Jet is unable to evaluate functions in certain languages. Fixed an issue where closing and opening Fast Financials will throw an error. Fixed an issue where the "What" drop down in the Jfx window displays the incorrect GL Balance description.

Dashboard Builder Fixed an issue where changing filters will grey out all visual 'OK' buttons. Fixed an issue where the Dark Theme contains white text and a white background in the data grid.

Jet Reports 2019 Build 19.1.18296.2

October 26, 2018

Changes since 19.1.18289.1

Jet Hub Fixed an issue where the button to install the Jet Reports Excel add-in would not be placed in the correct location.

Excel add-in Fixed an issue where viewers were unable to use the drilldown feature.

October 22, 2018

Changes since 19.0.18268.1

Jet Administration Console Fixed an issue where an unwanted underscore is seen when creating a personal data source in the Jet Administration Console. Fixed an issue where multiple users are allowed to be selected as data source owners.

Jet Reports Installer Fixed an issue where Jet Reports Financials could be installed on top of Jet Reports, this prevented users from activating Jet Reports. Fixed an issue where Jet Reports does not activate from the installer even when given the activation code.

Jet Reports Financials Fixed an issue where the default Nav data source web service code unit name is invalid. Fixed an issue where a data source is not provisioned after a successful O365 sign in.

Jet Hub Fixed and issue where changing the name of a Cube will cause the Dashboard to disappear. Fixed and issue where clicking 'Report List' will take you back to the root folder as opposed to your previous folder. Fixed an issue where dates were changed to a 'general' format in the Report options window. Fixed an issue where an incorrect error message is displayed when uploading a report while having no data sources defined. Fixed an issue where an error message is thrown when an unexpected char is used when adding a User/Group in Jet Hub. Fixed an issue where our autocomplete feature is inaccurate when adding a User/Group in Jet Hub. Fixed an issue where clicking 'Report List' in the details pane does not take you back to your previous page. Fixed an issue where some languages were missing translations on the permissions page. Fixed an issue where there is an incorrect translation for "New Work Item". Fixed an issue where an empty error message is shown when attempting to sign into Jet Hub with a user that is assigned to a Budget but not added in the Jet Administration Console. Fixed an issue where the Report sharing 'Help' window displays an unwanted interactive check box. Fixed an issue where the 'OK' button in the report sharing window is not activate if the "Share with Everyone" icon is selected but no users are added in the Jet Administration Console. Fixed an issue where the user can see a highlight of a lookup button in the Report Option window even if no lookup was defined. Fixed an issue where large user names are not displayed in the Add Users/Groups window. Fixed an issue where the sort functionality on the security column in the administration page sorts users in the opposite order. Fixed an issue where adding Users/Groups in Jet Hub does not populate the users information in the staging window. Fixed an issue where no warning is issued when attempting to add a duplicate user. Fixed an issue where users deleted from Jet Hub are not removed from their assigned Jet Budget or shared Reports. Fixed an issue where data source names were cut off on the data source page. Fixed an issue where not all text is translated on the login page. Fixed an issue where a timeout error was displayed when an invalid username is used to login. Fixed an issue where NL(Lookup) functions against cube data sources do not work if using a language caption for the Cube name. Fixed an issue where an empty contextual menu will partially hide the run history page. Fixed an issue where no loading spinner is visible when navigating from the information window to run history and report details. Fixed an issue where a user cannot rename reports or folders within the tile view. Fixed an issue where the loading spinner is cut off on the data sources page. Fixed an issue where authorizing a Business Central data source by clicking the GoLink does not propagate a new window. Fixed an issue where User Groups without a full name are displayed as an empty string when adding a new group in Jet Hub. Fixed an issue where a user can double click 'Add Comment' and it will add a duplicate of the same comment. Fixed an issue where multiple confirmation messages are sent when only one invitation was sent. Fixed an issue where Jet Hub welcome email displays the username and not the user's full name. Fixed an issue where a report option value is being overlapped by the report option title field. Fixed an issue where searching for local users in the Admin section of Jet Hub does not work as suspected. Fixed an issue where no every user who is invited to Jet Hub will receive the invitation. Fixed an issue where logging in to Jet Hub with a user that is not in the Jet Services database will throw an ambiguous message. Fixed an issue where the loading spinner is displayed in the background while adding users. Fixed an issue where running a report that has an incorrect conditional formatting rule will corrupt the workbook.

Jet Budgets Fixed an issue where the Budget spreadsheet preview allows text to be entered when entering dimensions. Fixed an issue where the Calendar's user notifications are not in the correct layout. Fixed an issue where the Jet Budget Grid paging is not reset when navigating between Users, Work Items and Templates. Fixed an issue where searching for users within a budget works differently for Admin and non-admin users. Fixed an issue where the template name is cut off in the drop down when creating a new Work Item. Fixed an issue where users that were deleted from the Jet Administration Console can still be added as budget users. Fixed an issue where the Work Items overview window had improper column padding. Fixed an issue where an error message is displayed on the dialog page when creating a budget with no data sources defined. Fixed an issue where a budgeting contributor should be able to submit a budget from the preview pane. Fixed an issue where the 'Save' and 'Resend' buttons are active on a Work Item when no changes were made. Fixed an issue where a deadline is filled out for a self assigned Budget. Fixed an issue where a Budget approver is not notified when he is removed an approver. Fixed an issue where the old product name is displayed when sending numbers from excel to the budget. Fixed an issue where the Jet Budget will show a successful Budget upload after a Budget Work Item upload was cancelled. Fixed an issue where renaming a Work Item will not be reflected in the downloaded file. Fixed an issue where deleting a user from a Jet Budget will not notify the user. Fixed an issue where a notification should be displayed when attempting to copy a Budget without having access to that Budget's data source. Fixed an issue where budget allocation should also show for edited work items in excel. Fixed an issue where if a user is removed from a Budget that is in the state of pending approval the Budget will remain in that state. Fixed an issue where an error is thrown when exceeding the Budget instructions character limit. Fixed an issue where the Budget owner shouldn't be allowed to send unassigned work items. Fixed an issue where Budget submission comments are not limited in length. Fixed an issue where Budget column names differ from column selection menu names. Fixed an issue where a Budget owner will receive an email of their own 'Approval' or 'Un-Approval'. Fixed an issue where a new Budget owner with no access to a data source no dimensions or accounts will display when creating a new work item. Fixed an issue where the 'Days' text box allows special characters. Fixed an issue where a Budget email template should not update changes made when its first sent out. Fixed an issue where there were inconsistencies in a users names included in the Budget emails. Fixed an issue where no comment is documented if a Budget contributor is also the approver. Fixed an issue where changing Budget ownership will throw an error if smtp is not setup. Fixed an issue where no tool tip is displayed on the Budget overview page. Fixed an issue where a work item does not get approved when the approver clicks 'Approve' after making changes. Fixed an issue where a Budget reminder email is labeled as from the Budget owner and not the contributor who made the changes. Fixed an issue where the user cannot select a new Budget owner in changing ownership. Fixed an issue where a Budget excel file formatting will be offset when assigned to a user with no Budget allocation. Fixed an issue where a Budget owner can send a work item without assigning a contributor and approver. Fixed an issue where Budget reminders are not being sent if the budget owner's email is not known. Fixed an issue where double clicking a dimension when creating a work item will add it twice. Fixed an issue where approving a Budget as a contributor from the online entry window will not move the status to 'Approved'. Fixed an issue where the 'Save and Submit' button does not appear after creating a new Work Item. Fixed an issue where clicking 'Save and Submit' will not submit any unsaved changes.

Excel Add-In Fixed an issue where old values persisted in the JFX after editing a nested function. Fixed an issue where an exception is thrown when a cell formula exceeds what excel allows to be in a formula property. Fixed an issue where the 'Send to Budget' icon is not the correct color of Grey. Fixed an issue where the excel window will lose focus after "Sending to Budget". Fixed an issue where data source and company drop downs in the report wizard are still enabled when only one data source exists. Fixed an issue where a 'Favorited' item is not removed from the list. Fixed an issue where in the 'Review and Finish' pane of the Report Wizard lists are displayed concatenated. Fixed an issue where the 'Select All' feature un-checks itself when navigating between sections. Fixed an issue where changing a nested function deletes your main function. Fixed an issue where the main report wizard window can be minimized. Fixed an issue where Jet was not detecting Nav extension tables correctly for Web Service data sources. Fixed an issue where the table drop down in the report wizard will show a blank placeholder text when changing the data source or company. Fixed an issue where selecting a list item in the report wizard with the key board, the type to search no longer function. Fixed an issue where running a report that was generated through the report wizard returns invalid values. Fixed an issue where running a report with an invalid function will toggle the current workbook to the background. Fixed an issue where an Analytics universal data source will throw an exception when NL(Table) function is run. Fixed an issue where '+Values' is added to new sheets when the other sheets already contain Auto+Hide. Fixed an issue where adding a filter in the report wizard will cause column headers to be misplaced. Fixed an issue where only top-level reports can be selected upon report upload. Fixed an issue where changing the data source in the report wizard the table from the previous data source will remain selected. Fixed an issue where the report wizard creates a broken anchor row for replication when the report is generated. Fixed an issue where selecting too many fields using a GP data source will cause the text to no longer wrap on the finish page. Fixed an issue where providing invalid data source credentials will prevent the browser from functioning on another data source. Fixed an issue where Jet cannot run NL functions with multiple embedded functions. Fixed an issue where no error message is displayed when attempting to submit an invalid budget number. Fixed an issue where running a Fast Financials report with an NL(Table) will throw a null reference error. Fixed an issue where the report wizard will throw an error if a users Jet Data Warehouse data source is not setup correctly. Fixed an issue where the report wizard will show tables from the default data source after changing to a newly create Jet Data Warehouse data source. Fixed an issue where the Browser window will be blank if using a a data source that is incomplete, a message will now be displayed. Fixed an issue where an error is thrown when cancelling a Business Central login request. Fixed an issue where unnecessary worksheet searching was causing a slowed performance. Fixed an issue where non batched Jet functions on worksheets that do not contain an NL(Table) are not converted to values. Fixed an issue where opening a report with a Nav Web Services data source will crash Excel. Fixed an issue where Office 2010 does not display the report progress window or report run times. Fixed an issue where a report throws an exception if run against a Nav Web Service data source. Fixed an issue where if one data source cant connect then the data sources drop down in the browser will be empty. Fixed an issue where '+Values' will cause an empty cell to be converted to 0 on 'Run'. Fixed an issue where loading dimension values in a Cube data source caused a report to show the correct values only after the second run.

GP Update Utility Fixed an issue where running the utility against a database that already has some of the components will produce an error.

Jet Reports 2019 Build 19.0.18268.1

October 1, 2018

Initial release of Jet Reports 2019

Improved Performance with XLL Multi-threaded Add-in

The Jet Excel add-in is now based on the Excel’s XLL format.  This provides several benefits - including a performance boost , with some reports running up to 5 times faster.

new10.png

Business Central Data Source Connection

Dynamics 365 Business Central users can connect Jet Reports directly to their Business Central data base.  Each user can use their Office 365 credentials to make their connection.

new01.png

Simulate Jet Reports Financials within your Jet Reports Excel add-in

For those Business Central customers and partners needing to support both Jet Reports and Jet Reports Financials , a new simulation mode has been added to Jet Reports to allow you to use the full Excel add-in as through it were an installation of Jet Reports Financials.

new03.png

Updated Report Wizard

Continuing with efforts to bring all the Jet add-in features in line with a consistent look as well as providing intuitive and easy to use interactions, the interface for the Report Wizard tool has been updated.

new09.png

Update Notification when a new version of Jet Reports is available

A new notification button has been added to the Jet ribbon to let users know when a new version of the Excel add-in is available.

new04.png

+VALUES automatically added to reports

When running a new Jet report for the first time, in addition to Auto+Hide, +Values will now be added to cell A1.  This has been a popular request in our ideas portal.

new02.png

The Jet Services Database is Backed Up during Upgrade

The Jet Reports installation program now includes the option to backup the existing Jet Service Tier database prior to updating or replacing it as part of the installation process.

new08.png

Jet Hub has received a new look and new features

Jet Hub features a new look (along with a new name).

The new App Switcher allows you to quickly navigate between the applications in Jet Hub.

new05.png

Updates Emails when Adding Users to Jet Hub

When adding new users in Jet Hub, you can now provide an email address for each user.  There is also an option to edit the email address for existing users.  This information is used for sending invites to log into Jet Hub and for notifications in the Jet Budgets application

new06.png

Assign Data Source Permissions to User and Groups within Jet Hub

After defining data sources within the Jet Administration Console, you can now give users and groups permissions to those data sources from the Admin section of Jet Hub

new07.png

Support for Excel's WORKDAY.INTL function

Excel's WORKDAY.INTL function is now supported in the Jet Reports that you run within Jet Hub.

Jet Professional 2018 R2 Build 18.5.18215.2

Aug 6, 2018

Changes since 18.4.18186.3

Excel Add-In Fixed an issue where access database data source does not support sub query evaluation. Fixed an issue where date flow fields with Min and Max calc formulas do not work in NAV SQL or Remote Service Data Sources. Fixed an issue where running a report with batch execution turned on will return #VALUE! throughout the report. Fixed an issue where empty filter field displays the Info-Warning only in English. Fixed an issue where Fast Financials instructions only appeared in English. Fixed an issue where the workbook save warning only appeared in English.

Jet Web Portal Fixed an issue where the default sort of folders was random. Fixed an issue where in some languages, field names are cut off or do not fit on the page. Fixed an issue where an invalid error message is thrown when adding users in the Jet Web Portal.

Jet Professional 2018 R2 Build 18.4.18186.3

July 16, 2018

Changes since 18.3.18165.4

Excel Add-In Fixed an issue where some captions for "OK" buttons in Japanese contained brackets.

Jet Web Portal Fixed an issue where certain large reports would sometimes not upload from the Jet Web Portal. Fixed an issue where reports containing NL(Picture) functions referencing local file paths would return a confusing error message. Fixed messaging displayed when SMTP settings were not configured. Fixed an issue where the dialog used to update a user's email address would not load with the cursor focus set to the email address field. Fixed messaging in the scheduler regarding authenticating a scheduled task. Fixed an issue where adding users with a domain that contains "." would truncate that domain value. Fixed an issue where page styling would become inconsistent after using the report options lookup feature. Fixed an issue where reports uploaded that are too large in size would not cause an error as expected. Fixed an issue where the back button in the report details pane would not correctly return the user to the list of reports. Fixed an issue where pasting text into required fields of "New" dialog windows would not correctly enable the "Create" button. Added missing translations for welcome message. Fixed an issue where choosing to cancel a report lookup option would cause the settings menu to no longer open. Fixed an issue where navigating away from a scheduled task that contains pending changes would sometimes not prompt to save. Fixed an issue where adding an existing report to a scheduled task would sometimes disable the ability to edit the report options.

Dashboard Builder Fixed an issue where text that is unable to fit within the confines of a button was being cut off.

Jet Professional 2018 R2 Build 18.3.18165.4

June 25, 2018

Changes since 18.1.18149.1

Excel Add-In Fixed an issue to provide a more informative error message when an incorrect server is entered within the Jet License Activation window Fixed an issue where dimension value filters were case sensitive within GL(Budget) functions. Fixed an issue when running reports with a Czech language pack in Excel would display an exception error message.

Jet Web Portal Fixed an issue to limit the length of folder names to 256 characters. Fixed an issue where the 'clear filters' button within a dashboard slicer was not labeled. Fixed an issue where grabbing a dashboard slicer tab would drag the whole visual within the Jet Web Portal. Fixed an issue where adding a group to the Jet Web Portal would occasionally invite a user outside of the invited group. Fixed an issue where the Jet Web Portal would not display an error message when an incorrect password was used during the creation of a scheduled task. Fixed an issue to rephrase the error message displayed when a scheduled task attempts to send an email with incorrect email settings or the task credentials are invalid.

Background Reporting Fixed an issue where monitors with higher scaling percentages would move the tray application off of the screen. Fixed an issue where running a report with report options from a device with a high screen resolution forces the tray app off of the visible screen.

Dashboard Builder Fixed an issue where adjusting a range slicer would freeze the dashboard to the newly specified range.

Admin Console Fixed an issue where saving a change within the Jet Administration Console would revert a user's email address back to the email that is associated with that user in the Active Directory.

Jet Professional 2018 R2 Build 18.1.18149.1

June 4, 2018

Changes since 18.1.18137.5

Excel Add-In Fixed an issue where look-ups for dates, segments, and segment values were not correctly showing localized names. Fixed an issue where dates returned from a GL() function would not be formatted correctly. Fixed an issue where using Windows authentication for a NAV SQL direct data source would not behave as expected. Fixed an issue where the report drop-down within the Upload Report window would not scroll correctly through the list of reports.

Jet Web Portal Fixed an issue where using Windows authentication for a NAV SQL direct data source would not behave as expected. Fixed an issue where all dashboards would fail to load when the user did not have permissions to one of the dashboard's supporting cubes. Fixed an issue where data source look-ups in report options would not work as expected after upgrading to a new version of the Jet Web Portal. Fixed an issue where some reports containing custom modules would not upload to the Jet Web Portal. Fixed an issue where uploaded reports containing macros would sometimes become corrupted when run. Fixed an issue where reports run in the Jet Web Portal containing an NL(Sheets) function would result in a corrupted workbook. Fixed an issue where NL(Filter) functions that contain a blank value in the results would sometimes cause an error to occur. Fixed an issue where the "User Name" field would sometimes read as "Usename" upon sign-in. Fixed an issue where the right-click context menu would sometimes not appear as expected after navigating to a folder. Fixed an issue where reports with a longer than usual description would sometimes cause errors to occur and cause the report to become inaccessible. Fixed an issue where lookup dates were not being displayed in the correct format. Fixed an issue where downloading a report with a "." in the file name would remove the Excel extension of "xlsx". Fixed an issue where an empty error was being shown when uploading a report when no data sources have been configured. Fixed an issue where navigating to a non-existent report would not fail with a useful error message. Fixed an issue where users configured via Groups would be unable to upload reports from the Excel add-in. Fixed an issue where reports containing "+Lock" would not be protected as expected. Fixed an issue where report options that are changed before running a report would revert the report options to their original values.

Background Reporting Fixed an issue where dates from cube data sources were not being properly formatted.

Installer Fixed an issue when installing Jet Professional where a Jet Service Tier host configuration that contains a "\" would cause Excel to report an error when launched.

Jet Professional 2018 R2 Build 18.1.18137.5

May 21, 2018

Changes since 18.1.18101.2

Excel Add-In Fixed an issue where sorting in the report options window was not functioning as expected. Fixed an issue where a confusing error message would be displayed when an empty filter was not allowed in a Jet function. Fixed an issue where the Jet Database Caption Editor would fail when connected to the Jet Service Tier. Fixed an issue where the Activate Jet Professional button could be hidden from the ribbon in Jet Express. Fixed an issue where clicking the function drop-down inside the Jfx Window while editing a report option lookup would sometimes cause an error to occur. Fixed an issue with batch function optimization where functions referencing relative named ranges would not be included in the batch. Fixed an issue where Excel 2010 would produce a cryptic error message when auto-debugging #VALUE! cells. Fixed an issue where connecting to Jet Service Tier versions 18.0 or earlier would cause errors to occur when using the Jfx. Fixed an issue where Table Builder templates were available to Jet Express users. Fixed an issue where Fast Financials would not function as expected while using languages that have report option names with illegal named range characters. Fixed an issue where pressing F8 within the Jfx window when no report options exist would cause an error to occur. Fixed several layout issues when using languages with messaging that is longer than English messaging. Fixed an issue with batch function optimization where #VALUE! cells would appear with function tables array. Fixed several usability issues within the Fast Financials window. Fixed an issue where an error would occur when attempting to upload a report from their OneDrive rather than a descriptive message.

Jet Web Portal Fixed an issue where reports and folders would sometimes be unable to be de-selected. Fixed an issue where a report downloaded from the Jet Web Portal could not be uploaded by another user. Fixed an layout issue in the "Create New Folder" window. Fixed a layout issue in the search box where text would sometimes overlay the "X" used to clear the search. Fixed an issue where non-English locales would sometimes display a login error message in English. Fixed an issue where non-English locales would display a session timeout message in English. Fixed an issue where a session timeout would result in the display of an unrelated string error message. Fixed an issue where the report details page was not updating correctly when the report was running. Fixed an issue where an object reference error would be mistakenly displayed after a session time out or log out. Fixed an issue where reports containing the EOMONTH() function was not evaluating correctly within reports run in the Jet Web Portal. Fixed an issue where some reports fun in the Jet Web Portal would end up being corrupted. Fixed an issue where some report option lookup values were not displaying correctly.

Background Reporting Fixed an issue where uninstalling Jet Professional would fail if the background reporting tray application was open. Fixed the messaging when closing a report for background reporting. Fixed an issue where closing the background reporting application would sometimes cause an error to be displayed. Fixed an issue where opening a report in background reporting while a different report is running would sometimes not function as expected. Fixed an issue where the background reporting application could not be exited while reports are running. Fixed an issue where cancelling reports running in the background would sometimes cause the report to remain in read-only mode.

Jet Professional 2018 R2 Build 18.1.18101.2

April 19, 2018

Initial Release of Jet Professional 2018 R2

Run Reports directly from your Windows Desktop

Run your reports without even starting Excel!  Just right-click.  The new task tray app will let you know when your report is ready.

Run Reports in the Background within Excel

No need to wait for your report before you can start using Excel, again.  Run your report in the background and continue working with your other Excel files.

Updated Jet Ribbon and Windows within Excel

The Jet ribbon has been updated and the entire user interface has been refreshed to be more consistent, throughout.

Several items have been rearranged to be easier to find, and other related items have been grouped together for a cleaner experience.

  • All configuration settings have been combined under a single button
  • The run options have also been consolidated. In an effort to better explain what they do, the Refresh and Report buttons have been renamed to Run and Run from Cache , respectively.

Fast Financials Updated

To make it easier to select/deselect your Fast Financials accounts, each account can be toggled on and off with a simple click of the mouse – and you can still use the SHIFT key to quickly select a range of accounts. To make copying or adding replicating functions easier than ever, your Fast Financials Report Option dates are now also placed directly on the report sheet. The GL functions and the variance formulas reference those dates, rather than the named ranges on the Options sheet.

Manage Users and Groups in the Jet Web Portal

Now manage your users and groups directly within the Jet Web Portal. Users and Groups added here can also be seen/managed in the Jet Administration Console and can be assigned the new levels of permissions within the Jet Web Portal, itself. And, non-administrator users can now be given permissions to create, rename, move, and delete folders, as well as to change the owner of an existing report.

Compatible with Dynamics NAV 2018

Our testing with Dynamics NAV 2018 has been completed and Jet Professional 2018 R2 fully supports this exciting update.

When used with NAV Web Services, version 2018 R2 of the Jet Excel add-in requires the latest release (12.6) of the Jet Reports Business Objects .

Jet Professional 2018 Build 18.0.18060.4

March 8, 2018

Changes since 18.0.18039.1

Excel Add-In Fixed an issue where some queries would return an error when run in regions where commas are used as decimal points. Fixed an issue where viewers would sometimes be presented with an error within cell A1. Fixed an issue where worksheets containing more than one NL(Table) function would only create the first table defined.

Jet Web Portal Fixed an issue where certain reports would present an error about circular references when run in the Jet Web Portal. Fixed an issue where nested replicators in certain reports would cause additional data to be returned to the worksheet. Fixed an issue where cell reference values would sometimes be removed after a report is run in the Jet Web Portal. Fixed an issue where reports run in the Jet Web Portal that contain cells with #VALUE! would not allow the user to use the "Check error" button in the Jet Ribbon when the report is opened in Excel. Fixed an issue where reports containing an NP(Eval) function of a named range pointing at '|' separated date ranges would return #VALUE!. Fixed an issue where certain reports run in the Jet Web Portal would cause the workbook to become corrupted. Fixed an issue where NP(Eval) functions of a named range that are nested within an IF statement would not evaluate correctly when run in the Jet Web Portal. Fixed an issue where some reports run in the Jet Web Portal would cause an error from circular references. Fixed an issue where report option formulas would sometimes be overwritten when the report containing them would be run in the Jet Web Portal. Fixed an issue where data validation in a report run in the Jet Web Portal would sometimes not expand correctly. Fixed an issue where some reports uploaded to the Jet Web Portal in Report Mode would sometimes lose data. Fixed an issue where renaming sheets that contain charts would cause the charts to lose references when run in the Jet Web Portal. Fixed an issue where reports containing math calculations using a cell reference would sometimes return #VALUE!. Fixed an issue where certain reports run in the Jet Web Portal would return the error "Object reference not set to an instance of an object". Fixed an issue where report charts would behave differently in some cases when the report is run in the Jet Web Portal. Fixed an issue where some reports run in the Jet Web Portal would return empty cells where a #VALUE! is expected. Fixed an issue where structured references were not supported in the Jet Web Portal. Fixed an issue where reports run in the Jet Web Portal containing NL(Table) formulas referencing an NP(Formula) function within a column would result in a corrupted workbook. Fixed an issue where running certain reports in the Jet Web Portal would sometimes result in workbook comments becoming corrupted. Fixed an issue where reports run in the Jet Web Portal would sometimes not refresh Subtotal amounts automatically. Fixed an issue where reports containing NL(Table) functions run in the Jet Web Portal would sometimes use incorrect number formats.

Jet Professional 2018 Build 18.0.18039.1

February 15, 2018

Changes since 18.0.18018.1

Excel Add-In Fixed an issue where large reports would sometimes exhibit less than desirable behavior, including long open and run times. Fixed an issue where batch function optimization would sometimes incorrectly evaluate functions to #VALUE!. Fixed an issue where Fast Financials would add the incorrect formula when drag-and-dropping accounts after performing a drilldown. Fixed an issue where NL functions referencing || in the Table argument would sometimes return #VALUE!. Fixed an issue where nested replicators would sometimes not expand as expected.

Jet Web Portal Fixed an issue where data validation did not work correctly in some cases. Fixed an issue where certain reports utilizing a GP data source would not upload correctly. Fixed an issue where reports containing "\r\rn" in a formula would not upload correctly. Fixed an issue where uploading a report with an NL(Table) function that contains no value in the Fields argument would cause the workbook file to become corrupted. Fixed an issue where uploading a report with an NL(Table) function with an empty value for the "Headers=" special filter would cause the workbook file to become corrupted. Fixed an issue where the available users for selection in the "Change Owner" window would not be a complete list of all users. Added the error detail to the report detail page if the report failed to upload completely. Fixed an issue where report options would become scrambled when run as a scheduled report. Fixed an issue where reports containing data from multiple companies would sometimes not run correctly in the Web Portal.

Jet Professional 2018 Build 18.0.18018.1

January 25, 2018

Changes since 18.0.17362.4

Excel Add-In Fixed an issue where Office365 authentication was not functioning properly when configured for a NAV data source that supports it. Fixed an issue where reports containing a cell with a very large value would sometimes throw an exception. Fixed an issue where certain report option values would sometimes cause an original function to be removed from the report. Fixed an issue where switching report modes after using certain features of the Jfx could cause Excel 2010 to hang until it was refocused. Fixed an issue where Excel 2010 would sometimes not retain application focus after closing the Jfx. Fixed an issue where refreshing certain reports would take much longer to run than switching from design mode to report mode. Fixed an issue where scheduling reports containing hidden rows or Values Only would sometimes not behave as expected when batch function execution is enabled. Fixed an issue where report option lookups on NAV date fields would only show time values. Fixed an issue where NL(Filter) formulas using a filter value containing <, >, <>, .., etc would not work as expected when run against a NAV Direct SQL data source. Fixed an issue where subsequent runs of a report after its initial run would sometimes not update report option values correctly.

Jet Web Portal Fixed an issue where a report downloaded from the Web Portal would sometimes require a workbook repair. Fixed an issue where conditional formatting rules would sometimes be lost after downloading the results of a report run from the Jet Web Portal. Fixed an issue where some Jet functions' "what" argument could replace the "what" argument of other Jet functions in the report. Fixed an issue where some reports utilizing a GP data source would sometimes fail to upload to the Jet Web Portal. Fixed an issue where reports localized in German that contain NP(Eval) formulas would sometimes fail to upload to the Jet Web Portal. Fixed an issue where reports in an error state would sometimes be inadvertently removed from the Jet Web Portal under certain conditions. Fixed an issue where clicking "Next" or "Prev" to navigate between pages of items would sometimes display the wrong items. Fixed an issue where reports with Jet functions that contain embedded functions would sometimes fail to upload to the Jet Web Portal if the embedded function uses a semi-colon list separator.

Jet Professional 2018 Build 18.0.17362.4

January 4, 2018

Changes since 18.0.17355.0

Excel Add-In Fixed an issue where lists of tables in the Jfx and Table Builder would sometimes not be sorted correctly. Fixed an issue where creating a report option lookup using the Jfx would produce an error when pressing ESC. Fixed an issue where certain reports that ran correctly in the previous version of Jet Professional failed to run successfully in the latest version. Fixed an issue where drilling down from within the Jfx window in any non-English locale would not work as expected.

Jet Web Portal Fixed an issue where named ranges that contain any formulas could not be used as arguments to Jet functions. Fixed an issue where Jet replicator functions that are nested in Excel functions would require the drilldown button to be clicked twice. Fixed an issue where reports would fail to publish when external links did not actually exist. Fixed an issue where reports containing an NL(Picture) function would produce different results in the Web Portal than in the Excel Add-In. Fixed an issue where some reports with nested replicators in a region larger than its parent's region would not correctly produce an error. Fixed an issue where conditional formatting would sometimes not work correctly in reports run in the Web Portal. Fixed an issue where NL(Filter) functions using "Filters=" did not work correctly in the Web Portal. Fixed an issue where report options containing a date with "Long date" formatting date would sometimes have its formatting removed when running the report in the Web Portal. Fixed an issue where some reports containing || filters would fail to publish or upload to the Web Portal. Fixed an issue where some reports containing references to an Excel EOMONTH() function would fail to publish or upload to the Web Portal. Fixed an issue where reports containing multi-company GL() functions against a GP data source would not run successfully in the Web Portal. Fixed an issue where NL(Lookup) functions nested within Excel functions were not handled correctly in the Web Portal. Fixed an issue where reports run in the Web Portal would sometimes produce cells containing #VALUE! instead of being empty as expected. Fixed an issue where conditional hide did not work as expected in the Web Portal. Fixed an issue where some reports would become corrupted after uploading or publishing them to the Web Portal. Fixed an issue where reports containing DAYS functions in a language other than English would produce #VALUE! when running the report in the Web Portal. Fixed an issue where reports containing NL(Sheets) functions would not produce the expected results when run in the Web Portal. Fixed an issue where reports containing multiple NL(Sheets) functions would cause an error when uploading or publishing to the Web Portal. Fixed an issue where some reports would fail to upload or publish to the Web Portal. Fixed an issue where NL(Filter) functions nested in other functions would not work as expected in the Web Portal. Fixed an issue where some reports downloaded from the Web Portal would leave Excel unresponsive when switching to Design mode using the Excel Add-In.

Jet Professional 2018 Build 18.0.17355.0 December 27, 2017

Changes since 18.0.17349.0

Excel Add-In Fixed an issue where batch optimized functions that depend on report options would sometimes return wrong values.

Jet Professional 2018 Build 18.0.17349.0 December 19, 2017

Changes since 18.0.17342.2

Excel Add-In Fixed an issue where reports would sometimes fail to run on non-English systems. Fixed an issue when performing a drilldown within the Jfx using a NAV Web Services data source would sometimes only return the first row. Fixed an issue where dragging and dropping report option lookups for Universal and Warehouse data sources sometimes failed to function correctly.

Jet Web Portal Fixed an issue where some reports containing cross-sheet range references failed to upload to the Web Portal.

Jet Professional 2018 Build 18.0.17342.2 December 14, 2017

Excel Add-In The cells contained within the report options window from the Jfx are now selectable. Fixed an issue where dragging fields from the Browser would sometimes insert the wrong function into the report. Fixed an issue where navigating away from the advanced page of a new universal data source settings before configuring the connection would sometimes produce an exception. Fixed an issue where batch function optimization would cause cells to produce #VALUE! as the result. Fixed an issue where the Browser and Fast Financial windows would not appear above the Excel workbook when more than one workbook was open. The report options lookup window can now be resized. Fixed an issue where using the Jfx from within the report options window would sometimes send the Excel window to the background when the report options window was closed. Usability of the report options window has been improved - Tabbing moves you through each option value allowing you to edit the values. - Single-clicking a cell edits the value. - Clicking or tabbing to edit a cell selects the entire value. - ENTER runs the report. Tooltips appear when hovering either over the title or the value. Fixed an issue where the options tab within the scheduling window would sometimes disappear when selecting a new tab. Fixed an issue within Fast Financials where dragging and dropping large amounts of data, then quickly closing the window would sometimes cause Excel to terminate unexpectedly. Fixed an issue where batch function optimization would sometimes fail when an NP(Eval) function referenced a named range which contains a Jet function. Fixed an issue where Excel 2010 users would not see updated icons. Fixed an issue where batch function optimization would fail for a report containing an NL(Filter) function as a filter. Fixed an issue where the Fast Financials tool would sometimes cause Excel to terminate or become unresponsive when selecting all accounts, all headers, and all columns. Fixed an issue where large reports would sometimes cause Excel to run out of memory. Fixed an issue where cancelling a running report with function optimization enabled would sometimes damage the report. Fixed an issue where an NL(Sheets) function would sometimes produce incorrect sheet names.

Jet Web Portal Fixed an issue where a report containing an NL(Picture) function would run significantly slower as compared to running within the Excel Add-In. The icon for a report in a cancelled state now differs from the icon for a report in an error state. Modified the report details page to no longer accept script tags in the name and description fields. Fixed an issue where running a report while other reports are uploading would sometimes cause the running report to persist the running state even after the report completes. Fixed an issue where opening multiple reports into Excel Online would only open the first report. Fixed an issue where reports containing cross-sheet referenced would fail to upload. Fixed an issue where successfully publishing a report from the Excel Add-In would sometimes not clear a previous upload error state. Fixed an issue where some scheduled reports would produce a time-out exception.

Jet Professional 2018 18.0.17321.0November 27, 2017

Changes since 18.0.17307.5

Excel add-in Updated product translations for Czech, Danish, German, Greek, Spanish, Finnish, French, Hungarian, Icelandic, Italian, Japanese, Dutch, Norwegian, Polish, Portuguese, Russian, and Swedish locales. Fixed issue where the report options window would sometimes not associate correctly with existing option lookups. Fixed a layout issue with the Insert Named Ranges window and the Fast Financials window. Fixed an issue where opening the Jfx window sometimes resulted in an empty window. Fixed an issue where running a report using a Data Warehouse or Cube data source with multiple instances of Excel running would sometimes activate the wrong instance after the report runs to completion. Fixed an issue where the Jfx would sometimes load the incorrect formula.

Jet Web Portal Updated product translations for Czech, Danish, German, Greek, Spanish, Finnish, French, Hungarian, Icelandic, Italian, Japanese, Dutch, Norwegian, Polish, Portuguese, Russian, and Swedish locales. Fixed an issue when changing the ownership of a scheduled task where searching for a phrase beginning with a space character sometimes returned inaccurate results. Fixed an issue where uploading multiple reports and navigating away from the reports section of the application would sometimes cause some of the reports to not upload completely. Fixed an issue where correcting a failed upload with a valid report of the same name would not clear the upload error upon successful upload. Fixed an issue where scheduling a report from the report details page would sometimes provide the wrong navigation when returning to the full list of reports. Fixed an issue where the delete folder button would not disable as expected after deleting a folder.

Jet Professional 2018 Build 18.0.17321.0

Initial release of Jet Professional 2018

Fast Financials

The Fast Financials feature for Dynamics NAV provides a fast and easy way to create financial reports.

Updated Jet Ribbon in Excel

The Jet ribbon within Excel has a new, contemporary look. Outdated features (i.e., Report Builder) have been removed, new features added, and other items have been updated to make them easier to find and use.

Updated Windows

Windows within the Jet Excel add-in have been given a consistent and more contemporary look.

Enhanced Control of the Jet Ribbon

The Jet Application Settings give you more control over the Jet Ribbon than ever before. Do you only use the GL function? Make it the only button available in the Jet Function Wizard (Jfx). Want to see all the Jfx buttons on the ribbon? Select the new Expanded Menu option.

Make the ribbon look just the way you need for the way you build and view your reports.

Domain Change for NAV Logins

Those Dynamics NAV users whose data resides outside their standard Windows domain can now specify the necessary domain as part of the username in their data source settings.

Help Menu Updated

The Jet Help Menu has been simplified to correspond to the consolidation of the Jet Reports Support, Help, Knowledgebase, and Community web sites. All of these can be accessed through the single Help Center option.

Specifying Domain Name during Login

In the Jet Web Portal, you can change the domain name associated with your login by entering a different name using either down-level (also known as 'server/username') format or UPN (also known as 'email') format.

Context Sensitive (right-click) Menus

The Jet Web Portal now features right-click menus that reflect the same options available on the action panel.

Easier Scheduling

In the Jet Web Portal, scheduled tasks can be created directly form the Reports List by selecting the desired report(s), and then either selecting Schedule from the action pane or right-clicking and selecting Schedule from the context menu.

Options for Opening Reports

To help everyone understand how to open reports in the Jet Web Portal, once you select one or more reports and click Open you will be prompted to decide if you want to open the reports with Excel Online or want to download the report and open it with an installed version of Excel.

Timeout Feature

When the Jet Web Portal has been left inactive for 20 minutes, a 60-second reminder will be displayed asking if you wish to stay logged in.  If no response is received, you will be logged out.  When you log back in, you will be taken directly to the screen you were on when your session timed out.

Support for More Jet Features

In Jet 2018, the Jet Web Portal supports Dashboard mode as well as the NL(Picture) and NP(Slicer) functions.

Support for More Excel Functions In Jet 2018, the Jet Web Portal supports additional Excel functions:

RADIANS FACTDOUBLE SEC, SECH, CSC, CSCH, COT, COTH, ACOT, and ACOTH RANK, RANK.EQ, RANK.AVG CEILING.MATH, FLOOR.MATH STDEVA, STDEVPA, VAR.S, VAR.P, VARA, VARPA TIMEVALUE

Jet Professional 2017 R3 Build 17.2.17275.2October 5, 2017

Changes since 17.2.17251.1

Excel add-in Fixed an issue where one or more buttons on the Jet ribbon would be removed rather than be disabled. Fixed an issue where exported favorite tables and fields for a data source could not be imported. Fixed an issue where closing multiple Excel workbooks in quick succession sometimes caused the Jet ribbon to fail to load.

Jet Web Portal Fixed an issue where sorting by the results of an NL("Suma") function in a report running in the Jet Web Portal did not work correctly when localized in Spanish. Fixed an issue where a report running in the Jet Web Portal with a cell containing a NETWORKDAYS() function resulted in #VALUE! in that cell. Fixed an issue where a report containing an NL("First") function containing a Link= would not produce the correct result. Fixed an issue where a report containing relative cell references running in the Jet Web Portal would sometimes fail to resolve correctly resulting in various errors. Fixed an issue where a report running in the Jet Web Portal that contains references across worksheets would not resolve those references correctly resulting in a corrupted Excel workbook. Fixed an issue where saving changes to a scheduled task in the Jet Web Portal as a result of being prompted to save due to the user's navigation would not give any notice to the user if any errors occurred during the save process. Fixed an issue where uploading a report to the Jet Web Portal with the same name as an existing report would not prompt the user to confirm overwriting the existing report if the report was originally downloaded from the same Jet Web Portal. Fixed an issue where renaming a report folder in the Jet Web Portal to a name only containing one or more spaces would result in an error message. Fixed an issue where testing newly entered SMTP settings in the Jet Web Portal would sometimes result in false errors. The reports available to be added to a scheduled task in the Jet Web Portal is now an alphabetized list. Validation errors shown when entering information for a scheduled task within the Jet Web Portal now give more useful details about the required information. Fixed an issue where editing a report title in the Jet Web Portal would sometimes result in repeating error messages.

Jet Administration Console Fixed an issue where manually synchronizing users with Active Directory sometimes did not work as expected.

Jet Professional 2017 R3 Build 17.2.17251.1September 14, 2017

Changes since 17.2.17230.4

Jet Web Portal Fixed an issue on the Jet Web Portal where data source was not set to blank during report upload. Fixed an issue on the Jet Web Portal where report sharing for certain users was not working as expected. Fixed an issue on the Jet Web Portal that improved the search experience for reports. Fixed an issue that prevented users from closing the report options window while running certain reports on the Jet Web Portal. Fixed an issue on the Jet Web Portal where selecting disabled Scheduled tasks did not disable the "Run" toolbar button. Fixed an issue on the Jet Web Portal where Japanese translations were incorrect. Fixed an issue where Accounting and Currency format rounded decimal values when run from the Jet Web Portal in certain languages. Fixed an issue where changing ownership after Jet Professional version upgrades did not permit the previous owner to run reports on the Jet Web Portal. Fixed an issue where users were unable to upload certain reports using a Dynamics GP data source to the Jet Web Portal. Fixed an issue where certain reports with NL(Rows) with one of its filters being a cell reference to NL(Filter) contained #VALUE after it was downloaded from the Jet Web Portal. Fixed an issue on the Jet Web Portal that would prevent the dashboards from loading correctly after they were created. Fixed an issue where certain reports that have functions referencing a TEXT() function did not return correct values. Fixed an issue where reports with INDEX(MATCH() function displayed incorrect date values when run on the Jet Web Portal.

Excel Add-in Fixed an issue where warehouse data sources did not correctly exclude tables with a "_PK" postfix.

Dashboard Builder Fixed an issue with Dashboards that prevented users from entering Target values with decimals to get percentages under 100%. Fixed an issue with Dashboards that caused the percentage number format for a measure to be displayed incorrectly for all visual types that allow number formats. Fixed an issue where the Dashboard Builder would become unresponsive when incorrect details are entered in the Settings → Application Settings section.

Jet Professional 2017 R3 Build 17.2.17230.4August 24, 2017

Changes since 17.2.17209.1

Jet Excel Add-In

Fixed an issue where certain reports that used SQLDataType Variant in a code field when used with NL(Sum) in Microsoft Dynamics Navision 2013 -2017 returned incorrect data. Fixed an issue where users licensed as Viewers could not publish reports from Jet Excel Add-in. Fixed an issue in the Jfx where a lookup on the Account argument of the Dynamics NAV GL function would not show all GL accounts. Fixed an issue in the Dynamics NAV 2013 and later codeunits where automatically publishing the codeunits to the web service would degrade the performance. Note: An import of the latest Jet codeunits is mandatory for this fix to be applied.

Jet Web Portal Fixed an issue where Reports on the Jet Web Portal could not be opened using One Drive for Business. Fixed an issue where reports with Nested Replicators could fail with an OutOfMemoryException when run on the Jet Web Portal. Fixed an issue where users could not cancel out of the Report Options window for certain reports on the Jet Web Portal. Fixed an issue where the Report Options window retained previously entered values even after cancelling the window for certain reports on the Jet Web Portal. Fixed an issue where creating duplicate folders on the Jet Web Portal did not provide clear error messages to the user. Fixed an issue on the Jet Web Portal where users were unable to rename folders on IE 11 and Edge browsers. Fixed an issue where users were unable to deselect folders in detail view on the Jet Web Portal. Fixed an issue where a useful error message was not shown whenever invalid start time was entered for Scheduled Tasks on the Jet Web Portal. Fixed an issue to improve readability and consistency across all web pages that have grid list display in the Jet Web Portal. Fixed an issue where the Last Run details of a report was not updated in the Jet Web Portal when run from the Scheduled task. Fixed an issue where a new owner of a report or a Scheduled Task was unable to edit and save Report Options on the Jet Web Portal. Fixed an issue on the Jet Web Portal where a Scheduled Task could be created and saved with no password credentials on Apple Safari Browser and iOS platform. Fixed an issue where a disabled Scheduled Task could be run from the Scheduled Task details page on the Jet Web Portal. Fixed an issue on the Jet Web Portal where users would not get a clear error message when attempting to run a report on a data source they no longer had access to. Fixed an issue where a Scheduled Task could be disabled from the Reports -> Details -> Schedule page on the Jet Web Portal. Fixed an issue on the Jet Web Portal logon page where the “Sign In” button was not disabled after the user submitted the username and password for the first time. Fixed an issue on the Jet Web Portal where searching for reports using a search term with delimiters was not supported. Fixed an issue on the Jet Web Portal where the Dashboards page was not reloaded after the search term was cleared. Fixed an issue on the Jet Web Portal where the search term was not bold in the search results for matching reports and corresponding report descriptions in the tile view. Fixed an issue where an error message was not displayed when a user attempted to run a report with an unauthorized data source on the Jet Web Portal. Fixed an issue on the Jet Web Portal where folders could not be renamed on touch screen interfaces. Fixed an issue on the Jet Web Portal where the Report Details page was inconsistent between tablet and desktop versions. Fixed an issue on the Jet Web Portal where the user was not redirected to the dashboard or report specified in the URL after their session had expired.

Fixed an issue on the Jet Web Portal where the user was not redirected to the dashboard or report specified in the URL after their session had expired.

Jet Professional 2017 R3 Build 17.2.17209.1

August 3, 2017

Initial release of Jet Professional 2017R3

  • Upload Report from with the Jet Web Portal
  • Directly Link to Jet Enterprise Dashboards
  • Publish Reports to Web Portal Folders
  • Record Keys now available when reporting form a Jet Enterprise Data Warehouse
  • Error Logging in the Jet Web Portal

Jet Professional 2017 R2 Build 16.1.17145.0 May 31, 2017

Changes since 16.1.17118.0

Installer Fixed an issue where the installer would not stop the Jet Service Tier before an upgrade installation. Fixed an issue where the Customer Experience Improvement (CEIP) window was not displayed on clean installation.

Jet Excel Add-in Fixed an issue where a Nested NL(Filter) added ‘||’ symbol to SELECT statement and eventually caused the reports to fail. Fixed an issue where F1 would opens an incorrect web page when pressed from the Report Option windows in the Jet Excel Add-in. Fixed an issue where reports that used NL(Count,NL(Intersect,NL(Filter),NL(Filter))) with +VALUES returned #VALUE. Fixed an issue where a corrupted Settings.xml files would create multiple exceptions which, in turn, would crash Microsoft Excel.

Jet Web Portal Fixed an issue where published reports failed to run on the Jet Web Portal when using result of NF() as filter. Fixed an issue where certain formatting and Fit tags caused reports to fail on the Jet Web Portal. Fixed an issue where certain reports that used MONTH() and DAY() arguments with undocumented Excel behavior failed to run on the Jet Web Portal. Fixed an issue on the Jet Web Portal where scheduled tasks disabled using the “disable” button on the toolbar would not be disabled. Fixed an issue where reverse sign option did not behave as expected for target value of performance tiles on the Jet Web Portal. Fixed an issue where an error log was not being created when the process running the report crashed on the Jet Web Portal. Fixed an issue where reports with an NF() filter on a FlowField returned incorrect values when run on the Jet Web Portal. Fixed an issue where reports with IFERROR(INDEX(MATCH)) did not work properly on the Jet Web Portal. Fixed an issue where Scheduled tasks executed from the Jet Web portal on a non-US locale Windows OS passed the dates in US format instead of local format. Fixed an issue where reports with a filter on a FlowField for <>0 would generate an IndexOutOfRangeException on the Jet Web Portal.

Jet Dashboard Builder Fixed an issue where reverse sign option did not behave as expected for target value of performance tiles in Dashboard Builder.

Jet Professional 2017 R2 Build 16.1.17118.0 May 4, 2017

Changes since 16.1.17100.0

Jet Excel Add-in Fixed an issue in Jet Excel Addin -> Data sources – Advanced Tab where text was cut-off for Cfront data sources. Fixed an issue where reports with an Excel Subtotal function returned incorrect results when executed in the Web Portal.

Jet Web Portal Fixed an issue where reports with non-English Jet tags threw an InvalidFieldException in the Web Portal. Fixed an issue where the column headers were truncated when resizing the scheduler and reports pages. Fixed an issue where some reports ran slowly in the Web Portal. Fixed an issue where a catastrophic failure error occurred whenever a non-admin user tried to run a report in the Web portal. Fixed an issue where some character combinations in the Web Portal User’s password caused a server error and displayed the password on the event viewer. Fixed an issue where reports with German 'Umlaute' (such as ö, ä, ü) in the name would crash Internet Explorer when it attempted to download from the Web Portal. Fixed an issue where some reports would generate a “Domain not found“ error and failed to publish to the Web Portal.

Jet Professional 2017 Build 16.1.17100.0 April 14, 2017

Changes since 16.1.17081.0

Jet Excel Add-in Fixed an issue in the JFx where switching the type of function did not work as expected. Fixed an issue in the Dynamics GP data source where a drilldown operation on a cell value of zero crashed Microsoft Excel. Fixed an issue where Windows OS with certain regional settings were not supported with SQL-based data sources. Fixed an issue with NL(Sheets) where a sheet name with a ’:’ (colon) character threw a COMException. Fixed an issue in the Dynamics NAV 2009 R2 or earlier data source where Windows OS with certain regional settings caused dates to be retrieved incorrectly. Fixed an issue in the Data Source Settings where creating a Dynamics NAV 2009 R2 or earlier data source cropped the text in the Data sources -> Advanced Settings window. Fixed an issue where Microsoft Excel crashed when a drilldown into Cube measure through the NF() function was performed.

Jet Web Portal Fixed an issue where reports with localized Excel functions within NP("Eval”) failed to publish to the Web Portal. Fixed an issue where reports with Named ranges referencing sheets with ‘!’ failed to publish or run on the Web Portal. Fixed an issue where reports with localized date formats published but failed to run on the Web Portal. Fixed an issue where some localized reports failed to run on the Web Portal .

Jet Professional 2017 R2 Build 16.1.17081.0

March 23, 2017

Changes since 16.1.17061.0

Installer Fixed issue where a COMException could occur during installation.

Jet Remote Data Service Fixed issue where Jet Remote Data Service could not be installed on Windows Server 2008 or earlier.

Excel Add-in Fixed issue in the Excel Add-in where links to KB articles were incorrect. Fixed issue in the Excel Add-in where double-clicking on the Pivot Table Icon on the Jet Ribbon would select the wrong item within the Pivot Table window. Fixed issue where a Radar Chart could prevent a report from being published to the Web Portal.

Web Portal Fixed issue where hard coded references to NL(Link) could corrupt workbooks when run in the Web Portal. Fixed issue where Reports saved to OneDrive or OneDrive for Business folders could not be published to the Web Portal. Fixed issue where scheduled tasks could not be saved with a "Minutely" or "Hourly" recurrence in the Web Portal. Fixed issue in the Web Portal where the folders could not be sorted in descending order. Fixed issue in the Web Portal where the column names in the Scheduler page would be cropped. Fixed issue where non-US date formats could cause reports to fail when run in the Web Portal. Fixed issue where reports with conditional formatting rules with ranges separated by commas could not be run successfully in the Web Portal. Fixed issue where certain reports with Date functions in the Report Options would not run successfully in the Web Portal. Fixed issue where an empty email body would prevent an email from being sent after a scheduled task completes. Fixed issue where certain users were unable to run scheduled tasks successfully in the Web Portal. Fixed issue where certain reports would run without error in the Web Portal but display #VALUE errors when downloaded. Fixed issue where the scroll bars in the Report Options lookup window would not function correctly.

Jet Professional 2017 R2 Build 16.1.17061.0

March 3, 2017

Changes since 16.1.17033.0

Jet Excel Add-in

Fixed an issue where reports that used NP(Union), NP(Difference), or NP(Intersect) with a Microsoft Dynamics NAV 2013 or later data source could result in an unexpected error.

Fixed an issue where reports with Microsoft Dynamics Nav 2009 and earlier data sources could not be run.

Jet Professional 2017 Build 16.1.17033.0

February 7, 2017

Initial release of Jet Professional 2017R2

Overview of Jet Reports 2017 R2
  • Jet Web Portal Scheduling
  • Improved Drilldown Experience for Jet Web Portal Reports
  • Drilldown for Dynamics GP G/L Reports
  • Improved User Experience in the Jet Web Portal
  • The Jet Web Portal now replaces the iPad app for iPad users.  The iPad is no longer supported

Jet Professional 2017 Build 16.0.16336.1

December 7, 2016

Changes since 16.0.16293.1

Excel Add-In

Fixed issue where some Jet functions returned a #VALUE! when the "Enable batch function execution" setting was enabled. Fixed issue in the Scheduler where the Next Run Time, Last Run Time, and Status were not being updated in Windows 10. Fixed issue in the Cube Data Source where "Date" dimension levels were returned to Excel as strings instead of dates. Fixed issue where NP(Union), NP(Intersect), NP(Difference) with only NL(Filter) function as inputs were returning an array to Excel as opposed to the expected "||" string. Fixed issue where the NL(Table) function with duplicate NP(Formula) fields did not work as expected.

Jet Administration Console

Fixed issue where non-administrators received the message that the "Service is not running" when connecting to the Jet Service Tier.

Jet Web Portal

Fixed issue where some larger reports that run correctly in Excel would return #VALUE! errors or incomplete data when run in the Web Portal. Fixed issue where reports using the Excel FLOOR() function did not work as expected. Fixed issue with slicers where only the first pivot table reference was being updated.

Remote Data Service

Fixed issue in the NAV Remote Data Service where using Windows Authentication on the server caused the error "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'".

Jet Professional 2017 Build 16.0.16293.1

October 19, 2016

Changes since 16.0.16287.0

Excel Add-In

Fixed issue in NAV data sources where Jet functions querying tables that had multiple fields with the same caption returned #VALUE.

Jet Web Portal

Fixed issue in NAV data sources where Jet functions querying tables that had multiple fields with the same caption returned #VALUE. Fixed issue where the Excel IFERROR function would produce an unexpected result when it had nested functions with errors.

Jet Remote Data Service

Fixed issue in NAV data sources where Jet functions querying tables that had multiple fields with the same caption returned #VALUE.

Jet Professional 2017 Build 16.0.16287.0

October 13, 2016
Changes since 16.0.16252.0
Excel Add-In
Improved performance of the Batch Function Execution optimization in some situations.
Improved performance of certain types of FlowFields in the Dynamics NAV SQL data source.
Improved performance of publishing certain types of reports to the Web Portal.
Updated "New Data Source" and "Publish" windows to allow the Enter key to make the default selection.
Fixed issue in Universal/SQL-Based data sources where Time fields would throw an ArgumentException, or always return 0.
Fixed issue in Dynamics NAV SQL data sources where Code fields backed by a SQL Variant did not work correctly.
Fixed issue where the NL(Table) function threw an IndexOutOfRangeException if one of the requested fields was blank.
Fixed issue in Table Builder where the "Favorites" button would be selected and disabled if no Favorites were selected in the Browser.
Fixed issue where database name drop-downs were not sorted alphabetically.
Fixed issue where Array functions (e.g. Union, Difference, Intersect) do not evaluate non-array values correctly.
Fixed issue where publishing a report with a formula could not be calculated would reference the wrong cell address in the error message.
Fixed issue where downgrading the Excel Add-In could result in an error when opening Excel due to an unrecognized Application Setting type.
Jet Web Portal
Updated Japanese translations.
Improved messaging to be more specific when a failed login occurs.
Improved messaging around Excel file formats that support publishing to the Web Portal (*.xlsx and *.xlsm).
Fixed issue where cell formatting could be changed when running a report in the Web Portal in a non-US English locale.
Fixed issue where certain types of named ranges such as Print_Titles would result in a corrupt workbook.
Fixed issue where a large named range (e.g. entire row or column) could result in a corrupt workbook.
Fixed issue where database values were not being quoted when written to the workbook, which could cause Excel to interpret them incorrectly.
Fixed issue where NF functions that used a different identifier than the one used in the NL function would result in a #VALUE.
Fixed issue where a replicator would fail to expand if one of the requested fields was blank.
Fixed issue where using a NAV Web Service data source could result in a failure to load a temporary assembly with an "Access Denied" error.
Fixed issue where the Language selection drop-down would not render correctly in Internet Explorer.
Fixed issue where logging in after being automatically logged out due to an expired session would always return to the Reports page.
Fixed issue where the Fit tag may not correctly size columns to the content.
Fixed issue where security settings could prevent opening reports in OneDrive.  Protected View must still be disabled.
Fixed issue where the reports on the Report page did not have a default sort order.
Jet Remote Data Service
Added a Launch Condition to the MSI that requires the SQL Native Client to be installed.

Jet Professional 2017 Build 16.0.16252.0September 13, 2016

Changes since 16.0.16221.0

Added support for NAV 2017. Note that an updated version of the "Jet Reports Objects.fob" NAV objects must also be imported. Added firewall rule exceptions when installing the Jet Web Portal. Improved overall performance of NAV Remote Data Service data sources.

Excel Add-In

Fixed issue where a failed connection to the Jet Service Tier would display a message when opening Excel. Fixed issue where grid drilldown into a Remote Data Service data source would display an empty grid. Fixed issue where SQL= would not work correctly in Remote Data Service data sources. Fixed issue where the "Auto Debug Report Errors" feature no longer worked as expected. Fixed issue where the Table Builder would not allow duplicate Formula fields. Fixed issue where the Table Builder would allow multi-selection for a filter value but would only select a single value.

Jet Web Portal

Fixed issue where some non-US date formats did not work correctly when running reports. Fixed issue where reports containing a pivot table that were source from an Excel table would not run correctly. Fixed issue where charts would not be moved as a result of replicator expansion when running a report. Fixed issue where a nested NL(Filter) inside a Link= would not get published correctly. Fixed issue where shared formulas in the workbook would be corrupted after running the report. Fixed issue where the tab key would not work as expected in the Report Options window. Fixed issue where attempting to login with an incorrect domain name would still create a user record in the Jet Service Tier database. Fixed issue where a formula with a concatenation operator '&' and an empty value would result in a #VALUE. Fixed issue where an NP(Eval) function with a Jet function in the Formula argument would result in a #VALUE. Fixed issue where an NF result with a single quotation mark would result in a #VALUE. Fixed issue where sorting by a dimension that was not also being retrieved in the Cube data source would result in a #VALUE.

Jet Professional 2017 Build 16.0.16221.0

August 10, 2016

Changes since 16.0.16196.0
Removed capability from the Jet Setup to restrict users to the Jet Service Tier for data sources.  This functionality is still available as a command-line parameter to the Jet.Setup.ExcelAddIn MSI.
Changed the Jet Web Portal to open reports in OneDrive/OneDrive for Business in View mode as opposed to Edit mode.
Updated the link to the Privacy Policy in the Activate Jet License window.
Excel Add-In
Fixed issue in the Dynamics NAV Remote Data Service data source where sorting by a CalcField did not work correctly.
Fixed issue in the Dynamics NAV SQL data source where filtering by an NAV Code field with properties Numeric=Yes and SQL Data Type=Variant may not retrieve the correct results.
Fixed issue in the Dynamics GP data source where functions containing SQL= may fail when the Batch Function Execution setting was enabled.
Fixed issue in the Dynamics GP data source where tables/views were always sorted by their physical name in the Table Builder and Jfx.
Fixed issue in the Jet Administration Console where importing a data source set the scope of all settings to "user", as opposed to the default scope for each setting.
Fixed issue where orphaned workbook connections with associated PivotTables could cause E_INVALIDARG errors.
Fixed issue where Stored Viewer Data could cause Excel to become non-interactive after running a report.
Web Portal
Fixed issue where opening a report using OneDrive for Business would navigate to the root folder, not open the report.
Fixed issue where pages may not have rendered correctly in Internet Explorer.
Fixed issue where NF functions inside nested replicators may not be written to the output workbook correctly.
Fixed issue where replicated values were not quoted, which could result in the loss of leading zeroes.
Fixed issue where group users could not login unless they had first connected to the Jet Service Tier from Jet Professional.
Fixed issue where report output could be corrupted when using non-English (US) regional settings.
Fixed issue where reports with conditional replication may fail to run correctly.
Fixed issue where the user could select a language that was not supported/translated.
Fixed issue where some Excel functions (DAY, MONTH, etc.) failed to convert dates correctly in some cases.
Fixed issue where reports with link filters that reference a cell containing NL(Filter) would result in an EmptyFilterException.
Fixed issue where reports could be renamed to white space.

Jet Professional 2017 Build 16.0.16196.0 July 20, 2016

Initial Release of Jet Professional 2017

  • Reporting with the Jet add-in for Excel
  • Introducing the Jet Web Portal
  • Jet Professional Integration with Jet Enterprise Dashboards

If upgrading to Jet Professional from a version of Jet Essentials *PRIOR TO* version 15.0.14329...

ALL previously-installed Service Tier components (Jet Administration Console, Jet Dashboard Builder, Jet Web Service, Jet Service Tier)

must be MANUALLY UNINSTALLED (using the "Jet Setup.exe" file included with that specific release) before running the new installer.

Related Articles

  • Uninstalling the Jet Service Tier
  • Support Maintenance Schedule
  • Jet Essentials 2011-2015U1 - Release Notes

Published:

Jet Reports - Release Notes

Jet Reports (including the Jet Excel add-in and Jet Hub) receives updates on a regular basis.

Click this link to see What's New in the most recent Major release of Jet Reports.

See below for the changes that have been made for each chronological release.

Release Notes

Jet Reports 24.1.2 Build #24.1.2.1142

Release Date: April 30, 2024

Jet Reports

Resolved Issues

  • 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 Hub

Resolved issues

  • 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 Reports 24.1.1 Build #24.1.1.0811

Release Date: March 25, 2024

Jet Reports

Resolved Issues

  • 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

Resolved Issues

  • 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)

Features

  • 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)

Jet Hub

Resolved Issues

  • 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)

Features

  • Jet Hub is compatible with .Net8. (6600)

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)

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)

Jet Reports 21.4.2 Build 21.4.22025.1

Release Date: January 27, 2022

Jet Add-In

Resolved Issues

  • Corrected an issue where in some languages the weekday was not displaying correctly in the Jet Reports Scheduler. (2125)
  • Corrected an issue where Business Central on-premise Direct SQL data source was not displaying extended ENUM option captions in report. (3422)
  • Corrected an issue with expired tokens where users were receiving the incorrect error message and were not being prompted to re-authenticate their account against the Jet Service Tier. (3158)
  • Corrected an issue where the NL(Sheets) function with embedded NF() did not work with the following data sources: 'Dynamics NAV 2013-2018 (SQL Server)' & 'Dynamics 365 Business Central (SQL Server) on-premise'. (3233)

Jet Reports 21.4.1 Build 21.4.21337.1

Release Date: December 20, 2021

Jet Add-In

Resolved Issues (impact: extension only)

  • Corrected an issue where security filters were preventing data from being returned. (3367)

Jet Reports 21.4.1 Build 21.4.21337.1

Release Date: December 09, 2021

Jet Add-In

Feature Updates

  • Enhanced filters to allow multiple filter values against the same field when running against BC Public Cloud. (3316)
  • To make the process of scheduling and distributing batch reports faster and easier for users, Jet Reports introduces a new report scheduling wizard. The new wizard walks the user through a series of simple questions to complete a batch schedule and report template for them. The new Batch Report Wizard button can be found on the Jet Ribbon in the Tools section beside the Report Wizard button. (3360)
  • Improved the verbiage on the Email Tab of the scheduler to reflect an Error Notification. (3395)

Resolved Issues

  • Corrected an issue where using NL(BinaryText) function would return an error or not return data. (3385)
  • Corrected an issue where Jet Basics would not function without the trial running and give an error. (3405)
  • Corrected options for CC and BCC on the scheduler (3479)

Jet Reports 21.4 Build 21.4.21281.3

Release Date: October 12, 2021

Jet Hub

Resolved Issues

  • Updated Jet Hub so that if TLS 1.0 and 1.1 are disabled with TLS 1.2 enabled, O365, Azure, and Basic user logins will work. (2273)

Jet Add-In

Feature Updates

  • To help users identify and correct potential errors more quickly when scheduling and distributing batch reports, Jet Reports has added the ability to send a user an email indicating an error has occurred with a report. This can be found in the Schedule Task window on the Email Tab. (3302)
  • When a new BC Cloud connection is created, the page size (MB) setting will now default to 1 instead of .1. This will improve performance for large reports that take advantage of batch execution. This change will not affect cloud connections that already exist. (2786)

Resolved Issues

  • Corrected an issue where Jet was not properly handling decimal values in regions where a comma is used instead of a decimal. (3348)
  • Fixed an issue so that NL(Sum) and NL(Count) return the same data as NL(Rows) when considering time localization with date/time fields in the database. (3207)

Installer

Resolved Issues

  • Updated the installer to allow upgrade of the Jet Service Tier on an Azure SQL instance. (3184)

Licensing

Resolved Issues

  • Corrected an issue where if TLS 1.0 or 1.1 are disabled, you cannot activate the Jet license. (2201)

Jet Reports 21.3.1 Build 21.3.21244.1

Release Date: September 2, 2021

Jet Hub

Resolved Issues

  • Corrected an issue causing an object reference error when running nested functions against BC Odata connection. (3101)
  • Corrected an issue when attempting to download files with certain Japanese characters in the filename would result in the file downloading with a numeric filename instead. (3137)

Jet Add-In

Feature Updates

  • When a new BC Cloud connection is created, the page size (MB) setting will now default to 1 instead of .1. This will improve performance for large reports that take advantage of batch execution. This change will not affect cloud connections that already exist. (2786)

Resolved Issues

  • Corrected an issue causing an error to be returned when using Limit= with a BC Web Services connection. (3253)
  • Corrected an issue causing a BC on-premise Direct SQL data source to not recognize extension FlowFields correctly. (3254)
  • Corrected an issue where an invalid field error would be thrown when a report uses a FlowField in Nav. (3285)
  • Corrected an issue causing an object reference error when running nested functions against BC Odata connection. (3289)

Jet Reports 21.3 Build 21.3.21200.5

Release Date: July 23, 2021

Technology Upgrades

  • This release includes upgrades to Microsoft .NET Core 5.0 and Microsoft .NET framework 4.8. The installation of this Jet release will automatically install these needed upgrades before installing Jet Reports release 21.3.

Jet Hub

Feature Updates

  • Added the ability to turn on/off logging from the Jet Hub under Settings->Logging. (2282)

Resolved Issues

  • Corrected an issue so conditional formatting will be applied on a report with Dutch language. (2124)
  • Corrected an issue where selecting Open in Excel Online was not working in Chrome. (2422)
  • Corrected an issue to prevent getting a credential error when using an on-premise data sources with an Azure AD or basic authentication Jet Service installation. (3163)
  • Corrected an issue where weekly tasks would duplicate one day but leaving out another day (3228)

Jet Add-In

Feature Updates

  • Enhanced the NL First function to return the same results when run against Web Services or Direct SQL when sort is not provided. (3170)
  • Enhanced the Evaluate Function to return the same results when using Web Services or Direst SQL connections to Business Central. (3171)

Resolved Issues

  • Corrected an issue where NL(First) and NL(Last) could produce incorrect results when using Web Services vs Direct SQL. (1323)
  • Corrected an issue when using Table Builder and linking from a custom field to link to another table so an "invalid column name" error is no longer issued and the link works correctly. (2761)
  • Corrected an issue where a formula with nested NF function didn't return the correct results when using German regional format. (2792)
  • Corrected an issue caused cells to return when #Value when using OData BC Connector with a large number of GL Functions. (2867)
  • Corrected an issue where the Check for Updated Version was not properly displaying a message that an updated version of Jet Reports was available. (3198)

Jet Services Administration Shell

Feature Updates

  • Added the ability to turn on/off logging from the Jet Services Administration Shell using the command Set-LoggingOnOff. If a 1 is provided after the command, logging will be turned on. If a 0 is provided after the command, logging will be turned off. If a value of is not provided, you will get a message on the values to provide. (3181)

Jet Reports 21.2.2 Build 21.2.21159.1 Release Date: June 11, 2021

Jet Add-In

Resolved Issues

  • 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. (1601)
  • Significantly Improved performance when using a Direct SQL connection on BC databases with a large number of companies. (2777)

Jet Reports 21.2.1 Build 21.2.21146.1 Release Date: May 26, 2021

Jet Add-In

Feature Updates

  • Changed the program to allow entering a user for a scheduled task that is not the current user. (2318)

Resolved Issues

  • Corrected an issue that would cause an error when trying to run a report that included a table which has a table extension installed. (1716)
  • Made a change so that when a metadata key error is experienced, Jet will make a log entry instead of generating an error. (2602)
  • Corrected an issue where in some circumstances an error would be issued when running a report with an extension field. (2794)
  • Made a change so that Enum fields can now be seen and used. (2795)
  • Corrected an issue so when connecting to a BC data source via ODATA where the company contains an ampersand, the connection will be successful. (3196)

Jet Reports 21.2 Build 21.2.21112.1 Release Date: April 27, 2021

Jet Security Protocols

  • Enhanced Jet to work correctly with TSL 1.2. (3019)

This enhancement has resolved the following issues:

      • Corrected an issue accessing Cubes over IIS connection where an error "Could not create SSL/TLS secure channel". (2927)
      • Corrected an issue where Jet Hub Scheduler would not run tasks when only TLS 1.2 is enabled. (2270)

Jet Hub

Resolved Issues

  • Corrected an issue where refresh tokens were duplicated causing the error "An item with the same key has already been added" to occur. (3088)
  • Corrected an issue when scheduling tasks so that the day/time selected would be saved correctly. (2919)

Jet Add-In

Feature Updates

  • Enhanced the Table Browser to hide tables the user does not have permission to access. (2729)
  • Improved Jet Reports performance when running in a multi-core environment. (2787)

Resolved Issues

  • Changed the program so that connection with ODATA does not give an error if the user does not have permissions to the table. (2662)
  • Users can now be added from another domain in the Jet Service Tier. (2707)
  • Corrected an issue where in some circumstances, you would get an error when activating the Jet Basics Trial. (2745)
  • Made a change so that Enum fields can now be seen and used. (2795)
  • When pulling source document field from Warehouse receipt line table, the value returned is now correct. This was due to a change in BC SaaS 17.1. (2833)
  • When using a BC SQL data source, if the table extension is off a non-standard table such as one from a third-party app, the extension table/fields are now shown in the browser and can be pulled in an NL function. (2868)

Jet Reports 21.1 Build 21.1.21021.1 Release Date: February 2, 2021

Jet Hub

Feature Updates

  • Jet Hub has been updated to allow multifactor authentication for Business Central Web Services data sources.  Administrators can enable this feature via the settings tab within the Jet Hub. Detailed instructions on setting up multifactor authentication can be found here: Enabling Multi-factor authentication for BC Cloud Web Services data sources within the Jet Hub . (2677)
  • The expanded implementation of the ODATA toggle for connectivity is extended to Jet Hub and JET ADMIN CONSOLE. (2678)

Jet Add-In

Resolved Issues

  • Corrected an issue where filtering on timefield could return incorrect results. (1575)
  • Eliminated an error that occurred when running reports from BC's item table with a deprecated extension field. (2087)
  • Jet Tab now loads correctly when running Excel via "Run as Administrator". (2738)
  • Corrected an issue where the output type of .xlsm was not always handled correctly. (1605)
  • Corrected a blank filter error that would occur when using BC Web Services but would not occur using a Direct SQL Connection. (2305)

Jet Reports 20.8 Build 20.8.20353.1 December 18, 2020

Changes since 20.8.20297.3

Excel Add-in Implemented additional telemetry to the Jet Reports add-in. This is used to enhance our understanding of application usage. Added clarity to the error message when internet is not available to the user.

Jet Reports 20.8 Build 20.8.20297.3

October 29, 2020

Changes since 20.7.20295.1

Excel Add-in

New Connector for Jet Reports into Microsoft Business Central In version 20.8 .  We are making available a new connector for Business Central, based on the OData API. This new connector is significantly faster than the existing SOAP connection.  The new connector installs in minutes, requiring the installation of an extension to Business Central. You can access the new OData connector through our Early Adopter Program until we release the next version of Jet Reports in Q1, 2021. Jet partners and customers interested in using the new connector should contact insightsoftware support and request access to the installer for the extension.  The new connector is available for users of Jet 20.8 and Business Central 16 and above. At the end of the Early Adopter Program, we plan to publish the extension through Microsoft AppSource.   Additionally, we have validated this version of Jet Reports against Business Central, 2020 Wave 2.

Jet Reports 20.7.2 Build 20.7.20295.1

October 29, 2020

Changes since 20.7.20246.2

Excel Add-in

Certification with Microsoft Business Central, 2020 Wave 2 .  We have validated this version of Jet Reports against Business Central, 2020 Wave 2.

Jet Reports 20.7.1 Build 20.7.20246.2

September 3, 2020

Changes since 20.7.20210.6

Jet Hub

Fixed Issue - Authenticating users against a BC data source in the Jet Hub doesn't work for anyone other than the user that created the data source

Excel Add-in

Fixed Issue - Attempting to install Client Components or All Components on a machine with Excel is not possible Fixed Issue - Cannot install Jet Hub without Jet Service Tier selected

Jet Reports 20.7 Build 20.7.20210.6

July 28, 2020

Initial release of Jet Reports 20.7

Jet Reports

  • Simplified installation process: The Jet Reports install process has been streamlined to make installation quicker, easier, and more intuitive.

  • Rebranded Excel Add-in: The look- and- feel of the Jet Reports Excel-add-in has been updated with fresh new icons for a cleaner interface, while bringing it in line with insightsoftware’s brand.

  • Connect to read-only NAV databases: Jet Reports administrators can now configure the Application Intent parameter of the SQL connection, enabling them to use the read-only replica of the NAV database in Azure.

Jet Hub

  • Seamless authentication with Business Central Cloud for Jet Hub Users: When a user receives a shared report through the Jet Hub that they want to refresh against Business Central Cloud, they will now be prompted to enter their Business Central credentials via the Hub and they will then be able to refresh reports against their profile.

Jet Hub

Fixed Issue - German translations are both incorrect and missing in the Jet Hub Scheduler

Fixed Issue - Jet Hub Report Options adding time onto date erroneously

Fixed Issue - Trying to Add a Basic Authentication user Edits the last user you were selected on if you don't deselect them first.

Fixed Issue - Grid check-boxes do not display in Jet Hub when using IE/Edge

Added support for using Azure proxy for both Authentication and Reporting while connecting to BC Cloud

Excel Add-In

Fixed Issue - Query does not seem to bring all results from the table

Fixed Issue - Jet Function Evaluation issue with versions 20.4 and later

Fixed Issue - Customized Drill-down view settings wiped out if user drills down on cell with no records

Fixed Issue - Jet Reports - Using Binary Text in NL function - special danish character turn into strange symbol

Added support for using Azure proxy for both Authentication and Reporting while connecting to BC Cloud

Jet Reports 20.6.1 Build 20.6.20143.4

May 26, 2020

Changes since 20.6.20126.5

Excel Add-In Change to support TLS 1.2 for JRDS. Change to support TLS 1.2 for Office365 SMTP in Jet Scheduler SMTP settings.

Jet Reports 20.6 Build 20.6.20126.5

May 5, 2020

Initial release of Jet Reports 20.6

Jet Reports

Jet Hub

Dynamics 365 Business Central 2020 Release Wave 1 (BC16) Compatible

Jet 20.6 has been verified Against Business Central Release Wave 1, 2020, both On-Premise and Cloud!

Jet Basics

Updated Jet Basics Trial Version

Jet Basics now includes a free trial enabling users to get a taste for some of the more advanced report creation capabilities that were previously only available in Jet Reports. To continue using these capabilities after their trial period ends, users will have the option to upgrade to Jet Reports

Excel Add-In

Fixed issue - Date Table not accessible with Business Central On-Premises Data Source.

Fixed issue - Users in other cultures cannot connect to BC.

Jet Hub

Fixed issue - Culture ID 9 (0x0009) is a neutral culture.

Jet Reports 20.5 Build 20.5.20042.1

February 11, 2020

Initial release of Jet Reports 20.5

Jet Reports

Enhanced query handling for Business Central

Microsoft has implemented new API limits for Business Central customers to ensure that no single client can consume too many resources and become a "noisy neighbor." For Jet Reports users, this change could cause some larger queries to time out and return an error message.

To work with these new API limits, Version 20.5 introduces a query orchestrator to smooth out query requests, verify that results have been returned, and handle any timeouts and retries as necessary.

The query orchestrator can identify longer queries that may time out, and it breaks these up into a series of smaller queries to run individually. It then smartly and seamlessly blends the results into a single dataset for display, so end-users can continue to refresh their reports without interruption.

Jet Reports

Support for Business Central multi-tenant environments

When customers deploy Business Central multi-tenant environments and define their credentials centrally, they can now select which tenant they want to authenticate against when using Jet Reports. This enables customers to:

  • Switch between tenants, so they arer no longer limited to the default tenant in which their central credentials were defined.
  • Switch between production environments, so they are no longer limited to their default environment.

Jet Budgets

Simplified set-up of budget security

Budget administrators can now add groups of users from Active Directory or Azure Active Directory, rather than adding users one at a time. When adding a group, users within that group are given the role of budget user, budget viewer, budget contributor or approver, or budget owner.

Jet Budgets

Streamlined navigation of budget lists

For organizations managing large numbers of budgets, Version 20.5 makes it faster and easier to navigate and search through lists of budgets. By adding pagination, users can select the number of results (budgets) shown per page and then easily navigate between pages. The existing search box, which makes it easy to search for a budget by name, now works in sync with the pagination function.

Jet Budgets

Faster rendering of content in the budget overview page

Performance enhancements in Version 20.5 speed up the rendering of content in the budget overview page.

Jet Hub

Updated branding

With Version 20.5, the look and feel of Jet Hub has been updated to use insightsoftware branding.

Jet Reports 20.4 Build 20.4.19336.1

December 4, 2019

Changes since 20.4.19301.1

Jet Budgets Fixed an issue preventing users from copying custom budgets.

Excel Add-In Fixed an issue where Jet was not recognizing customized permissions from the Tenant when connecting to Business Central.

Fixed issue that was preventing the Excel Add-in Scheduler from working with command-line substitutions.

Fixed issues that prevented settings from being saved in the Jet Scheduler task.

Jet Reports 20.4 Build 20.4.19301.1

October 29, 2019

Initial release of Jet Reports 20.4

Jet Budgets Performance Improvements

The objective of this feature is to improve the user experience when using Jet Budgets by reducing the bottleneck situations that may cause a degradation of performance. The feature encompasses several enhancements and they respond to specific feedback from current users.

Enhance Scheduler Task Editor

This is the conclusion of the work started in release 20.3 to enhance the new Report Scheduler made available with release 20.2. The scheduler is used to schedule and automate the distribution of reports to selected recipients across the organization.

Extend Jet Budget Security and Permissions

This feature increases the options available to assign responsibilities over a give budget or work items of a budget.

Enable Jet Budgets Read Only Users

This release introduce the Budget Viewer. They are users given the ability to access a given budget and report on its numbers without the ability to add or modify anything. The budget viewers can run reports using the GL( JetBudget ) function. These users will also have access to the Overview page of the budget.

Administrators can edit existing users to give them this permission, even after they have been added the budget with a different role

To assign a user as Viewer, there is a new checkbox in the menu listing the users assigned to a budget.

GP Scalability

Improved scalability in GP GL function with a segment or category filter that selected too many accounts could cause SQL Server to create a query plan.

Jet Reports 20.3 Build 20.3.19276.1

October 4, 2019

Changes since 20.3.19268.1

Jet Excel Add-In Fixed issue where Jet Dynamics 365 Business Central (Web Services public cloud) datasources could not connect.

Jet Reports 20.3 Build 20.3.19268.1

October 2, 2019

Changes since 20.3.19246.1

Jet Budgets Fixed issue where Jet Budgets cannot be copied. Fixed issue where Jet Budgets searching doesn’t work. Fixed issue where budget dimensions with many values (1100+) do not display properly in the dropdown for "Split Rows By Dimension" Fixed performance issue when loading the Overview Page in Jet Budgets.

Jet Reports 20.3 Build 20.3.19246.1

September 4, 2019

Changes since 20.3.19227.2

Excel Add-In Fixed issue where evaluating a formula in the Jfx could freeze Excel. Fixed issue where Excel crashed when closing the Jfx in certain cases when using a BC public cloud data source. Fixed issue where the default page size was too large for BC public cloud data sources due to changes by Microsoft. Fixed issue to allow reinstallation of the Jet Service Tier when the authentication type is AAD. Fixed issue to allow users to install different authentication types.

Jet Hub

Fixed issue where some user names were being displayed as blank in the Jet Hub data source permissions view.

Jet Reports 20.3 Build 20.3.19227.2

August 17, 2019

Changes since 20.3.19214.1

Excel Add-In Fixed issue where customers using a Business Central Public Cloud data source may receive a 429 error due to resource throttling imposed by Microsoft. Fixed an issue where named ranges were not being shown in the Scheduler. Fixed an issue where NP(Eval) was causing error in certain languages. Fixed an issue where underscores were not allowed when specifying the JST host name.

Jet Hub

Fixed an issue where a changed password for an AD user was not prompting them to update their password in the Hub.

Jet Reports 20.3 Build 20.3.19214.1

August 6, 2019

Initial release of Jet Reports 20.3

Jet Reports Performance Improvements

In our effort to continue to deliver better performance to our customers we have leveraged additional functionality in Excel to harness asynchronous handling of functions . This has resulted in greatly improved performance , especially for longer-running reports.

Jet Budgets support for non-Dynamics data sources.

Jet Reports 20.3 supports Budgets for custom data sources . This is a great benefit to those customers who are not using Dynamics Business Central, NAV or GP.

"Basic User" Authentication within Jet Hub and the Jet Reports Excel add-in

For those organizations using neither Active Directory nor Azure Active Directory, the Jet Installer, Jet Hub, and Jet Reports all now support the creation and use of "Basic User" Authentication where user accounts can be defined within Jet Hub and used in Jet Reports to connect to the Jet Service Tier.

Updated Jet Scheduler Task List within the Jet Reports Excel add-in

Continuing with efforts to bring all the Jet add-in features in line with a consistent look as well as providing intuitive and easy to use interactions, the interface for the Jet Scheduler Task List has been improved.

Improved Data Source Management within Jet Hub

Jet Reports 20.3 includes more Data Source types and an updated user interface for Assigning User Permissions to data sources from directly within Jet Hub .

Jet Reports 2019 R2 Build 20.2.19183.2

July 9, 2019

Changes since 20.2.19154.1

Jet Hub

Added missing translations to some areas of the Jet Hub. Fixed an issue where scrolling for report options in the Hub did not work as expected.

Excel Add-In Fixed issue when closing periods were used in the start or end periods of a GL function.

Jet Budgets Fixed issue where column sizing was not correct for the budget overview.

Jet Installer Fixed an issue where the IIS AppPool would not stop on install/uninstall.

Jet Reports 2019 R2 Build 20.2.19154.1

June 10, 2019

Changes since 20.1.19133.1

Jet Hub Added ability to manage all permissions for all data sources Added ability to create an on-premises Business Central data source using web services. Added ability to create an on-premises Business Central data source using direct SQL. Added ability to support and run reports with slicers in Pivot Tables. Added ability to provide Office 365 (O365) user mapping in the Jet Hub.

Fixed an issue were auto fill periodically overwrote data source credentials Fixed an issue where navigating to “\login” produced a blank page. Fixed an issue where selecting all reports and then selecting an element out side of the list would clear the selection. Fixed an issue where not all report runs could be scrolled to in the run history tab. Fixed an issue where a user would be routed to the login screen after opting to ‘stay logged in’ after inactivity. Fixed an issue where the database field would be empty for Business Central direct sql connection types. Fixed an issue where some check boxes were unavailable in the permissions tab of the Jet Hub. Fixed an issue where hidden rows/columns were not hidden with reports containing a pivot table. Fixed an issue where a pivot table run in the Jet Hub would corrupt the work book.

Excel Add-In Fixed an issue where the Jet Browser could not remove all ‘Favorites’ unless you manually deleted the ‘Favorites’ xml. Fixed an issue where a Jet Service Tier connection error was generated if a user did not have 'create' data source permissions. Fixed an issue where favorites were not saved in the Browser if using a C/Front data source. Fixed an issue where the table builder produced inconsistent results. Fixed an issue where the Report wizard did not specify the company if the default data source was not used. Fixed an issue where users using the Report wizard could not select a filtered item in a table drop down. Fixed an issue where occasionally saving favorites in the report wizard closed excel. Fixed an issue where the Browser would not save favorites when a GP data source was used.

Jet Budgets Added ability to enter a custom date range when creating a budget.

Jet Dashboard Builder Fixed an issue where the Jet Activation window opened each time the Jet Dashboard Builder was opened.

Jet Installer Fixed an issue where some SSL configurations did not update when modifying the Jet installation.

Jet Reports 2019 R2 Build 20.1.19133.1

May 20, 2019

Changes since 20.0.19116.1

Jet Hub Added ability to discard changes when editing a data source within the Jet Hub. Fixed an issue where a report with Pivot Tables would take longer to run in the Jet Hub. Fixed an issue where a double sign-in would occur if your initial setting timed out. Fixed an issue where a report containing a pivot table would throw an exception when run in the Jet Hub. Fixed an issue where the last drop-down in the data sources page would open out of view. Fixed an issue where 'New Data Source' was displayed when only editing a data source. Fixed an issue where reports with Pivot tables would become corrupted when ran through the Jet Hub. Fixed an issue where no warning was displayed when SMTP was not setup on a scheduled task. Fixed an issue where responding on a sent invite would generate an uninformative error. Fixed an issue where using a C/Front-based data source for budget creation would generate an error. Fixed an issue where selecting a data source type during creation did not enable the connection method drop down list. Fixed an issue where a “no records“ error was shown briefly when loading data. Fixed an issue where a duplicate “pending changes” error was displayed when navigating tabs.

Excel Add-In Added new icons for the JetMessage dialog boxes. Fixed an issue where Business Central data sources were still selectable when disabled in the combo box list. Fixed an issue where importing a favorites list would produce an error. Fixed an issue where unlicensed data types were not grayed out. Fixed an issue where pressing 'tab' had inconsistent performance when using the Browser with a Dynamics NAV data source. Fixed an issue with the screen display of the Snippets icon. Fixed an issue where cancelling the OAuth page would generate an exception. Fixed an issue where a pivot table in cell ‘A1’ would generate an error. Fixed an issue where no reference to Office 365 account error would be shown in the settings after login. Fixed an issue where selecting ‘New Worksheet’ would insert a table in cell ‘A1’. Fixed an issue where an error message was shown when opening the Jet License Activation window. Fixed an issue where a generic error was displayed when a user chose windows Auth in an Azure Active Directory set up. Fixed an issue where the Snippets window did not have the updated styling. Fixed an issue where toggling the master favorites automatically deselects all fields. Fixed an issue where scrolling up the report wizard list would deselect previously selected fields. Fixed an issue where adding a new folder/snippet in the Snippets window would generate an exception. Fixed an issue where selected text in the Fast Financials window would turn all text white. Fixed an issue where Report Wizard filter selection would generate an exception.

Jet Budgets Fixed an issue where some fields in work Item creation would go past the display bounds of the browser. Fixed an issue where work items using online entry would not save budget numbers. Fixed an issue where users could not scroll horizontally on budget overview.

Jet Dashboard Builder Fixed an issue where the dashboard builder provided an uninformative error when the license failed to validate. Fixed an issue where the application settings window would appear every time the Dashboard Builder was launched.

Jet Installer Added windows icons in installer to match our new brand. Fixed an issue where JetReports.exe was not removed when Jet Reports is uninstalled Fixed an issue where the Jet Service Tier was not reading the activation code from the registry. Fixed an issue where multiple errors were generated if the Jet Services database is being used by another process upon installation. Fixed an issue where Jet Service Tier binding certificate would log to a temp file. Fixed an issue where a database user could be added on install even if the user already exists. Fixed an issue where the SSL certificate would not persist on upgrade.

Export to Word Added ability to generate a Word Document when still in design mode. Fixed an issue where a red box was visible around a named range after the issue was already resolved. Fixed an issue where the Configure Work Export window initialized off screen on some high resolution devices. Fixed an issue where errors would not clear after they have been resolved.

Jet Reports 2019 R2 Build 20.0.19116.1

April 29, 2019

Initial release of Jet Reports 2019 R2

Jet Browser Update

Continuing with efforts to bring all the Jet add-in features in line with a consistent look as well as providing intuitive and easy to use interactions, the interface for the Jet Browser tool has been updated.

Updated Pivot Tables for OLAP Cubes

Jet 2019 R2 includes an updated user interface for creating Pivot Tables from OLAP cubes .  This includes is a more consistent visual design and better navigation to walk you through creating and inserting your Pivot Table

OLAP Cubes in Azure Analysis Services

Another area updated in Jet 2019 R2 is added support for OLAP cubes residing in Azure Analysis Services .

Business Central (on premises)

With Jet 2019 R2, we continue to extend functionality to increasingly support more features and deployment options for Dynamics 365 Business Central.  We've now included support for on-premises Business Central installations.

Office 365 Authentication

Jet 2019 R2 provides the ability to sign in to Jet Hub, as well as the Excel add-in, using Office 365 (or Azure Active Directory ) account credentials.

MS Word Integration

Jet is excited to include integration with Microsoft Word in Jet 2019 R2.  This new feature will give you a faster and easier way to generate Microsoft Word documents using Jet data.  A great time-saver for producing executive reports, financial statements, cover sheets, invoices, and billing statements.  No more cutting and pasting errors!

Jet Hub Redesign

Jet 2019 R2 includes several requested improvements to the user interface of Jet Hub , which incorporate an intuitive design and improved navigation to make managing reports and folders more efficient.
User Administration in Jet Hub In our effort to reduce the number of applications required to use and support Jet Reports, Jet 2019 R2 adds the ability to create and manage users and groups directly in Jet Hub.
Data Source Administration in Jet Hub In addition to being able to administer user and groups within Jet Hub, Jet 2019 R2 includes the ability to create and manage data sources in Jet Hub.
Jet Budgets Usability Improvements

Based on feedback, several interface and functionality improvements have been made to help Jet Budgets users get the most from their Budget process.

Copying a budget now includes e-mail reminders and the ability to add new dimensions.  Saving and submitting numbers for approval can now be done from Excel.  Formulas can now be saved when using Excel Online for data entry. Configuring reminders is now more intuitive, and zeros and blanks are no longer preserved in budget entries.

Jet Reports 2019 Build 19.8.19072.1

March 18, 2019

Changes since 19.7.19044.1

Excel Add-In Fixed an issue where in some cases batch execution optimization would throw an error.

Jet Budgets Fixed an issue where uploading a budget had slow performance. Fixed an issue where G/L accounts would fail to load when using excessive totaling accounts. Fixed an issue where the account structure for Spanish databases would have incorrect indentation. Fixed an issue where a budget that is saved without numbers did not save the entire form.

Jet Reports 2019 Build 19.7.19044.1

February 25, 2019

Changes since 19.6.19018.1

Jet Hub Fixed an issue where a local system user could not create a scheduled task. Fixed an issue where a user's email was being updated when a group with the same ID was updated.

Excel Add-In Fixed an issue where Lookups with nested arrays occasionally failed to load data. Fixed an issue where a custom FlowField in a NAV 2018 extension would fail to work. Fixed an issue in the Browser where un-favoriting a field would also un-favorite a table. Fixed an issue in the Browser where un-favoriting a field would deselect non-favorited fields from other tables. Fixed an issue in the Browser where favoriting a field and proceeding to select a different field would produce invalid information. Fixed an issue where loading a field from an extension with a duplicate key would produce an error when querying tables and fields. Fixed an issue in the Browser where having Favorites enabled would still show all of the fields. Fixed an issue where a user could not highlight the license tab within the application settings.

Jet Reports Financials Fixed an issue where Jet Reports Financials would not prompt for a new sign-in after a user changed their password on the Business Central tenant.

Jet Budgets Fixed an issue where uploading a Budget work item would not translate the 'save message' content.

Jet Reports 2019 Build 19.6.19018.1

February 4, 2019

Changes since 19.5.19011.1

Jet Budgets

Fixed an issue where budget numbers were occasionally not saved to the server when using an Excel entry. Fixed an issue where changes made to an approver to a work item did not appear in the overview after approval.

Jet Hub Fixed an issue where canceling a bulk of report uploads would periodically not work properly. Fixed an issue where changing a scheduled task owner from a domain user to a local user profile would throw an error.

Background Reporting Fixed an issue where report options within a report would generate an exception when run contextually.

Excel Add-In The Jet Browser now shows all fields in a favorite table when no fields from that table have been favorited. Fixed an issue where the scheduler window would re-size on high resolution devices. Fixed an issue where the Report Wizard would add a data source filter for the default data source. Fixed an issue where cell references that are manually entered are created as relative ranges instead of absolute ranges. Fixed an issue where excel would occasionally crash when batch function execution was enabled while running reports. Fixed an issue where table builder formulas were not working as expected. Fixed an issue where a web service data source would generate an error with the latest Jet Business Objects in NAV 2017/2018.

Jet Reports 2019 Build 19.5.19011.1

January 14, 2019

Changes since 19.4.18353.1

Jet Budgets

Fixed an issue in Jet Budgets where a budget owner would not receive an email notification when renaming a work item. Fixed an issue in Jet Budgets where saving values to a budget that produces an error would sometimes lock Excel. Fixed an issue in reminders where dismissing an error message would dismiss all other error messages. Fixed an issue where dimensions with large numbers of values could not be added as a "Split by Dimension". Fixed an issue where budget dimensions with codes beginning with numbers or special characters could not be used in "Split by Dimension"..

Jet Hub Fixed an issue where workbooks with multiple sheets would sometimes fail to replicate properly. Fixed an issue where attempting to add a local domain group would sometimes show an unrelated error message. Fixed an issue where clicking "Continue" on the session timeout dialog could sometimes till result in the user being logged out. Fixed an issue where wildcard characters were not supported in the Search function. Fixed an issue where running a report containing the =VLookup Excel function would cause #REF! to appear in cells. Fixed an issue where uploading reports that contain #REF! would cause an error to occur. Fixed an issue where TinyInt fields from Data Warehouse data sources would produce errors.

Background Reporting Fixed an issue where new workbooks would sometimes switch into report mode after running in the background and then opening the Jfx.

Excel Add-In Fixed an issue where data could not be retrieved from a server where TLS 1.2 was enabled. Fixed an issue where the group page of the Report Wizard did not resize correctly. Fixed an issue where formulas added to the Table Builder that contain Jet functions were not being converted properly to values. Fixed an issue where pivot tables were sometimes not updating correctly unless they were manually refreshed. Fixed an issue where NL(Sheets) would sometimes exhibit poor performance, causing unexpected behavior within Excel. Fixed an issue where the licensing window contained gray text. Fixed an issue where minimizing the "insert Named Range" window from the Jfx would sometimes force the user to close Excel in order to use it. Fixed an issue in the Report Wizard where using "Select All" would remain active when switching tables within the same data source. Fixed an issue where stored user data would sometimes evaluate incorrectly. Fixed an issue in the Report Wizard where selecting the Total Page after changing the table would leave the Report Wizard in an unusable state. Fixed an issue where cancelling some running reports would activate a random worksheet in the workbook. Fixed an issue where a scheduled report would fail if it contained a Pivot Table that is set to "Refresh data when opening the file". Fixed an issue where some reports containing #REF! would never complete. Fixed an issue where Business Central data sources would sometimes return bad data when Batch Function Optimization is enabled. Fixed an issue where some reports would return #VALUE! cells when run against NAV SQL data sources in certain circumstances Fixed an issue where the installer would sometimes exit with a SQL error when configuring the Jet Services database.

Jet Dashboard Builder Fixed an issue where Dutch translations were incorrect for relative dates. Fixed an issue with some Japanese translations in some areas of the Dashboard Builder.

Jet Reports 2019 Build 19.4.18353.1

January 2, 2019

Changes since 19.3.18339.1

Jet Hub Fixed an issue where uploading a large report to Jet Hub would constantly make the page to refresh. Fixed an issue where the search function in Jet Hub would not return the correct values. Fixed an issue where SMTP emails could not be sent under certain SSL configurations.

Background Reporting Fixed an issue where the run-times were cut off in the background reporting tray application. Fixed an issue where an error window was opened behind the report options window blocking user interaction. Fixed an issue where the 'View Error' text would be cut-off if an error is caught.

Excel Add-In Fixed an issue where Jet Functions wrapped in Excel functions would not convert to values. Fixed an issue where running reports with the batch execution turned off would cause some cells to #VALUE!. Fixed an issue where inserting a second named range in the Jfx window would generate a null value exception. Fixed an issue where opening and closing Fast Financials quickly would throw an error message. Fixed an issue where selecting the 'Fields' tab in the Report Wizard would not change the contents of the page. Fixed an issue where selecting an invalid data source would allow the selection of a previous data source field. Fixed an issue where canceling a report as a 'Viewer' would move the report into a partial 'Design' mode. Fixed an issue where the Report Wizard would create an invalid report for tables that do not contain a primary key. Fixed an issue where the XLL add-in would not load when the System time format is set to English(Switzerland). Fixed an issue where the GL function with an 'Exclude Close = True' would not work with UK Dynamics NAV databases. Fixed an issue where loading an extension table would cause a duplicate key error. Fixed an issue where the Report Wizard would not work with Cube data sources. Fixed an issue where NL(Table) functions would not expand the results on alternative runs when run in 'Report Mode'. Fixed an issue where the first column returned from an NL(Table) would be named ' 0'.

Jet Administration Console Fixed an issue where an unnecessary Tool Tip was in the header.

Jet Reports 2019 Build 19.3.18339.1

December 6, 2018

Changes since 19.2.18311.1

Jet Installer Fixed an issue where upgrading from Jet Reports Financials to Jet Reports will not select the correct code units.

Jet Budgets Fixed an issue where calendar selected will default to the initially selected date. Fixed an issue where an error is displayed when deleting a Budget reminder. Fixed an issue where submitting a work item error will show in the incorrect area initially. Fixed an issue where large budget item numbers are totaling with the incorrect format. Fixed an issue where a budget Owner will receive an email notification when un-submitting a self assigned item.

Jet Hub Fixed an issue where the invalid credential error message is not displayed for some contents in the scheduler. Fixed an issue where there is no option to re-authenticate a scheduled task. Fixed an issue where data source settings in Jet Hub are not interactive. Fixed an issue where a user cannot create new scheduled tasks. Fixed an issue where the Norwegian language was not displayed as a Jet Hub language option.

Background Reporting Fixed an issue where background reporting does not work for consecutive users on a terminal server.

Excel Add-In Fixed an issue where opening a CSV file will produce an error and disable the Jet AddIn while an excel session is open. Fixed an issue where field selection is disabled after opening the Report Wizard with an invalid data source. Fixed an issue where invalid #Ref! is returned when moving to design mode after running a report that contains a NL(Table) and Fast financials data. Fixed an issue where functions with date filters will produce errors for reports using Business Central data sources. Fixed an issue where canceling a report run during row expansion will bring back bad data. Fixed an issue where the favorites icon is not visible in the browser. Fixed an issue where successfully changing between cube data sources will display an error. Fixed an issue where Report Wizard does not sort correctly. Fixed an issue where the Options and progress window do not appear for a some Excel 2016 users. Fixed an issue where the GL function in Hungarian returns #Name!. Fixed an issue where the Drilldown against a web service data source into a Jet Data Grid will produce an error upon scrolling. Fixed an issue where the JFX button will force close Excel after closing out of the data source settings window. Fixed an issue where Nav SQL data source cannot connect to Nav 2018

Dashboard Builder Fixed an issue where an error is thrown when switching between tabs with a slicer that returns no data. Fixed an issue where slicer data will be cleared when every item is selected.

Jet Reports 2019 Build 19.2.18311.1

November 12, 2018

Changes since 19.1.18296.2

Jet Installer Fixed an issue where Active Directory queries can throw exceptions for users in certain domain configurations. Fixed an issue where installation will fail on a non-domain connected machine.

Jet Service Tier Fixed an issue where the initial Jet Service Tier authentication is slow.

Jet Budgets Fixed an issue where an incorrect 'Last Modified Date' may be displayed in the Budget drill down. Fixed an issue where an error message is displayed after closing an assignment entry form during the send assignment process. Fixed an issue where the Budget help link directs the user to the generic Jet Hub support page. Fixed an issue where some fields will not be displayed correctly on budget/Work Item screens for users with the Microsoft Edge web browser. Fixed an issue where clicking on 'Save in Budget' will move the current window behind Excel and to the foreground. Fixed an issue where the Work Item count in the details panel for Sections does not update. Fixed an issue where the 'Last Submission' field in the work item details panel is always in UTC time. Fixed an issue where a budget owner is not able to open Budgets in Excel that are pending approval. Fixed an issue where marking a Jet Budget excel file as owner will make the contributor receive a File not found error. Fixed an issue where a long budget description will throw an error. Fixed an issue where date formats are showing incorrectly when previewing a Budget Work Item. Fixed an issue where no data validation exists when using Copy-Paste in an online work item data entry form.

Jet Hub Fixed an issue where an error message is not shown in Jet Hub if an unsupported Excel function is used. Fixed an issue where opening a large report in OneDrive For Business will fail. Fixed an issue where no error would display if a large report fails to upload. Fixed an issue where not enough information was shared when running a report that uses an incorrect Excel function. Fixed an issue where an error message does not inform the user that a non-supported Excel function was used. Fixed an issue where a report that uploaded with an error can then be run by the user. Fixed an issue where a Report will produce #N/A because a string is not being interpreted as a date properly. Fixed an issue where a user will be directed back to the login page when clicking on the 'Report List' button after being logged out for inactivity. Fixed an issue where the Excel function '=LOOKUP()' will produce #N/A on the report if run through Jet Hub. Fixed an issue in Microsoft Edge where some fields will not be displayed correctly on Budget/Work Item screens. Fixed an issue where the Date picker is missing the current date selection. Fixed an issue where clicking on 'Back to Reports List' navigates you to the scheduled task details and not the folder you were previously at. Fixed an issue where the fill color of a cell is not persisting in the report after being run in Jet Hub. Fixed an issue where a cell will return #N/A when a excel '=MATCH()' function is used. Fixed an issue where the upload icon in the header is overlapping the change view buttons.

Background Reporting Fixed an issue where background reporting with a Dynamics Nav data source will ignore 'Company=' filters.

Excel Add-In Fixed an issue where 'What' drop down in the Jfx window displayed the incorrect GL Balance description. Fixed an issue where text gets distorted when dragging an item from the Report Wizard. Fixed an issue where the 'X' is not displayed in the Report Wizard drop down window. Fixed an issue where a field cannot be unchecked after a user performs 'Select-All' in the report wizard. Fixed an issue where an NL function will not calculate if the CalcFormula is too long. Fixed an issue where the Jfx window is taking much longer to open than previous versions. Fixed an issue where the Format Options are not reset after a user changes the Data Source, Company or Table. Fixed an issue where field selection using the keyboard will not indicate if you have selected all the items in the Report Wizard field list. Fixed an issue where switching the data source upon launch of the Report Wizard will disable the ability to select fields. Fixed an issue where the GL(JetBudget) function runs very slow. Fixed an issue where a report with +Values, a Jet Function, and column and sheet replication will throw an error after running. Fixed an issue where Jet is unable to evaluate functions in certain languages. Fixed an issue where closing and opening Fast Financials will throw an error. Fixed an issue where the "What" drop down in the Jfx window displays the incorrect GL Balance description.

Dashboard Builder Fixed an issue where changing filters will grey out all visual 'OK' buttons. Fixed an issue where the Dark Theme contains white text and a white background in the data grid.

Jet Reports 2019 Build 19.1.18296.2

October 26, 2018

Changes since 19.1.18289.1

Jet Hub Fixed an issue where the button to install the Jet Reports Excel add-in would not be placed in the correct location.

Excel add-in Fixed an issue where viewers were unable to use the drilldown feature.

October 22, 2018

Changes since 19.0.18268.1

Jet Administration Console Fixed an issue where an unwanted underscore is seen when creating a personal data source in the Jet Administration Console. Fixed an issue where multiple users are allowed to be selected as data source owners.

Jet Reports Installer Fixed an issue where Jet Reports Financials could be installed on top of Jet Reports, this prevented users from activating Jet Reports. Fixed an issue where Jet Reports does not activate from the installer even when given the activation code.

Jet Reports Financials Fixed an issue where the default Nav data source web service code unit name is invalid. Fixed an issue where a data source is not provisioned after a successful O365 sign in.

Jet Hub Fixed and issue where changing the name of a Cube will cause the Dashboard to disappear. Fixed and issue where clicking 'Report List' will take you back to the root folder as opposed to your previous folder. Fixed an issue where dates were changed to a 'general' format in the Report options window. Fixed an issue where an incorrect error message is displayed when uploading a report while having no data sources defined. Fixed an issue where an error message is thrown when an unexpected char is used when adding a User/Group in Jet Hub. Fixed an issue where our autocomplete feature is inaccurate when adding a User/Group in Jet Hub. Fixed an issue where clicking 'Report List' in the details pane does not take you back to your previous page. Fixed an issue where some languages were missing translations on the permissions page. Fixed an issue where there is an incorrect translation for "New Work Item". Fixed an issue where an empty error message is shown when attempting to sign into Jet Hub with a user that is assigned to a Budget but not added in the Jet Administration Console. Fixed an issue where the Report sharing 'Help' window displays an unwanted interactive check box. Fixed an issue where the 'OK' button in the report sharing window is not activate if the "Share with Everyone" icon is selected but no users are added in the Jet Administration Console. Fixed an issue where the user can see a highlight of a lookup button in the Report Option window even if no lookup was defined. Fixed an issue where large user names are not displayed in the Add Users/Groups window. Fixed an issue where the sort functionality on the security column in the administration page sorts users in the opposite order. Fixed an issue where adding Users/Groups in Jet Hub does not populate the users information in the staging window. Fixed an issue where no warning is issued when attempting to add a duplicate user. Fixed an issue where users deleted from Jet Hub are not removed from their assigned Jet Budget or shared Reports. Fixed an issue where data source names were cut off on the data source page. Fixed an issue where not all text is translated on the login page. Fixed an issue where a timeout error was displayed when an invalid username is used to login. Fixed an issue where NL(Lookup) functions against cube data sources do not work if using a language caption for the Cube name. Fixed an issue where an empty contextual menu will partially hide the run history page. Fixed an issue where no loading spinner is visible when navigating from the information window to run history and report details. Fixed an issue where a user cannot rename reports or folders within the tile view. Fixed an issue where the loading spinner is cut off on the data sources page. Fixed an issue where authorizing a Business Central data source by clicking the GoLink does not propagate a new window. Fixed an issue where User Groups without a full name are displayed as an empty string when adding a new group in Jet Hub. Fixed an issue where a user can double click 'Add Comment' and it will add a duplicate of the same comment. Fixed an issue where multiple confirmation messages are sent when only one invitation was sent. Fixed an issue where Jet Hub welcome email displays the username and not the user's full name. Fixed an issue where a report option value is being overlapped by the report option title field. Fixed an issue where searching for local users in the Admin section of Jet Hub does not work as suspected. Fixed an issue where no every user who is invited to Jet Hub will receive the invitation. Fixed an issue where logging in to Jet Hub with a user that is not in the Jet Services database will throw an ambiguous message. Fixed an issue where the loading spinner is displayed in the background while adding users. Fixed an issue where running a report that has an incorrect conditional formatting rule will corrupt the workbook.

Jet Budgets Fixed an issue where the Budget spreadsheet preview allows text to be entered when entering dimensions. Fixed an issue where the Calendar's user notifications are not in the correct layout. Fixed an issue where the Jet Budget Grid paging is not reset when navigating between Users, Work Items and Templates. Fixed an issue where searching for users within a budget works differently for Admin and non-admin users. Fixed an issue where the template name is cut off in the drop down when creating a new Work Item. Fixed an issue where users that were deleted from the Jet Administration Console can still be added as budget users. Fixed an issue where the Work Items overview window had improper column padding. Fixed an issue where an error message is displayed on the dialog page when creating a budget with no data sources defined. Fixed an issue where a budgeting contributor should be able to submit a budget from the preview pane. Fixed an issue where the 'Save' and 'Resend' buttons are active on a Work Item when no changes were made. Fixed an issue where a deadline is filled out for a self assigned Budget. Fixed an issue where a Budget approver is not notified when he is removed an approver. Fixed an issue where the old product name is displayed when sending numbers from excel to the budget. Fixed an issue where the Jet Budget will show a successful Budget upload after a Budget Work Item upload was cancelled. Fixed an issue where renaming a Work Item will not be reflected in the downloaded file. Fixed an issue where deleting a user from a Jet Budget will not notify the user. Fixed an issue where a notification should be displayed when attempting to copy a Budget without having access to that Budget's data source. Fixed an issue where budget allocation should also show for edited work items in excel. Fixed an issue where if a user is removed from a Budget that is in the state of pending approval the Budget will remain in that state. Fixed an issue where an error is thrown when exceeding the Budget instructions character limit. Fixed an issue where the Budget owner shouldn't be allowed to send unassigned work items. Fixed an issue where Budget submission comments are not limited in length. Fixed an issue where Budget column names differ from column selection menu names. Fixed an issue where a Budget owner will receive an email of their own 'Approval' or 'Un-Approval'. Fixed an issue where a new Budget owner with no access to a data source no dimensions or accounts will display when creating a new work item. Fixed an issue where the 'Days' text box allows special characters. Fixed an issue where a Budget email template should not update changes made when its first sent out. Fixed an issue where there were inconsistencies in a users names included in the Budget emails. Fixed an issue where no comment is documented if a Budget contributor is also the approver. Fixed an issue where changing Budget ownership will throw an error if smtp is not setup. Fixed an issue where no tool tip is displayed on the Budget overview page. Fixed an issue where a work item does not get approved when the approver clicks 'Approve' after making changes. Fixed an issue where a Budget reminder email is labeled as from the Budget owner and not the contributor who made the changes. Fixed an issue where the user cannot select a new Budget owner in changing ownership. Fixed an issue where a Budget excel file formatting will be offset when assigned to a user with no Budget allocation. Fixed an issue where a Budget owner can send a work item without assigning a contributor and approver. Fixed an issue where Budget reminders are not being sent if the budget owner's email is not known. Fixed an issue where double clicking a dimension when creating a work item will add it twice. Fixed an issue where approving a Budget as a contributor from the online entry window will not move the status to 'Approved'. Fixed an issue where the 'Save and Submit' button does not appear after creating a new Work Item. Fixed an issue where clicking 'Save and Submit' will not submit any unsaved changes.

Excel Add-In Fixed an issue where old values persisted in the JFX after editing a nested function. Fixed an issue where an exception is thrown when a cell formula exceeds what excel allows to be in a formula property. Fixed an issue where the 'Send to Budget' icon is not the correct color of Grey. Fixed an issue where the excel window will lose focus after "Sending to Budget". Fixed an issue where data source and company drop downs in the report wizard are still enabled when only one data source exists. Fixed an issue where a 'Favorited' item is not removed from the list. Fixed an issue where in the 'Review and Finish' pane of the Report Wizard lists are displayed concatenated. Fixed an issue where the 'Select All' feature un-checks itself when navigating between sections. Fixed an issue where changing a nested function deletes your main function. Fixed an issue where the main report wizard window can be minimized. Fixed an issue where Jet was not detecting Nav extension tables correctly for Web Service data sources. Fixed an issue where the table drop down in the report wizard will show a blank placeholder text when changing the data source or company. Fixed an issue where selecting a list item in the report wizard with the key board, the type to search no longer function. Fixed an issue where running a report that was generated through the report wizard returns invalid values. Fixed an issue where running a report with an invalid function will toggle the current workbook to the background. Fixed an issue where an Analytics universal data source will throw an exception when NL(Table) function is run. Fixed an issue where '+Values' is added to new sheets when the other sheets already contain Auto+Hide. Fixed an issue where adding a filter in the report wizard will cause column headers to be misplaced. Fixed an issue where only top-level reports can be selected upon report upload. Fixed an issue where changing the data source in the report wizard the table from the previous data source will remain selected. Fixed an issue where the report wizard creates a broken anchor row for replication when the report is generated. Fixed an issue where selecting too many fields using a GP data source will cause the text to no longer wrap on the finish page. Fixed an issue where providing invalid data source credentials will prevent the browser from functioning on another data source. Fixed an issue where Jet cannot run NL functions with multiple embedded functions. Fixed an issue where no error message is displayed when attempting to submit an invalid budget number. Fixed an issue where running a Fast Financials report with an NL(Table) will throw a null reference error. Fixed an issue where the report wizard will throw an error if a users Jet Data Warehouse data source is not setup correctly. Fixed an issue where the report wizard will show tables from the default data source after changing to a newly create Jet Data Warehouse data source. Fixed an issue where the Browser window will be blank if using a a data source that is incomplete, a message will now be displayed. Fixed an issue where an error is thrown when cancelling a Business Central login request. Fixed an issue where unnecessary worksheet searching was causing a slowed performance. Fixed an issue where non batched Jet functions on worksheets that do not contain an NL(Table) are not converted to values. Fixed an issue where opening a report with a Nav Web Services data source will crash Excel. Fixed an issue where Office 2010 does not display the report progress window or report run times. Fixed an issue where a report throws an exception if run against a Nav Web Service data source. Fixed an issue where if one data source cant connect then the data sources drop down in the browser will be empty. Fixed an issue where '+Values' will cause an empty cell to be converted to 0 on 'Run'. Fixed an issue where loading dimension values in a Cube data source caused a report to show the correct values only after the second run.

GP Update Utility Fixed an issue where running the utility against a database that already has some of the components will produce an error.

Jet Reports 2019 Build 19.0.18268.1

October 1, 2018

Initial release of Jet Reports 2019

Improved Performance with XLL Multi-threaded Add-in

The Jet Excel add-in is now based on the Excel’s XLL format.  This provides several benefits - including a performance boost , with some reports running up to 5 times faster.

new10.png

Business Central Data Source Connection

Dynamics 365 Business Central users can connect Jet Reports directly to their Business Central data base.  Each user can use their Office 365 credentials to make their connection.

new01.png

Simulate Jet Reports Financials within your Jet Reports Excel add-in

For those Business Central customers and partners needing to support both Jet Reports and Jet Reports Financials , a new simulation mode has been added to Jet Reports to allow you to use the full Excel add-in as through it were an installation of Jet Reports Financials.

new03.png

Updated Report Wizard

Continuing with efforts to bring all the Jet add-in features in line with a consistent look as well as providing intuitive and easy to use interactions, the interface for the Report Wizard tool has been updated.

new09.png

Update Notification when a new version of Jet Reports is available

A new notification button has been added to the Jet ribbon to let users know when a new version of the Excel add-in is available.

new04.png

+VALUES automatically added to reports

When running a new Jet report for the first time, in addition to Auto+Hide, +Values will now be added to cell A1.  This has been a popular request in our ideas portal.

new02.png

The Jet Services Database is Backed Up during Upgrade

The Jet Reports installation program now includes the option to backup the existing Jet Service Tier database prior to updating or replacing it as part of the installation process.

new08.png

Jet Hub has received a new look and new features

Jet Hub features a new look (along with a new name).

The new App Switcher allows you to quickly navigate between the applications in Jet Hub.

new05.png

Updates Emails when Adding Users to Jet Hub

When adding new users in Jet Hub, you can now provide an email address for each user.  There is also an option to edit the email address for existing users.  This information is used for sending invites to log into Jet Hub and for notifications in the Jet Budgets application

new06.png

Assign Data Source Permissions to User and Groups within Jet Hub

After defining data sources within the Jet Administration Console, you can now give users and groups permissions to those data sources from the Admin section of Jet Hub

new07.png

Support for Excel's WORKDAY.INTL function

Excel's WORKDAY.INTL function is now supported in the Jet Reports that you run within Jet Hub.

Jet Professional 2018 R2 Build 18.5.18215.2

Aug 6, 2018

Changes since 18.4.18186.3

Excel Add-In Fixed an issue where access database data source does not support sub query evaluation. Fixed an issue where date flow fields with Min and Max calc formulas do not work in NAV SQL or Remote Service Data Sources. Fixed an issue where running a report with batch execution turned on will return #VALUE! throughout the report. Fixed an issue where empty filter field displays the Info-Warning only in English. Fixed an issue where Fast Financials instructions only appeared in English. Fixed an issue where the workbook save warning only appeared in English.

Jet Web Portal Fixed an issue where the default sort of folders was random. Fixed an issue where in some languages, field names are cut off or do not fit on the page. Fixed an issue where an invalid error message is thrown when adding users in the Jet Web Portal.

Jet Professional 2018 R2 Build 18.4.18186.3

July 16, 2018

Changes since 18.3.18165.4

Excel Add-In Fixed an issue where some captions for "OK" buttons in Japanese contained brackets.

Jet Web Portal Fixed an issue where certain large reports would sometimes not upload from the Jet Web Portal. Fixed an issue where reports containing NL(Picture) functions referencing local file paths would return a confusing error message. Fixed messaging displayed when SMTP settings were not configured. Fixed an issue where the dialog used to update a user's email address would not load with the cursor focus set to the email address field. Fixed messaging in the scheduler regarding authenticating a scheduled task. Fixed an issue where adding users with a domain that contains "." would truncate that domain value. Fixed an issue where page styling would become inconsistent after using the report options lookup feature. Fixed an issue where reports uploaded that are too large in size would not cause an error as expected. Fixed an issue where the back button in the report details pane would not correctly return the user to the list of reports. Fixed an issue where pasting text into required fields of "New" dialog windows would not correctly enable the "Create" button. Added missing translations for welcome message. Fixed an issue where choosing to cancel a report lookup option would cause the settings menu to no longer open. Fixed an issue where navigating away from a scheduled task that contains pending changes would sometimes not prompt to save. Fixed an issue where adding an existing report to a scheduled task would sometimes disable the ability to edit the report options.

Dashboard Builder Fixed an issue where text that is unable to fit within the confines of a button was being cut off.

Jet Professional 2018 R2 Build 18.3.18165.4

June 25, 2018

Changes since 18.1.18149.1

Excel Add-In Fixed an issue to provide a more informative error message when an incorrect server is entered within the Jet License Activation window Fixed an issue where dimension value filters were case sensitive within GL(Budget) functions. Fixed an issue when running reports with a Czech language pack in Excel would display an exception error message.

Jet Web Portal Fixed an issue to limit the length of folder names to 256 characters. Fixed an issue where the 'clear filters' button within a dashboard slicer was not labeled. Fixed an issue where grabbing a dashboard slicer tab would drag the whole visual within the Jet Web Portal. Fixed an issue where adding a group to the Jet Web Portal would occasionally invite a user outside of the invited group. Fixed an issue where the Jet Web Portal would not display an error message when an incorrect password was used during the creation of a scheduled task. Fixed an issue to rephrase the error message displayed when a scheduled task attempts to send an email with incorrect email settings or the task credentials are invalid.

Background Reporting Fixed an issue where monitors with higher scaling percentages would move the tray application off of the screen. Fixed an issue where running a report with report options from a device with a high screen resolution forces the tray app off of the visible screen.

Dashboard Builder Fixed an issue where adjusting a range slicer would freeze the dashboard to the newly specified range.

Admin Console Fixed an issue where saving a change within the Jet Administration Console would revert a user's email address back to the email that is associated with that user in the Active Directory.

Jet Professional 2018 R2 Build 18.1.18149.1

June 4, 2018

Changes since 18.1.18137.5

Excel Add-In Fixed an issue where look-ups for dates, segments, and segment values were not correctly showing localized names. Fixed an issue where dates returned from a GL() function would not be formatted correctly. Fixed an issue where using Windows authentication for a NAV SQL direct data source would not behave as expected. Fixed an issue where the report drop-down within the Upload Report window would not scroll correctly through the list of reports.

Jet Web Portal Fixed an issue where using Windows authentication for a NAV SQL direct data source would not behave as expected. Fixed an issue where all dashboards would fail to load when the user did not have permissions to one of the dashboard's supporting cubes. Fixed an issue where data source look-ups in report options would not work as expected after upgrading to a new version of the Jet Web Portal. Fixed an issue where some reports containing custom modules would not upload to the Jet Web Portal. Fixed an issue where uploaded reports containing macros would sometimes become corrupted when run. Fixed an issue where reports run in the Jet Web Portal containing an NL(Sheets) function would result in a corrupted workbook. Fixed an issue where NL(Filter) functions that contain a blank value in the results would sometimes cause an error to occur. Fixed an issue where the "User Name" field would sometimes read as "Usename" upon sign-in. Fixed an issue where the right-click context menu would sometimes not appear as expected after navigating to a folder. Fixed an issue where reports with a longer than usual description would sometimes cause errors to occur and cause the report to become inaccessible. Fixed an issue where lookup dates were not being displayed in the correct format. Fixed an issue where downloading a report with a "." in the file name would remove the Excel extension of "xlsx". Fixed an issue where an empty error was being shown when uploading a report when no data sources have been configured. Fixed an issue where navigating to a non-existent report would not fail with a useful error message. Fixed an issue where users configured via Groups would be unable to upload reports from the Excel add-in. Fixed an issue where reports containing "+Lock" would not be protected as expected. Fixed an issue where report options that are changed before running a report would revert the report options to their original values.

Background Reporting Fixed an issue where dates from cube data sources were not being properly formatted.

Installer Fixed an issue when installing Jet Professional where a Jet Service Tier host configuration that contains a "\" would cause Excel to report an error when launched.

Jet Professional 2018 R2 Build 18.1.18137.5

May 21, 2018

Changes since 18.1.18101.2

Excel Add-In Fixed an issue where sorting in the report options window was not functioning as expected. Fixed an issue where a confusing error message would be displayed when an empty filter was not allowed in a Jet function. Fixed an issue where the Jet Database Caption Editor would fail when connected to the Jet Service Tier. Fixed an issue where the Activate Jet Professional button could be hidden from the ribbon in Jet Express. Fixed an issue where clicking the function drop-down inside the Jfx Window while editing a report option lookup would sometimes cause an error to occur. Fixed an issue with batch function optimization where functions referencing relative named ranges would not be included in the batch. Fixed an issue where Excel 2010 would produce a cryptic error message when auto-debugging #VALUE! cells. Fixed an issue where connecting to Jet Service Tier versions 18.0 or earlier would cause errors to occur when using the Jfx. Fixed an issue where Table Builder templates were available to Jet Express users. Fixed an issue where Fast Financials would not function as expected while using languages that have report option names with illegal named range characters. Fixed an issue where pressing F8 within the Jfx window when no report options exist would cause an error to occur. Fixed several layout issues when using languages with messaging that is longer than English messaging. Fixed an issue with batch function optimization where #VALUE! cells would appear with function tables array. Fixed several usability issues within the Fast Financials window. Fixed an issue where an error would occur when attempting to upload a report from their OneDrive rather than a descriptive message.

Jet Web Portal Fixed an issue where reports and folders would sometimes be unable to be de-selected. Fixed an issue where a report downloaded from the Jet Web Portal could not be uploaded by another user. Fixed an layout issue in the "Create New Folder" window. Fixed a layout issue in the search box where text would sometimes overlay the "X" used to clear the search. Fixed an issue where non-English locales would sometimes display a login error message in English. Fixed an issue where non-English locales would display a session timeout message in English. Fixed an issue where a session timeout would result in the display of an unrelated string error message. Fixed an issue where the report details page was not updating correctly when the report was running. Fixed an issue where an object reference error would be mistakenly displayed after a session time out or log out. Fixed an issue where reports containing the EOMONTH() function was not evaluating correctly within reports run in the Jet Web Portal. Fixed an issue where some reports fun in the Jet Web Portal would end up being corrupted. Fixed an issue where some report option lookup values were not displaying correctly.

Background Reporting Fixed an issue where uninstalling Jet Professional would fail if the background reporting tray application was open. Fixed the messaging when closing a report for background reporting. Fixed an issue where closing the background reporting application would sometimes cause an error to be displayed. Fixed an issue where opening a report in background reporting while a different report is running would sometimes not function as expected. Fixed an issue where the background reporting application could not be exited while reports are running. Fixed an issue where cancelling reports running in the background would sometimes cause the report to remain in read-only mode.

Jet Professional 2018 R2 Build 18.1.18101.2

April 19, 2018

Initial Release of Jet Professional 2018 R2

Run Reports directly from your Windows Desktop

Run your reports without even starting Excel!  Just right-click.  The new task tray app will let you know when your report is ready.

Run Reports in the Background within Excel

No need to wait for your report before you can start using Excel, again.  Run your report in the background and continue working with your other Excel files.

Updated Jet Ribbon and Windows within Excel

The Jet ribbon has been updated and the entire user interface has been refreshed to be more consistent, throughout.

Several items have been rearranged to be easier to find, and other related items have been grouped together for a cleaner experience.

  • All configuration settings have been combined under a single button
  • The run options have also been consolidated. In an effort to better explain what they do, the Refresh and Report buttons have been renamed to Run and Run from Cache , respectively.

Fast Financials Updated

To make it easier to select/deselect your Fast Financials accounts, each account can be toggled on and off with a simple click of the mouse – and you can still use the SHIFT key to quickly select a range of accounts. To make copying or adding replicating functions easier than ever, your Fast Financials Report Option dates are now also placed directly on the report sheet. The GL functions and the variance formulas reference those dates, rather than the named ranges on the Options sheet.

Manage Users and Groups in the Jet Web Portal

Now manage your users and groups directly within the Jet Web Portal. Users and Groups added here can also be seen/managed in the Jet Administration Console and can be assigned the new levels of permissions within the Jet Web Portal, itself. And, non-administrator users can now be given permissions to create, rename, move, and delete folders, as well as to change the owner of an existing report.

Compatible with Dynamics NAV 2018

Our testing with Dynamics NAV 2018 has been completed and Jet Professional 2018 R2 fully supports this exciting update.

When used with NAV Web Services, version 2018 R2 of the Jet Excel add-in requires the latest release (12.6) of the Jet Reports Business Objects .

Jet Professional 2018 Build 18.0.18060.4

March 8, 2018

Changes since 18.0.18039.1

Excel Add-In Fixed an issue where some queries would return an error when run in regions where commas are used as decimal points. Fixed an issue where viewers would sometimes be presented with an error within cell A1. Fixed an issue where worksheets containing more than one NL(Table) function would only create the first table defined.

Jet Web Portal Fixed an issue where certain reports would present an error about circular references when run in the Jet Web Portal. Fixed an issue where nested replicators in certain reports would cause additional data to be returned to the worksheet. Fixed an issue where cell reference values would sometimes be removed after a report is run in the Jet Web Portal. Fixed an issue where reports run in the Jet Web Portal that contain cells with #VALUE! would not allow the user to use the "Check error" button in the Jet Ribbon when the report is opened in Excel. Fixed an issue where reports containing an NP(Eval) function of a named range pointing at '|' separated date ranges would return #VALUE!. Fixed an issue where certain reports run in the Jet Web Portal would cause the workbook to become corrupted. Fixed an issue where NP(Eval) functions of a named range that are nested within an IF statement would not evaluate correctly when run in the Jet Web Portal. Fixed an issue where some reports run in the Jet Web Portal would cause an error from circular references. Fixed an issue where report option formulas would sometimes be overwritten when the report containing them would be run in the Jet Web Portal. Fixed an issue where data validation in a report run in the Jet Web Portal would sometimes not expand correctly. Fixed an issue where some reports uploaded to the Jet Web Portal in Report Mode would sometimes lose data. Fixed an issue where renaming sheets that contain charts would cause the charts to lose references when run in the Jet Web Portal. Fixed an issue where reports containing math calculations using a cell reference would sometimes return #VALUE!. Fixed an issue where certain reports run in the Jet Web Portal would return the error "Object reference not set to an instance of an object". Fixed an issue where report charts would behave differently in some cases when the report is run in the Jet Web Portal. Fixed an issue where some reports run in the Jet Web Portal would return empty cells where a #VALUE! is expected. Fixed an issue where structured references were not supported in the Jet Web Portal. Fixed an issue where reports run in the Jet Web Portal containing NL(Table) formulas referencing an NP(Formula) function within a column would result in a corrupted workbook. Fixed an issue where running certain reports in the Jet Web Portal would sometimes result in workbook comments becoming corrupted. Fixed an issue where reports run in the Jet Web Portal would sometimes not refresh Subtotal amounts automatically. Fixed an issue where reports containing NL(Table) functions run in the Jet Web Portal would sometimes use incorrect number formats.

Jet Professional 2018 Build 18.0.18039.1

February 15, 2018

Changes since 18.0.18018.1

Excel Add-In Fixed an issue where large reports would sometimes exhibit less than desirable behavior, including long open and run times. Fixed an issue where batch function optimization would sometimes incorrectly evaluate functions to #VALUE!. Fixed an issue where Fast Financials would add the incorrect formula when drag-and-dropping accounts after performing a drilldown. Fixed an issue where NL functions referencing || in the Table argument would sometimes return #VALUE!. Fixed an issue where nested replicators would sometimes not expand as expected.

Jet Web Portal Fixed an issue where data validation did not work correctly in some cases. Fixed an issue where certain reports utilizing a GP data source would not upload correctly. Fixed an issue where reports containing "\r\rn" in a formula would not upload correctly. Fixed an issue where uploading a report with an NL(Table) function that contains no value in the Fields argument would cause the workbook file to become corrupted. Fixed an issue where uploading a report with an NL(Table) function with an empty value for the "Headers=" special filter would cause the workbook file to become corrupted. Fixed an issue where the available users for selection in the "Change Owner" window would not be a complete list of all users. Added the error detail to the report detail page if the report failed to upload completely. Fixed an issue where report options would become scrambled when run as a scheduled report. Fixed an issue where reports containing data from multiple companies would sometimes not run correctly in the Web Portal.

Jet Professional 2018 Build 18.0.18018.1

January 25, 2018

Changes since 18.0.17362.4

Excel Add-In Fixed an issue where Office365 authentication was not functioning properly when configured for a NAV data source that supports it. Fixed an issue where reports containing a cell with a very large value would sometimes throw an exception. Fixed an issue where certain report option values would sometimes cause an original function to be removed from the report. Fixed an issue where switching report modes after using certain features of the Jfx could cause Excel 2010 to hang until it was refocused. Fixed an issue where Excel 2010 would sometimes not retain application focus after closing the Jfx. Fixed an issue where refreshing certain reports would take much longer to run than switching from design mode to report mode. Fixed an issue where scheduling reports containing hidden rows or Values Only would sometimes not behave as expected when batch function execution is enabled. Fixed an issue where report option lookups on NAV date fields would only show time values. Fixed an issue where NL(Filter) formulas using a filter value containing <, >, <>, .., etc would not work as expected when run against a NAV Direct SQL data source. Fixed an issue where subsequent runs of a report after its initial run would sometimes not update report option values correctly.

Jet Web Portal Fixed an issue where a report downloaded from the Web Portal would sometimes require a workbook repair. Fixed an issue where conditional formatting rules would sometimes be lost after downloading the results of a report run from the Jet Web Portal. Fixed an issue where some Jet functions' "what" argument could replace the "what" argument of other Jet functions in the report. Fixed an issue where some reports utilizing a GP data source would sometimes fail to upload to the Jet Web Portal. Fixed an issue where reports localized in German that contain NP(Eval) formulas would sometimes fail to upload to the Jet Web Portal. Fixed an issue where reports in an error state would sometimes be inadvertently removed from the Jet Web Portal under certain conditions. Fixed an issue where clicking "Next" or "Prev" to navigate between pages of items would sometimes display the wrong items. Fixed an issue where reports with Jet functions that contain embedded functions would sometimes fail to upload to the Jet Web Portal if the embedded function uses a semi-colon list separator.

Jet Professional 2018 Build 18.0.17362.4

January 4, 2018

Changes since 18.0.17355.0

Excel Add-In Fixed an issue where lists of tables in the Jfx and Table Builder would sometimes not be sorted correctly. Fixed an issue where creating a report option lookup using the Jfx would produce an error when pressing ESC. Fixed an issue where certain reports that ran correctly in the previous version of Jet Professional failed to run successfully in the latest version. Fixed an issue where drilling down from within the Jfx window in any non-English locale would not work as expected.

Jet Web Portal Fixed an issue where named ranges that contain any formulas could not be used as arguments to Jet functions. Fixed an issue where Jet replicator functions that are nested in Excel functions would require the drilldown button to be clicked twice. Fixed an issue where reports would fail to publish when external links did not actually exist. Fixed an issue where reports containing an NL(Picture) function would produce different results in the Web Portal than in the Excel Add-In. Fixed an issue where some reports with nested replicators in a region larger than its parent's region would not correctly produce an error. Fixed an issue where conditional formatting would sometimes not work correctly in reports run in the Web Portal. Fixed an issue where NL(Filter) functions using "Filters=" did not work correctly in the Web Portal. Fixed an issue where report options containing a date with "Long date" formatting date would sometimes have its formatting removed when running the report in the Web Portal. Fixed an issue where some reports containing || filters would fail to publish or upload to the Web Portal. Fixed an issue where some reports containing references to an Excel EOMONTH() function would fail to publish or upload to the Web Portal. Fixed an issue where reports containing multi-company GL() functions against a GP data source would not run successfully in the Web Portal. Fixed an issue where NL(Lookup) functions nested within Excel functions were not handled correctly in the Web Portal. Fixed an issue where reports run in the Web Portal would sometimes produce cells containing #VALUE! instead of being empty as expected. Fixed an issue where conditional hide did not work as expected in the Web Portal. Fixed an issue where some reports would become corrupted after uploading or publishing them to the Web Portal. Fixed an issue where reports containing DAYS functions in a language other than English would produce #VALUE! when running the report in the Web Portal. Fixed an issue where reports containing NL(Sheets) functions would not produce the expected results when run in the Web Portal. Fixed an issue where reports containing multiple NL(Sheets) functions would cause an error when uploading or publishing to the Web Portal. Fixed an issue where some reports would fail to upload or publish to the Web Portal. Fixed an issue where NL(Filter) functions nested in other functions would not work as expected in the Web Portal. Fixed an issue where some reports downloaded from the Web Portal would leave Excel unresponsive when switching to Design mode using the Excel Add-In.

Jet Professional 2018 Build 18.0.17355.0 December 27, 2017

Changes since 18.0.17349.0

Excel Add-In Fixed an issue where batch optimized functions that depend on report options would sometimes return wrong values.

Jet Professional 2018 Build 18.0.17349.0 December 19, 2017

Changes since 18.0.17342.2

Excel Add-In Fixed an issue where reports would sometimes fail to run on non-English systems. Fixed an issue when performing a drilldown within the Jfx using a NAV Web Services data source would sometimes only return the first row. Fixed an issue where dragging and dropping report option lookups for Universal and Warehouse data sources sometimes failed to function correctly.

Jet Web Portal Fixed an issue where some reports containing cross-sheet range references failed to upload to the Web Portal.

Jet Professional 2018 Build 18.0.17342.2 December 14, 2017

Excel Add-In The cells contained within the report options window from the Jfx are now selectable. Fixed an issue where dragging fields from the Browser would sometimes insert the wrong function into the report. Fixed an issue where navigating away from the advanced page of a new universal data source settings before configuring the connection would sometimes produce an exception. Fixed an issue where batch function optimization would cause cells to produce #VALUE! as the result. Fixed an issue where the Browser and Fast Financial windows would not appear above the Excel workbook when more than one workbook was open. The report options lookup window can now be resized. Fixed an issue where using the Jfx from within the report options window would sometimes send the Excel window to the background when the report options window was closed. Usability of the report options window has been improved - Tabbing moves you through each option value allowing you to edit the values. - Single-clicking a cell edits the value. - Clicking or tabbing to edit a cell selects the entire value. - ENTER runs the report. Tooltips appear when hovering either over the title or the value. Fixed an issue where the options tab within the scheduling window would sometimes disappear when selecting a new tab. Fixed an issue within Fast Financials where dragging and dropping large amounts of data, then quickly closing the window would sometimes cause Excel to terminate unexpectedly. Fixed an issue where batch function optimization would sometimes fail when an NP(Eval) function referenced a named range which contains a Jet function. Fixed an issue where Excel 2010 users would not see updated icons. Fixed an issue where batch function optimization would fail for a report containing an NL(Filter) function as a filter. Fixed an issue where the Fast Financials tool would sometimes cause Excel to terminate or become unresponsive when selecting all accounts, all headers, and all columns. Fixed an issue where large reports would sometimes cause Excel to run out of memory. Fixed an issue where cancelling a running report with function optimization enabled would sometimes damage the report. Fixed an issue where an NL(Sheets) function would sometimes produce incorrect sheet names.

Jet Web Portal Fixed an issue where a report containing an NL(Picture) function would run significantly slower as compared to running within the Excel Add-In. The icon for a report in a cancelled state now differs from the icon for a report in an error state. Modified the report details page to no longer accept script tags in the name and description fields. Fixed an issue where running a report while other reports are uploading would sometimes cause the running report to persist the running state even after the report completes. Fixed an issue where opening multiple reports into Excel Online would only open the first report. Fixed an issue where reports containing cross-sheet referenced would fail to upload. Fixed an issue where successfully publishing a report from the Excel Add-In would sometimes not clear a previous upload error state. Fixed an issue where some scheduled reports would produce a time-out exception.

Jet Professional 2018 18.0.17321.0November 27, 2017

Changes since 18.0.17307.5

Excel add-in Updated product translations for Czech, Danish, German, Greek, Spanish, Finnish, French, Hungarian, Icelandic, Italian, Japanese, Dutch, Norwegian, Polish, Portuguese, Russian, and Swedish locales. Fixed issue where the report options window would sometimes not associate correctly with existing option lookups. Fixed a layout issue with the Insert Named Ranges window and the Fast Financials window. Fixed an issue where opening the Jfx window sometimes resulted in an empty window. Fixed an issue where running a report using a Data Warehouse or Cube data source with multiple instances of Excel running would sometimes activate the wrong instance after the report runs to completion. Fixed an issue where the Jfx would sometimes load the incorrect formula.

Jet Web Portal Updated product translations for Czech, Danish, German, Greek, Spanish, Finnish, French, Hungarian, Icelandic, Italian, Japanese, Dutch, Norwegian, Polish, Portuguese, Russian, and Swedish locales. Fixed an issue when changing the ownership of a scheduled task where searching for a phrase beginning with a space character sometimes returned inaccurate results. Fixed an issue where uploading multiple reports and navigating away from the reports section of the application would sometimes cause some of the reports to not upload completely. Fixed an issue where correcting a failed upload with a valid report of the same name would not clear the upload error upon successful upload. Fixed an issue where scheduling a report from the report details page would sometimes provide the wrong navigation when returning to the full list of reports. Fixed an issue where the delete folder button would not disable as expected after deleting a folder.

Jet Professional 2018 Build 18.0.17321.0

Initial release of Jet Professional 2018

Fast Financials

The Fast Financials feature for Dynamics NAV provides a fast and easy way to create financial reports.

Updated Jet Ribbon in Excel

The Jet ribbon within Excel has a new, contemporary look. Outdated features (i.e., Report Builder) have been removed, new features added, and other items have been updated to make them easier to find and use.

Updated Windows

Windows within the Jet Excel add-in have been given a consistent and more contemporary look.

Enhanced Control of the Jet Ribbon

The Jet Application Settings give you more control over the Jet Ribbon than ever before. Do you only use the GL function? Make it the only button available in the Jet Function Wizard (Jfx). Want to see all the Jfx buttons on the ribbon? Select the new Expanded Menu option.

Make the ribbon look just the way you need for the way you build and view your reports.

Domain Change for NAV Logins

Those Dynamics NAV users whose data resides outside their standard Windows domain can now specify the necessary domain as part of the username in their data source settings.

Help Menu Updated

The Jet Help Menu has been simplified to correspond to the consolidation of the Jet Reports Support, Help, Knowledgebase, and Community web sites. All of these can be accessed through the single Help Center option.

Specifying Domain Name during Login

In the Jet Web Portal, you can change the domain name associated with your login by entering a different name using either down-level (also known as 'server/username') format or UPN (also known as 'email') format.

Context Sensitive (right-click) Menus

The Jet Web Portal now features right-click menus that reflect the same options available on the action panel.

Easier Scheduling

In the Jet Web Portal, scheduled tasks can be created directly form the Reports List by selecting the desired report(s), and then either selecting Schedule from the action pane or right-clicking and selecting Schedule from the context menu.

Options for Opening Reports

To help everyone understand how to open reports in the Jet Web Portal, once you select one or more reports and click Open you will be prompted to decide if you want to open the reports with Excel Online or want to download the report and open it with an installed version of Excel.

Timeout Feature

When the Jet Web Portal has been left inactive for 20 minutes, a 60-second reminder will be displayed asking if you wish to stay logged in.  If no response is received, you will be logged out.  When you log back in, you will be taken directly to the screen you were on when your session timed out.

Support for More Jet Features

In Jet 2018, the Jet Web Portal supports Dashboard mode as well as the NL(Picture) and NP(Slicer) functions.

Support for More Excel Functions In Jet 2018, the Jet Web Portal supports additional Excel functions:

RADIANS FACTDOUBLE SEC, SECH, CSC, CSCH, COT, COTH, ACOT, and ACOTH RANK, RANK.EQ, RANK.AVG CEILING.MATH, FLOOR.MATH STDEVA, STDEVPA, VAR.S, VAR.P, VARA, VARPA TIMEVALUE

Jet Professional 2017 R3 Build 17.2.17275.2October 5, 2017

Changes since 17.2.17251.1

Excel add-in Fixed an issue where one or more buttons on the Jet ribbon would be removed rather than be disabled. Fixed an issue where exported favorite tables and fields for a data source could not be imported. Fixed an issue where closing multiple Excel workbooks in quick succession sometimes caused the Jet ribbon to fail to load.

Jet Web Portal Fixed an issue where sorting by the results of an NL("Suma") function in a report running in the Jet Web Portal did not work correctly when localized in Spanish. Fixed an issue where a report running in the Jet Web Portal with a cell containing a NETWORKDAYS() function resulted in #VALUE! in that cell. Fixed an issue where a report containing an NL("First") function containing a Link= would not produce the correct result. Fixed an issue where a report containing relative cell references running in the Jet Web Portal would sometimes fail to resolve correctly resulting in various errors. Fixed an issue where a report running in the Jet Web Portal that contains references across worksheets would not resolve those references correctly resulting in a corrupted Excel workbook. Fixed an issue where saving changes to a scheduled task in the Jet Web Portal as a result of being prompted to save due to the user's navigation would not give any notice to the user if any errors occurred during the save process. Fixed an issue where uploading a report to the Jet Web Portal with the same name as an existing report would not prompt the user to confirm overwriting the existing report if the report was originally downloaded from the same Jet Web Portal. Fixed an issue where renaming a report folder in the Jet Web Portal to a name only containing one or more spaces would result in an error message. Fixed an issue where testing newly entered SMTP settings in the Jet Web Portal would sometimes result in false errors. The reports available to be added to a scheduled task in the Jet Web Portal is now an alphabetized list. Validation errors shown when entering information for a scheduled task within the Jet Web Portal now give more useful details about the required information. Fixed an issue where editing a report title in the Jet Web Portal would sometimes result in repeating error messages.

Jet Administration Console Fixed an issue where manually synchronizing users with Active Directory sometimes did not work as expected.

Jet Professional 2017 R3 Build 17.2.17251.1September 14, 2017

Changes since 17.2.17230.4

Jet Web Portal Fixed an issue on the Jet Web Portal where data source was not set to blank during report upload. Fixed an issue on the Jet Web Portal where report sharing for certain users was not working as expected. Fixed an issue on the Jet Web Portal that improved the search experience for reports. Fixed an issue that prevented users from closing the report options window while running certain reports on the Jet Web Portal. Fixed an issue on the Jet Web Portal where selecting disabled Scheduled tasks did not disable the "Run" toolbar button. Fixed an issue on the Jet Web Portal where Japanese translations were incorrect. Fixed an issue where Accounting and Currency format rounded decimal values when run from the Jet Web Portal in certain languages. Fixed an issue where changing ownership after Jet Professional version upgrades did not permit the previous owner to run reports on the Jet Web Portal. Fixed an issue where users were unable to upload certain reports using a Dynamics GP data source to the Jet Web Portal. Fixed an issue where certain reports with NL(Rows) with one of its filters being a cell reference to NL(Filter) contained #VALUE after it was downloaded from the Jet Web Portal. Fixed an issue on the Jet Web Portal that would prevent the dashboards from loading correctly after they were created. Fixed an issue where certain reports that have functions referencing a TEXT() function did not return correct values. Fixed an issue where reports with INDEX(MATCH() function displayed incorrect date values when run on the Jet Web Portal.

Excel Add-in Fixed an issue where warehouse data sources did not correctly exclude tables with a "_PK" postfix.

Dashboard Builder Fixed an issue with Dashboards that prevented users from entering Target values with decimals to get percentages under 100%. Fixed an issue with Dashboards that caused the percentage number format for a measure to be displayed incorrectly for all visual types that allow number formats. Fixed an issue where the Dashboard Builder would become unresponsive when incorrect details are entered in the Settings → Application Settings section.

Jet Professional 2017 R3 Build 17.2.17230.4August 24, 2017

Changes since 17.2.17209.1

Jet Excel Add-In

Fixed an issue where certain reports that used SQLDataType Variant in a code field when used with NL(Sum) in Microsoft Dynamics Navision 2013 -2017 returned incorrect data. Fixed an issue where users licensed as Viewers could not publish reports from Jet Excel Add-in. Fixed an issue in the Jfx where a lookup on the Account argument of the Dynamics NAV GL function would not show all GL accounts. Fixed an issue in the Dynamics NAV 2013 and later codeunits where automatically publishing the codeunits to the web service would degrade the performance. Note: An import of the latest Jet codeunits is mandatory for this fix to be applied.

Jet Web Portal Fixed an issue where Reports on the Jet Web Portal could not be opened using One Drive for Business. Fixed an issue where reports with Nested Replicators could fail with an OutOfMemoryException when run on the Jet Web Portal. Fixed an issue where users could not cancel out of the Report Options window for certain reports on the Jet Web Portal. Fixed an issue where the Report Options window retained previously entered values even after cancelling the window for certain reports on the Jet Web Portal. Fixed an issue where creating duplicate folders on the Jet Web Portal did not provide clear error messages to the user. Fixed an issue on the Jet Web Portal where users were unable to rename folders on IE 11 and Edge browsers. Fixed an issue where users were unable to deselect folders in detail view on the Jet Web Portal. Fixed an issue where a useful error message was not shown whenever invalid start time was entered for Scheduled Tasks on the Jet Web Portal. Fixed an issue to improve readability and consistency across all web pages that have grid list display in the Jet Web Portal. Fixed an issue where the Last Run details of a report was not updated in the Jet Web Portal when run from the Scheduled task. Fixed an issue where a new owner of a report or a Scheduled Task was unable to edit and save Report Options on the Jet Web Portal. Fixed an issue on the Jet Web Portal where a Scheduled Task could be created and saved with no password credentials on Apple Safari Browser and iOS platform. Fixed an issue where a disabled Scheduled Task could be run from the Scheduled Task details page on the Jet Web Portal. Fixed an issue on the Jet Web Portal where users would not get a clear error message when attempting to run a report on a data source they no longer had access to. Fixed an issue where a Scheduled Task could be disabled from the Reports -> Details -> Schedule page on the Jet Web Portal. Fixed an issue on the Jet Web Portal logon page where the “Sign In” button was not disabled after the user submitted the username and password for the first time. Fixed an issue on the Jet Web Portal where searching for reports using a search term with delimiters was not supported. Fixed an issue on the Jet Web Portal where the Dashboards page was not reloaded after the search term was cleared. Fixed an issue on the Jet Web Portal where the search term was not bold in the search results for matching reports and corresponding report descriptions in the tile view. Fixed an issue where an error message was not displayed when a user attempted to run a report with an unauthorized data source on the Jet Web Portal. Fixed an issue on the Jet Web Portal where folders could not be renamed on touch screen interfaces. Fixed an issue on the Jet Web Portal where the Report Details page was inconsistent between tablet and desktop versions. Fixed an issue on the Jet Web Portal where the user was not redirected to the dashboard or report specified in the URL after their session had expired.

Fixed an issue on the Jet Web Portal where the user was not redirected to the dashboard or report specified in the URL after their session had expired.

Jet Professional 2017 R3 Build 17.2.17209.1

August 3, 2017

Initial release of Jet Professional 2017R3

  • Upload Report from with the Jet Web Portal
  • Directly Link to Jet Enterprise Dashboards
  • Publish Reports to Web Portal Folders
  • Record Keys now available when reporting form a Jet Enterprise Data Warehouse
  • Error Logging in the Jet Web Portal

Jet Professional 2017 R2 Build 16.1.17145.0 May 31, 2017

Changes since 16.1.17118.0

Installer Fixed an issue where the installer would not stop the Jet Service Tier before an upgrade installation. Fixed an issue where the Customer Experience Improvement (CEIP) window was not displayed on clean installation.

Jet Excel Add-in Fixed an issue where a Nested NL(Filter) added ‘||’ symbol to SELECT statement and eventually caused the reports to fail. Fixed an issue where F1 would opens an incorrect web page when pressed from the Report Option windows in the Jet Excel Add-in. Fixed an issue where reports that used NL(Count,NL(Intersect,NL(Filter),NL(Filter))) with +VALUES returned #VALUE. Fixed an issue where a corrupted Settings.xml files would create multiple exceptions which, in turn, would crash Microsoft Excel.

Jet Web Portal Fixed an issue where published reports failed to run on the Jet Web Portal when using result of NF() as filter. Fixed an issue where certain formatting and Fit tags caused reports to fail on the Jet Web Portal. Fixed an issue where certain reports that used MONTH() and DAY() arguments with undocumented Excel behavior failed to run on the Jet Web Portal. Fixed an issue on the Jet Web Portal where scheduled tasks disabled using the “disable” button on the toolbar would not be disabled. Fixed an issue where reverse sign option did not behave as expected for target value of performance tiles on the Jet Web Portal. Fixed an issue where an error log was not being created when the process running the report crashed on the Jet Web Portal. Fixed an issue where reports with an NF() filter on a FlowField returned incorrect values when run on the Jet Web Portal. Fixed an issue where reports with IFERROR(INDEX(MATCH)) did not work properly on the Jet Web Portal. Fixed an issue where Scheduled tasks executed from the Jet Web portal on a non-US locale Windows OS passed the dates in US format instead of local format. Fixed an issue where reports with a filter on a FlowField for <>0 would generate an IndexOutOfRangeException on the Jet Web Portal.

Jet Dashboard Builder Fixed an issue where reverse sign option did not behave as expected for target value of performance tiles in Dashboard Builder.

Jet Professional 2017 R2 Build 16.1.17118.0 May 4, 2017

Changes since 16.1.17100.0

Jet Excel Add-in Fixed an issue in Jet Excel Addin -> Data sources – Advanced Tab where text was cut-off for Cfront data sources. Fixed an issue where reports with an Excel Subtotal function returned incorrect results when executed in the Web Portal.

Jet Web Portal Fixed an issue where reports with non-English Jet tags threw an InvalidFieldException in the Web Portal. Fixed an issue where the column headers were truncated when resizing the scheduler and reports pages. Fixed an issue where some reports ran slowly in the Web Portal. Fixed an issue where a catastrophic failure error occurred whenever a non-admin user tried to run a report in the Web portal. Fixed an issue where some character combinations in the Web Portal User’s password caused a server error and displayed the password on the event viewer. Fixed an issue where reports with German 'Umlaute' (such as ö, ä, ü) in the name would crash Internet Explorer when it attempted to download from the Web Portal. Fixed an issue where some reports would generate a “Domain not found“ error and failed to publish to the Web Portal.

Jet Professional 2017 Build 16.1.17100.0 April 14, 2017

Changes since 16.1.17081.0

Jet Excel Add-in Fixed an issue in the JFx where switching the type of function did not work as expected. Fixed an issue in the Dynamics GP data source where a drilldown operation on a cell value of zero crashed Microsoft Excel. Fixed an issue where Windows OS with certain regional settings were not supported with SQL-based data sources. Fixed an issue with NL(Sheets) where a sheet name with a ’:’ (colon) character threw a COMException. Fixed an issue in the Dynamics NAV 2009 R2 or earlier data source where Windows OS with certain regional settings caused dates to be retrieved incorrectly. Fixed an issue in the Data Source Settings where creating a Dynamics NAV 2009 R2 or earlier data source cropped the text in the Data sources -> Advanced Settings window. Fixed an issue where Microsoft Excel crashed when a drilldown into Cube measure through the NF() function was performed.

Jet Web Portal Fixed an issue where reports with localized Excel functions within NP("Eval”) failed to publish to the Web Portal. Fixed an issue where reports with Named ranges referencing sheets with ‘!’ failed to publish or run on the Web Portal. Fixed an issue where reports with localized date formats published but failed to run on the Web Portal. Fixed an issue where some localized reports failed to run on the Web Portal .

Jet Professional 2017 R2 Build 16.1.17081.0

March 23, 2017

Changes since 16.1.17061.0

Installer Fixed issue where a COMException could occur during installation.

Jet Remote Data Service Fixed issue where Jet Remote Data Service could not be installed on Windows Server 2008 or earlier.

Excel Add-in Fixed issue in the Excel Add-in where links to KB articles were incorrect. Fixed issue in the Excel Add-in where double-clicking on the Pivot Table Icon on the Jet Ribbon would select the wrong item within the Pivot Table window. Fixed issue where a Radar Chart could prevent a report from being published to the Web Portal.

Web Portal Fixed issue where hard coded references to NL(Link) could corrupt workbooks when run in the Web Portal. Fixed issue where Reports saved to OneDrive or OneDrive for Business folders could not be published to the Web Portal. Fixed issue where scheduled tasks could not be saved with a "Minutely" or "Hourly" recurrence in the Web Portal. Fixed issue in the Web Portal where the folders could not be sorted in descending order. Fixed issue in the Web Portal where the column names in the Scheduler page would be cropped. Fixed issue where non-US date formats could cause reports to fail when run in the Web Portal. Fixed issue where reports with conditional formatting rules with ranges separated by commas could not be run successfully in the Web Portal. Fixed issue where certain reports with Date functions in the Report Options would not run successfully in the Web Portal. Fixed issue where an empty email body would prevent an email from being sent after a scheduled task completes. Fixed issue where certain users were unable to run scheduled tasks successfully in the Web Portal. Fixed issue where certain reports would run without error in the Web Portal but display #VALUE errors when downloaded. Fixed issue where the scroll bars in the Report Options lookup window would not function correctly.

Jet Professional 2017 R2 Build 16.1.17061.0

March 3, 2017

Changes since 16.1.17033.0

Jet Excel Add-in

Fixed an issue where reports that used NP(Union), NP(Difference), or NP(Intersect) with a Microsoft Dynamics NAV 2013 or later data source could result in an unexpected error.

Fixed an issue where reports with Microsoft Dynamics Nav 2009 and earlier data sources could not be run.

Jet Professional 2017 Build 16.1.17033.0

February 7, 2017

Initial release of Jet Professional 2017R2

Overview of Jet Reports 2017 R2
  • Jet Web Portal Scheduling
  • Improved Drilldown Experience for Jet Web Portal Reports
  • Drilldown for Dynamics GP G/L Reports
  • Improved User Experience in the Jet Web Portal
  • The Jet Web Portal now replaces the iPad app for iPad users.  The iPad is no longer supported

Jet Professional 2017 Build 16.0.16336.1

December 7, 2016

Changes since 16.0.16293.1

Excel Add-In

Fixed issue where some Jet functions returned a #VALUE! when the "Enable batch function execution" setting was enabled. Fixed issue in the Scheduler where the Next Run Time, Last Run Time, and Status were not being updated in Windows 10. Fixed issue in the Cube Data Source where "Date" dimension levels were returned to Excel as strings instead of dates. Fixed issue where NP(Union), NP(Intersect), NP(Difference) with only NL(Filter) function as inputs were returning an array to Excel as opposed to the expected "||" string. Fixed issue where the NL(Table) function with duplicate NP(Formula) fields did not work as expected.

Jet Administration Console

Fixed issue where non-administrators received the message that the "Service is not running" when connecting to the Jet Service Tier.

Jet Web Portal

Fixed issue where some larger reports that run correctly in Excel would return #VALUE! errors or incomplete data when run in the Web Portal. Fixed issue where reports using the Excel FLOOR() function did not work as expected. Fixed issue with slicers where only the first pivot table reference was being updated.

Remote Data Service

Fixed issue in the NAV Remote Data Service where using Windows Authentication on the server caused the error "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'".

Jet Professional 2017 Build 16.0.16293.1

October 19, 2016

Changes since 16.0.16287.0

Excel Add-In

Fixed issue in NAV data sources where Jet functions querying tables that had multiple fields with the same caption returned #VALUE.

Jet Web Portal

Fixed issue in NAV data sources where Jet functions querying tables that had multiple fields with the same caption returned #VALUE. Fixed issue where the Excel IFERROR function would produce an unexpected result when it had nested functions with errors.

Jet Remote Data Service

Fixed issue in NAV data sources where Jet functions querying tables that had multiple fields with the same caption returned #VALUE.

Jet Professional 2017 Build 16.0.16287.0

October 13, 2016
Changes since 16.0.16252.0
Excel Add-In
Improved performance of the Batch Function Execution optimization in some situations.
Improved performance of certain types of FlowFields in the Dynamics NAV SQL data source.
Improved performance of publishing certain types of reports to the Web Portal.
Updated "New Data Source" and "Publish" windows to allow the Enter key to make the default selection.
Fixed issue in Universal/SQL-Based data sources where Time fields would throw an ArgumentException, or always return 0.
Fixed issue in Dynamics NAV SQL data sources where Code fields backed by a SQL Variant did not work correctly.
Fixed issue where the NL(Table) function threw an IndexOutOfRangeException if one of the requested fields was blank.
Fixed issue in Table Builder where the "Favorites" button would be selected and disabled if no Favorites were selected in the Browser.
Fixed issue where database name drop-downs were not sorted alphabetically.
Fixed issue where Array functions (e.g. Union, Difference, Intersect) do not evaluate non-array values correctly.
Fixed issue where publishing a report with a formula could not be calculated would reference the wrong cell address in the error message.
Fixed issue where downgrading the Excel Add-In could result in an error when opening Excel due to an unrecognized Application Setting type.
Jet Web Portal
Updated Japanese translations.
Improved messaging to be more specific when a failed login occurs.
Improved messaging around Excel file formats that support publishing to the Web Portal (*.xlsx and *.xlsm).
Fixed issue where cell formatting could be changed when running a report in the Web Portal in a non-US English locale.
Fixed issue where certain types of named ranges such as Print_Titles would result in a corrupt workbook.
Fixed issue where a large named range (e.g. entire row or column) could result in a corrupt workbook.
Fixed issue where database values were not being quoted when written to the workbook, which could cause Excel to interpret them incorrectly.
Fixed issue where NF functions that used a different identifier than the one used in the NL function would result in a #VALUE.
Fixed issue where a replicator would fail to expand if one of the requested fields was blank.
Fixed issue where using a NAV Web Service data source could result in a failure to load a temporary assembly with an "Access Denied" error.
Fixed issue where the Language selection drop-down would not render correctly in Internet Explorer.
Fixed issue where logging in after being automatically logged out due to an expired session would always return to the Reports page.
Fixed issue where the Fit tag may not correctly size columns to the content.
Fixed issue where security settings could prevent opening reports in OneDrive.  Protected View must still be disabled.
Fixed issue where the reports on the Report page did not have a default sort order.
Jet Remote Data Service
Added a Launch Condition to the MSI that requires the SQL Native Client to be installed.

Jet Professional 2017 Build 16.0.16252.0September 13, 2016

Changes since 16.0.16221.0

Added support for NAV 2017. Note that an updated version of the "Jet Reports Objects.fob" NAV objects must also be imported. Added firewall rule exceptions when installing the Jet Web Portal. Improved overall performance of NAV Remote Data Service data sources.

Excel Add-In

Fixed issue where a failed connection to the Jet Service Tier would display a message when opening Excel. Fixed issue where grid drilldown into a Remote Data Service data source would display an empty grid. Fixed issue where SQL= would not work correctly in Remote Data Service data sources. Fixed issue where the "Auto Debug Report Errors" feature no longer worked as expected. Fixed issue where the Table Builder would not allow duplicate Formula fields. Fixed issue where the Table Builder would allow multi-selection for a filter value but would only select a single value.

Jet Web Portal

Fixed issue where some non-US date formats did not work correctly when running reports. Fixed issue where reports containing a pivot table that were source from an Excel table would not run correctly. Fixed issue where charts would not be moved as a result of replicator expansion when running a report. Fixed issue where a nested NL(Filter) inside a Link= would not get published correctly. Fixed issue where shared formulas in the workbook would be corrupted after running the report. Fixed issue where the tab key would not work as expected in the Report Options window. Fixed issue where attempting to login with an incorrect domain name would still create a user record in the Jet Service Tier database. Fixed issue where a formula with a concatenation operator '&' and an empty value would result in a #VALUE. Fixed issue where an NP(Eval) function with a Jet function in the Formula argument would result in a #VALUE. Fixed issue where an NF result with a single quotation mark would result in a #VALUE. Fixed issue where sorting by a dimension that was not also being retrieved in the Cube data source would result in a #VALUE.

Jet Professional 2017 Build 16.0.16221.0

August 10, 2016

Changes since 16.0.16196.0
Removed capability from the Jet Setup to restrict users to the Jet Service Tier for data sources.  This functionality is still available as a command-line parameter to the Jet.Setup.ExcelAddIn MSI.
Changed the Jet Web Portal to open reports in OneDrive/OneDrive for Business in View mode as opposed to Edit mode.
Updated the link to the Privacy Policy in the Activate Jet License window.
Excel Add-In
Fixed issue in the Dynamics NAV Remote Data Service data source where sorting by a CalcField did not work correctly.
Fixed issue in the Dynamics NAV SQL data source where filtering by an NAV Code field with properties Numeric=Yes and SQL Data Type=Variant may not retrieve the correct results.
Fixed issue in the Dynamics GP data source where functions containing SQL= may fail when the Batch Function Execution setting was enabled.
Fixed issue in the Dynamics GP data source where tables/views were always sorted by their physical name in the Table Builder and Jfx.
Fixed issue in the Jet Administration Console where importing a data source set the scope of all settings to "user", as opposed to the default scope for each setting.
Fixed issue where orphaned workbook connections with associated PivotTables could cause E_INVALIDARG errors.
Fixed issue where Stored Viewer Data could cause Excel to become non-interactive after running a report.
Web Portal
Fixed issue where opening a report using OneDrive for Business would navigate to the root folder, not open the report.
Fixed issue where pages may not have rendered correctly in Internet Explorer.
Fixed issue where NF functions inside nested replicators may not be written to the output workbook correctly.
Fixed issue where replicated values were not quoted, which could result in the loss of leading zeroes.
Fixed issue where group users could not login unless they had first connected to the Jet Service Tier from Jet Professional.
Fixed issue where report output could be corrupted when using non-English (US) regional settings.
Fixed issue where reports with conditional replication may fail to run correctly.
Fixed issue where the user could select a language that was not supported/translated.
Fixed issue where some Excel functions (DAY, MONTH, etc.) failed to convert dates correctly in some cases.
Fixed issue where reports with link filters that reference a cell containing NL(Filter) would result in an EmptyFilterException.
Fixed issue where reports could be renamed to white space.

Jet Professional 2017 Build 16.0.16196.0 July 20, 2016

Initial Release of Jet Professional 2017

  • Reporting with the Jet add-in for Excel
  • Introducing the Jet Web Portal
  • Jet Professional Integration with Jet Enterprise Dashboards

If upgrading to Jet Professional from a version of Jet Essentials *PRIOR TO* version 15.0.14329...

ALL previously-installed Service Tier components (Jet Administration Console, Jet Dashboard Builder, Jet Web Service, Jet Service Tier)

must be MANUALLY UNINSTALLED (using the "Jet Setup.exe" file included with that specific release) before running the new installer.

Related Articles

  • Uninstalling the Jet Service Tier
  • Support Maintenance Schedule
  • Jet Essentials 2011-2015U1 - Release Notes

For an optimal Community experience, Please view on Desktop