Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Release Notes for Jet Professional


What's New?

Jet Professional (including the Jet Excel add-in, the Jet Web Portal, 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 Professional.

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

Release Notes

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

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

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

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

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

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

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

  8. 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
    • Updated Jet Ribbon in Excel
    • Updated Windows
    • Enhanced Control of the Jet Ribbon
    • Domain Change for NAV Logins
    • Help Menu Updated
    • Specifying Domain Name during Login
    • Context Sensitive (right-click) Menus
    • Easier Scheduling
    • Options for Opening Reports
    • Timeout Feature
    • Web Portal Support for More Jet Features
    • Web Portal Support for More Excel Functions
    • Deprecated Feature: Report Builder
     

    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.

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

     

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

  11. Jet Professional 2017 Build 17.2.17209.1

    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
  12. Jet Professional 2017 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.

  13. Jet Professional 2017 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.

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

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

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

  17. 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
    • 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
  18. 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'".

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

  20. 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.
  21. 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.

  22. 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.
  23. 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.


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments