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

What's New in Jet Professional

 

Jet Professional 2018 18.0.17321.0
November 27, 2017

Changes since 18.0.17307.5

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

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

 ______________________________________________________________________________________ 

  

 

Jet Professional 2018

includes several new and
improved features!

WhatsNew2018.png
Printable version

 

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 have been removed, new features added, and other items have been updated to make them easier to find and use.

Updated Windows

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

Enhanced Control of the Jet Ribbon

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

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

Domain Change for NAV Logins

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

Help Menu Updated

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

Specifying Domain Name during Login

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

Context Sensitive (right-click) Menus

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

Easier Scheduling

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

Options for Opening Reports

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

Timeout Feature

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

Support for More Jet Features

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

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

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

 

 

 ______________________________________________________________________________________

Jet Professional 2017 R3 Build 17.2.17275.2
October 5, 2017

Changes since 17.2.17251.1

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

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

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

 ______________________________________________________________________________________ 

Jet Professional 2017 R3 Build 17.2.17251.1
September 14, 2017

Changes since 17.2.17230.4


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


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


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

 ______________________________________________________________________________________

 

Jet Professional 2017 R3 Build 17.2.17230.4
August 24, 2017

Changes since 17.2.17209.1 


Jet Excel Add-In

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

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

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

 ______________________________________________________________________________________

 

Jet Professional 2017 Build 17.2.17209.1
August 3, 2017

 

Jet Professional 2017R3

includes several new and improved features!

See the Enhancement Guide below for a printable version

2017R3.png

 

 

Upload Reports from within the Jet Web Portal 

The Jet Web Portal now includes the ability to upload multiple reports at one time.  It is no longer necessary to open each report in the Jet Excel add-in, put it in Design mode, and then Publish the report.

Directly Link to Jet Enterprise Dashboards

Jet Web Portal users can now define links directly to their Jet Enterprise Dashboards (and even individual visuals within Dashboards)

Publish Reports to Web Portal Folders

When publishing reports from within the Jet Excel add-in, you can now specify the web portal folder in which the report will be placed.

Record Keys now available when reporting from a Jet Enterprise Data Warehouse When reporting in the Jet Excel add-in from a Jet Enterprise Data Warehouse, it is no longer necessary to create a "Field Cache" (listing every field in your NL function that you will want to use with an NF function).  A simple NL function can now be used and the NF function can reference the results.
Error Logging in the Jet Web Portal The Jet Web Portal now creates a special error log for reports that experience an issue and are not able to run.  This can help users troubleshoot the issue and the file can be downloaded and sent to Jet Reports Technical Support.

 

 

 

 

 

 

 ______________________________________________________________________________________

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.

_______________________________________________________________________________________

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.

 

__________________________________________________________________________________________

Jet Professional 2017 Build 16.1.17100.0
April 14, 2017

Changes since 16.1.17081.0


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

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

__________________________________________________________________________________________

Jet Professional 2017 R2 Build 16.1.17081.0
March 23, 2017

Changes since 16.1.17061.0

Installer
Fixed issue where a COMException could occur during installation.

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

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


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

__________________________________________________________________________________________

Jet Professional 2017 R2 Build 16.1.17061.0
March 3, 2017

Changes since 16.1.17033.0

Jet Excel Add-in

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

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

__________________________________________________________________________________________

Jet Professional 2017 R2 Build 16.1.17033.0
February 7, 2017

Initial Release of Jet Professional 2017 R2

 

New Features from Jet Reports 2017 R2

Overview

Web-based
Scheduling 
GL Drilldown
for Dynamics GP
Report Options
Design Tool
 
 
 
 

 

This version of Jet Professional includes some great new features:

  • Jet Web Portal Scheduling of Reports
  • Improved Drilldown experience for reports downloaded from the Web Portal
  • Drilldown for Dynamics GP GL() reports
  • Faster and easier Report Options
  • Improved user experience in the Web Portal.

 

 

See the

Jet Reports 2017R2

Enhancement Guide

for complete information on all the new and enhanced features!

 

__________________________________________________________________________________________


Jet Professional 2017 Build 16.0.16336.1
December 7, 2016

Changes since 16.0.16293.1

Excel Add-In

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

Jet Administration Console

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

Jet Web Portal

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

Remote Data Service

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

 


Jet Professional 2017 Build 16.0.16293.1
October 19, 2016

Changes since 16.0.16287.0

Excel Add-In

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

Jet Web Portal

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

Jet Remote Data Service

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

 


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

 


Jet Professional 2017 Build 16.0.16252.0
September 13, 2016

Changes since 16.0.16221.0

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

Excel Add-In

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

Jet Web Portal

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

 


Jet Professional 2017 Build 16.0.16221.0

August 10, 2016

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

 


Jet Professional 2017 Build 16.0.16196.0

July 20, 2016

Initial Release

 

What's New

Jet Professional 2017 makes sharing your reports easier than ever before!  

Reporting with (and without) the Jet add-in for Excel

The Jet Web Portal is an online interface that provides an easy-to-manage repository for your organization’s reports.

Using the web interface and Office 365 Online, you can allow any of your network users – whether they have Excel and the Jet add-in installed or not – to view reports directly from their web browser.



Jet Professional integration with Jet Enterprise Dashboards

Jet Professional integrates with the Jet dashboard web client – allowing you to log into one site to see and run all your reports - and to see all of your business intelligence dashboards.

And... the Jet Enterprise dashboard capabilities includes many new features - making your dashboards more powerful and even easier to use.

  

See the Jet Reports 2017 Product Enhancement 

brochure for complete information on all the new and enhanced features!

 


**** NOTICE ****

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.

See Uninstalling the Jet Service Tier

 

 

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

Comments