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

Release Notes for Jet Professional


What's New

What's New in Jet Professional

 

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