Sign Up for Training |
Jet Global Company Site
Community
Downloads
Submit a Request
Give Feedback

Jet Reports - Release Notes


What's New?

Jet Reports (including the Jet Excel add-in, the 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

  1. Jet Reports 2019 Build 19.0.18268.1

    October 1, 2018

    Initial Release of Jet Reports 2019

    Improved Performance with XLL Multi-threaded Add-in

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

     new10.png

    Business Central Data Source Connection

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

    new01.png

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

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

    new03.png

    Updated Report Wizard

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

    new09.png

    Update Notification when a new version of Jet Reports is available

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

    new04.png

    +VALUES automatically added to reports

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

    new02.png

    The Jet Services Database is Backed Up during Upgrade

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

    new08.png

    The Jet Hub has received a new look and new features

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

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

     new05.png

    Updates Emails when Adding Users to the Jet Hub

    When adding new users in the 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 the Jet Hub and for notifications in the Jet Budgets application

    new06.png

    Assign Data Source Permissions to User and Groups within the 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 the Jet Hub

    new07.png

    Support for Excel's WORKDAY.INTL function

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

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

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

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

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

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

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

     

     

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

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

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

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

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

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

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

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

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

     

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

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

     

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

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

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

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

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

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

  26. 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
    • The Jet Web Portal now replaces the iPad app for iPad users.  The iPad is no longer supported

  27. 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'".

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

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

  31. 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.
  32. 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?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments