Jet Reports - Release Notes – Support Topics

What's New?

Jet Reports (including the Jet Excel add-in, Jet Hub, and the Jet Service Tier) 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 20.5 Build 20.5.20042.1

February 11, 2020

Initial release of Jet Reports 20.5

See What's New in Jet 20.5 for a printable version of the following information:

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

See What's New in Jet 20.4 for a printable version of the following information:

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

See What's New in Jet 20.3 for a printable version of the following information:

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" Authenticationwhere 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

See What's New in Jet 2019 R2 for a printable version of the following information:

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 Financials
Fixed an issue where Jet 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.
Jet Reports 2019 Build 19.1.18289.1

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

See What's New in Jet 2019 for a printable version of the following information:

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.
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.
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.
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.
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.
+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.
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.
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.
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
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
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

See What's New in Jet Professional 2018 for more details about the following changes:

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.0
November 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

See What's New in Jet Professional 2018 for more details about the following changes:

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.2
October 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.1
September 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.4
August 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

See What's New in Jet Professional 2017R3 for more details about the following changes:
- 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

See What's New in Jet Professional 2017R2 for more details about the following changes:
Overview of Jet Reports 2017 R2

Web-Based Scheduling

GL Drilldown for Dynamics GP

Report Options Design Tool
- 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.0
September 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

See What's New in Jet Professional 2017 for more details about the following changes:
- 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.

Updated February 11, 2020 22:50: Harry Lewis

What's New?

Release Notes

Comments