Jet Reports - Release Notes

Jet Reports 2019 Build 19.3.18339.1

December 6, 2018

Changes since 19.2.18311.1

Jet Installer
Fixed an issue where upgrading from Jet Reports Financials to Jet Reports will not select the correct code units.

Jet Budgets
Fixed an issue where calendar selected will default to the initially selected date.
Fixed an issue where an error is displayed when deleting a Budget reminder.
Fixed an issue where submitting a work item error will show in the incorrect area initially.
Fixed an issue where large budget item numbers are totaling with the incorrect format.
Fixed an issue where a budget Owner will receive an email notification when un-submitting a self assigned item.

Jet Hub
Fixed an issue where the invalid credential error message is not displayed for some contents in the scheduler.
Fixed an issue where there is no option to re-authenticate a scheduled task.
Fixed an issue where data source settings in the Jet Hub are not interactive.
Fixed an issue where a user cannot create new scheduled tasks.
Fixed an issue where the Norwegian language was not displayed as a Jet Hub language option.

 

Background Reporting
Fixed an issue where background reporting does not work for consecutive users on a terminal server.

Excel Add-In
Fixed an issue where opening a CSV file will produce an error and disable the Jet AddIn while an excel session is open.
Fixed an issue where field selection is disabled after opening the Report Wizard with an invalid data source.
Fixed an issue where invalid #Ref! is returned when moving to design mode after running a report that contains a NL(Table) and Fast financials data.
Fixed an issue where functions with date filters will produce errors for reports using Business Central data sources.
Fixed an issue where canceling a report run during row expansion will bring back bad data.
Fixed an issue where the favorites icon is not visible in the browser.
Fixed an issue where successfully changing between cube data sources will display an error.
Fixed an issue where Report Wizard does not sort correctly.
Fixed an issue where the Options and progress window do not appear for a some Excel 2016 users.
Fixed an issue where the GL function in Hungarian returns #Name!.
Fixed an issue where the Drilldown against a web service data source into a Jet Data Grid will produce an error upon scrolling.
Fixed an issue where the JFX button will force close Excel after closing out of the data source settings window.
Fixed an issue where Nav SQL data source cannot connect to Nav 2018

Dashboard Builder
Fixed an issue where an error is thrown when switching between tabs with a slicer that returns no data.
Fixed an issue where slicer data will be cleared when every item is selected.

Jet Reports 2019 Build 19.2.18311.1

November 12, 2018

Changes since 19.1.18296.2

Jet Installer
Fixed an issue where Active Directory queries can throw exceptions for users in certain domain configurations.
Fixed an issue where installation will fail on a non-domain connected machine.

Jet Service Tier
Fixed an issue where the initial Jet Service Tier authentication is slow.

Jet Budgets
Fixed an issue where an incorrect 'Last Modified Date' may be displayed in the Budget drill down.
Fixed an issue where an error message is displayed after closing an assignment entry form during the send assignment process.
Fixed an issue where the Budget help link directs the user to the generic Jet Hub support page.
Fixed an issue where some fields will not be displayed correctly on budget/Work Item screens for users with the Microsoft Edge web browser.
Fixed an issue where clicking on 'Save in Budget' will move the current window behind Excel and to the foreground.
Fixed an issue where the Work Item count in the details panel for Sections does not update.
Fixed an issue where the 'Last Submission' field in the work item details panel is always in UTC time.
Fixed an issue where a budget owner is not able to open Budgets in Excel that are pending approval.
Fixed an issue where marking a Jet Budget excel file as owner will make the contributor receive a File not found error.
Fixed an issue where a long budget description will throw an error.
Fixed an issue where date formats are showing incorrectly when previewing a Budget Work Item.
Fixed an issue where no data validation exists when using Copy-Paste in an online work item data entry form.

Jet Hub
Fixed an issue where an error message is not shown in the Jet Hub if an unsupported Excel function is used.
Fixed an issue where opening a large report in OneDrive For Business will fail.
Fixed an issue where no error would display if a large report fails to upload.
Fixed an issue where not enough information was shared when running a report that uses an incorrect Excel function.
Fixed an issue where an error message does not inform the user that a non-supported Excel function was used.
Fixed an issue where a report that uploaded with an error can then be run by the user.
Fixed an issue where a Report will produce #N/A because a string is not being interpreted as a date properly.
Fixed an issue where a user will be directed back to the login page when clicking on the 'Report List' button after being logged out for inactivity.
Fixed an issue where the Excel function '=LOOKUP()' will produce #N/A on the report if run through the Jet Hub.
Fixed an issue in Microsoft Edge where some fields will not be displayed correctly on Budget/Work Item screens.
Fixed an issue where the Date picker is missing the current date selection.
Fixed an issue where clicking on 'Back to Reports List' navigates you to the scheduled task details and not the folder you were previously at.
Fixed an issue where the fill color of a cell is not persisting in the report after being run in the Jet Hub.
Fixed an issue where a cell will return #N/A when a excel '=MATCH()' function is used.
Fixed an issue where the upload icon in the header is overlapping the change view buttons.

 

Background Reporting
Fixed an issue where background reporting with a Dynamics Nav data source will ignore 'Company=' filters.

Excel Add-In
Fixed an issue where 'What' drop down in the Jfx window displayed the incorrect GL Balance description.
Fixed an issue where text gets distorted when dragging an item from the Report Wizard.
Fixed an issue where the 'X' is not displayed in the Report Wizard drop down window.
Fixed an issue where a field cannot be unchecked after a user performs 'Select-All' in the report wizard.
Fixed an issue where an NL function will not calculate if the CalcFormula is too long.
Fixed an issue where the Jfx window is taking much longer to open than previous versions.
Fixed an issue where the Format Options are not reset after a user changes the Data Source, Company or Table.
Fixed an issue where field selection using the keyboard will not indicate if you have selected all the items in the Report Wizard field list.
Fixed an issue where switching the data source upon launch of the Report Wizard will disable the ability to select fields.
Fixed an issue where the GL(JetBudget) function runs very slow.
Fixed an issue where a report with +Values, a Jet Function, and column and sheet replication will throw an error after running.
Fixed an issue where Jet is unable to evaluate functions in certain languages.
Fixed an issue where closing and opening Fast Financials will throw an error.
Fixed an issue where the "What" drop down in the Jfx window displays the incorrect GL Balance description.

Dashboard Builder
Fixed an issue where changing filters will grey out all visual 'OK' buttons.
Fixed an issue where the Dark Theme contains white text and a white background in the data grid.

Jet Reports 2019 Build 19.1.18296.2

October 26, 2018

Changes since 19.1.18289.1

Jet Hub
Fixed an issue where the button to install the Jet Reports Excel add-in would not be placed in the correct location.

Excel add-in
Fixed an issue where viewers were unable to use the drilldown feature.

Jet Reports 2019 Build 19.1.18289.1

October 22, 2018

Changes since 19.0.18268.1

Jet Administration Console
Fixed an issue where an unwanted underscore is seen when creating a personal data source in the Jet Administration Console.
Fixed an issue where multiple users are allowed to be selected as data source owners.

Jet Reports Installer
Fixed an issue where Jet Reports Financials could be installed on top of Jet Reports, this prevented users from activating Jet Reports.
Fixed an issue where Jet Reports does not activate from the installer even when given the activation code.

Jet Reports Financials
Fixed an issue where the default Nav data source web service code unit name is invalid.
Fixed an issue where a data source is not provisioned after a successful O365 sign in.

Jet Hub
Fixed and issue where changing the name of a Cube will cause the Dashboard to disappear.
Fixed and issue where clicking 'Report List' will take you back to the root folder as opposed to your previous folder.
Fixed an issue where dates were changed to a 'general' format in the Report options window.
Fixed an issue where an incorrect error message is displayed when uploading a report while having no data sources defined.
Fixed an issue where an error message is thrown when an unexpected char is used when adding a User/Group in the Jet Hub.
Fixed an issue where our autocomplete feature is inaccurate when adding a User/Group in the Jet Hub.
Fixed an issue where clicking 'Report List' in the details pane does not take you back to your previous page.
Fixed an issue where some languages were missing translations on the permissions page.
Fixed an issue where there is an incorrect translation for "New Work Item".
Fixed an issue where an empty error message is shown when attempting to sign into the Jet Hub with a user that is assigned to a Budget but not added in the Jet Administration Console.
Fixed an issue where the Report sharing 'Help' window displays an unwanted interactive check box.
Fixed an issue where the 'OK' button in the report sharing window is not activate if the "Share with Everyone" icon is selected but no users are added in the Jet Administration Console.
Fixed an issue where the user can see a highlight of a lookup button in the Report Option window even if no lookup was defined.
Fixed an issue where large user names are not displayed in the Add Users/Groups window.
Fixed an issue where the sort functionality on the security column in the administration page sorts users in the opposite order.
Fixed an issue where adding Users/Groups in the Jet Hub does not populate the users information in the staging window.
Fixed an issue where no warning is issued when attempting to add a duplicate user.
Fixed an issue where users deleted from the Jet Hub are not removed from their assigned Jet Budget or shared Reports.
Fixed an issue where data source names were cut off on the data source page.
Fixed an issue where not all text is translated on the login page.
Fixed an issue where a timeout error was displayed when an invalid username is used to login.
Fixed an issue where NL(Lookup) functions against cube data sources do not work if using a language caption for the Cube name.
Fixed an issue where an empty contextual menu will partially hide the run history page.
Fixed an issue where no loading spinner is visible when navigating from the information window to run history and report details.
Fixed an issue where a user cannot rename reports or folders within the tile view.
Fixed an issue where the loading spinner is cut off on the data sources page.
Fixed an issue where authorizing a Business Central data source by clicking the GoLink does not propagate a new window.
Fixed an issue where User Groups without a full name are displayed as an empty string when adding a new group in the Jet Hub.
Fixed an issue where a user can double click 'Add Comment' and it will add a duplicate of the same comment.
Fixed an issue where multiple confirmation messages are sent when only one invitation was sent.
Fixed an issue where the Jet Hub welcome email displays the username and not the user's full name.
Fixed an issue where a report option value is being overlapped by the report option title field.
Fixed an issue where searching for local users in the Admin section of the Jet hub does not work as suspected.
Fixed an issue where no every user who is invited to the Jet Hub will receive the invitation.
Fixed an issue where logging in to the Jet Hub with a user that is not in the Jet Services database will throw an ambiguous message.
Fixed an issue where the loading spinner is displayed in the background while adding users.
Fixed an issue where running a report that has an incorrect conditional formatting rule will corrupt the workbook.

Jet Budgets
Fixed an issue where the Budget spreadsheet preview allows text to be entered when entering dimensions.
Fixed an issue where the Calendar's user notifications are not in the correct layout.
Fixed an issue where the Jet Budget Grid paging is not reset when navigating between Users, Work Items and Templates.
Fixed an issue where searching for users within a budget works differently for Admin and non-admin users.
Fixed an issue where the template name is cut off in the drop down when creating a new Work Item.
Fixed an issue where users that were deleted from the Jet Administration Console can still be added as budget users.
Fixed an issue where the Work Items overview window had improper column padding.
Fixed an issue where an error message is displayed on the dialog page when creating a budget with no data sources defined.
Fixed an issue where a budgeting contributor should be able to submit a budget from the preview pane.
Fixed an issue where the 'Save' and 'Resend' buttons are active on a Work Item when no changes were made.
Fixed an issue where a deadline is filled out for a self assigned Budget.
Fixed an issue where a Budget approver is not notified when he is removed an approver.
Fixed an issue where the old product name is displayed when sending numbers from excel to the budget.
Fixed an issue where the Jet Budget will show a successful Budget upload after a Budget Work Item upload was cancelled.
Fixed an issue where renaming a Work Item will not be reflected in the downloaded file.
Fixed an issue where deleting a user from a Jet Budget will not notify the user.
Fixed an issue where a notification should be displayed when attempting to copy a Budget without having access to that Budget's data source.
Fixed an issue where budget allocation should also show for edited work items in excel.
Fixed an issue where if a user is removed from a Budget that is in the state of pending approval the Budget will remain in that state.
Fixed an issue where an error is thrown when exceeding the Budget instructions character limit.
Fixed an issue where the Budget owner shouldn't be allowed to send unassigned work items.
Fixed an issue where Budget submission comments are not limited in length.
Fixed an issue where Budget column names differ from column selection menu names.
Fixed an issue where a Budget owner will receive an email of their own 'Approval' or 'Un-Approval'.
Fixed an issue where a new Budget owner with no access to a data source no dimensions or accounts will display when creating a new work item.
Fixed an issue where the 'Days' text box allows special characters.
Fixed an issue where a Budget email template should not update changes made when its first sent out.
Fixed an issue where there were inconsistencies in a users names included in the Budget emails.
Fixed an issue where no comment is documented if a Budget contributor is also the approver.
Fixed an issue where changing Budget ownership will throw an error if smtp is not setup.
Fixed an issue where no tool tip is displayed on the Budget overview page.
Fixed an issue where a work item does not get approved when the approver clicks 'Approve' after making changes.
Fixed an issue where a Budget reminder email is labeled as from the Budget owner and not the contributor who made the changes.
Fixed an issue where the user cannot select a new Budget owner in changing ownership.
Fixed an issue where a Budget excel file formatting will be offset when assigned to a user with no Budget allocation.
Fixed an issue where a Budget owner can send a work item without assigning a contributor and approver.
Fixed an issue where Budget reminders are not being sent if the budget owner's email is not known.
Fixed an issue where double clicking a dimension when creating a work item will add it twice.
Fixed an issue where approving a Budget as a contributor from the online entry window will not move the status to 'Approved'.
Fixed an issue where the 'Save and Submit' button does not appear after creating a new Work Item.
Fixed an issue where clicking 'Save and Submit' will not submit any unsaved changes.

Excel Add-In
Fixed an issue where old values persisted in the JFX after editing a nested function.
Fixed an issue where an exception is thrown when a cell formula exceeds what excel allows to be in a formula property.
Fixed an issue where the 'Send to Budget' icon is not the correct color of Grey.
Fixed an issue where the excel window will lose focus after "Sending to Budget".
Fixed an issue where data source and company drop downs in the report wizard are still enabled when only one data source exists.
Fixed an issue where a 'Favorited' item is not removed from the list.
Fixed an issue where in the 'Review and Finish' pane of the Report Wizard lists are displayed concatenated.
Fixed an issue where the 'Select All' feature un-checks itself when navigating between sections.
Fixed an issue where changing a nested function deletes your main function.
Fixed an issue where the main report wizard window can be minimized.
Fixed an issue where Jet was not detecting Nav extension tables correctly for Web Service data sources.
Fixed an issue where the table drop down in the report wizard will show a blank placeholder text when changing the data source or company.
Fixed an issue where selecting a list item in the report wizard with the key board, the type to search no longer function.
Fixed an issue where running a report that was generated through the report wizard returns invalid values.
Fixed an issue where running a report with an invalid function will toggle the current workbook to the background.
Fixed an issue where an Analytics universal data source will throw an exception when NL(Table) function is run.
Fixed an issue where '+Values' is added to new sheets when the other sheets already contain Auto+Hide.
Fixed an issue where adding a filter in the report wizard will cause column headers to be misplaced.
Fixed an issue where only top-level reports can be selected upon report upload.
Fixed an issue where changing the data source in the report wizard the table from the previous data source will remain selected.
Fixed an issue where the report wizard creates a broken anchor row for replication when the report is generated.
Fixed an issue where selecting too many fields using a GP data source will cause the text to no longer wrap on the finish page.
Fixed an issue where providing invalid data source credentials will prevent the browser from functioning on another data source.
Fixed an issue where Jet cannot run NL functions with multiple embedded functions.
Fixed an issue where no error message is displayed when attempting to submit an invalid budget number.
Fixed an issue where running a Fast Financials report with an NL(Table) will throw a null reference error.
Fixed an issue where the report wizard will throw an error if a users Jet Data Warehouse data source is not setup correctly.
Fixed an issue where the report wizard will show tables from the default data source after changing to a newly create Jet Data Warehouse data source.
Fixed an issue where the Browser window will be blank if using a a data source that is incomplete, a message will now be displayed.
Fixed an issue where an error is thrown when cancelling a Business Central login request.
Fixed an issue where unnecessary worksheet searching was causing a slowed performance.
Fixed an issue where non batched Jet functions on worksheets that do not contain an NL(Table) are not converted to values.
Fixed an issue where opening a report with a Nav Web Services data source will crash Excel.
Fixed an issue where Office 2010 does not display the report progress window or report run times.
Fixed an issue where a report throws an exception if run against a Nav Web Service data source.
Fixed an issue where if one data source cant connect then the data sources drop down in the browser will be empty.
Fixed an issue where '+Values' will cause an empty cell to be converted to 0 on 'Run'.
Fixed an issue where loading dimension values in a Cube data source caused a report to show the correct values only after the second run.

GP Update Utility
Fixed an issue where running the utility against a database that already has some of the components will produce an error.

 

Jet Reports 2019 Build 19.0.18268.1

October 1, 2018

Initial Release of Jet Reports 2019

Improved Performance with XLL Multi-threaded Add-in	The Jet Excel add-in is now based on the Excel’s XLL format.  This provides several benefits - including a performance boost, with some reports running up to 5 times faster.
Business Central Data Source Connection	Dynamics 365 Business Central users can connect Jet Reports directly to their Business Central data base.  Each user can use their Office 365 credentials to make their connection.
Simulate Jet Reports Financials within your Jet Reports Excel add-in	For those Business Central customers and partners needing to support both Jet Reports and Jet Reports Financials, a new simulation mode has been added to Jet Reports to allow you to use the full Excel add-in as through it were an installation of Jet Reports Financials.
Updated Report Wizard	Continuing with efforts to bring all the Jet add-in features in line with a consistent look as well as providing intuitive and easy to use interactions, the interface for the Report Wizard tool has been updated.
Update Notification when a new version of Jet Reports is available	A new notification button has been added to the Jet ribbon to let users know when a new version of the Excel add-in is available.
+VALUES automatically added to reports	When running a new Jet report for the first time, in addition to Auto+Hide, +Values will now be added to cell A1.  This has been a popular request in our ideas portal.
The Jet Services Database is Backed Up during Upgrade	The Jet Reports installation program now includes the option to backup the existing Jet Service Tier database prior to updating or replacing it as part of the installation process.
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.
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
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
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.

Jet Professional 2018 R2 Build 18.5.18215.2

Aug 6, 2018

Changes since 18.4.18186.3

Excel Add-In
Fixed an issue where access database data source does not support sub query evaluation.
Fixed an issue where date flow fields with Min and Max calc formulas do not work in NAV SQL or Remote Service Data Sources.
Fixed an issue where running a report with batch execution turned on will return #VALUE! throughout the report.
Fixed an issue where empty filter field displays the Info-Warning only in English.
Fixed an issue where Fast Financials instructions only appeared in English.
Fixed an issue where the workbook save warning only appeared in English.

Jet Web Portal
Fixed an issue where the default sort of folders was random.
Fixed an issue where in some languages, field names are cut off or do not fit on the page.
Fixed an issue where an invalid error message is thrown when adding users in the Jet Web Portal.

Jet Professional 2018 R2 Build 18.4.18186.3

July 16, 2018

Changes since 18.3.18165.4

Excel Add-In
Fixed an issue where some captions for "OK" buttons in Japanese contained brackets.

Jet Web Portal
Fixed an issue where certain large reports would sometimes not upload from the Jet Web Portal.
Fixed an issue where reports containing NL(Picture) functions referencing local file paths would return a confusing error message.
Fixed messaging displayed when SMTP settings were not configured.
Fixed an issue where the dialog used to update a user's email address would not load with the cursor focus set to the email address field.
Fixed messaging in the scheduler regarding authenticating a scheduled task.
Fixed an issue where adding users with a domain that contains "." would truncate that domain value.
Fixed an issue where page styling would become inconsistent after using the report options lookup feature.
Fixed an issue where reports uploaded that are too large in size would not cause an error as expected.
Fixed an issue where the back button in the report details pane would not correctly return the user to the list of reports.
Fixed an issue where pasting text into required fields of "New" dialog windows would not correctly enable the "Create" button.
Added missing translations for welcome message.
Fixed an issue where choosing to cancel a report lookup option would cause the settings menu to no longer open.
Fixed an issue where navigating away from a scheduled task that contains pending changes would sometimes not prompt to save.
Fixed an issue where adding an existing report to a scheduled task would sometimes disable the ability to edit the report options.

Dashboard Builder
Fixed an issue where text that is unable to fit within the confines of a button was being cut off.

Jet Professional 2018 R2 Build 18.3.18165.4

June 25, 2018

Changes since 18.1.18149.1

Excel Add-In
Fixed an issue to provide a more informative error message when an incorrect server is entered within the Jet License Activation window
Fixed an issue where dimension value filters were case sensitive within GL(Budget) functions.
Fixed an issue when running reports with a Czech language pack in Excel would display an exception error message.

Jet Web Portal
Fixed an issue to limit the length of folder names to 256 characters.
Fixed an issue where the 'clear filters' button within a dashboard slicer was not labeled.
Fixed an issue where grabbing a dashboard slicer tab would drag the whole visual within the Jet Web Portal.
Fixed an issue where adding a group to the Jet Web Portal would occasionally invite a user outside of the invited group.
Fixed an issue where the Jet Web Portal would not display an error message when an incorrect password was used during the creation of a scheduled task.
Fixed an issue to rephrase the error message displayed when a scheduled task attempts to send an email with incorrect email settings or the task credentials are invalid.

Background Reporting
Fixed an issue where monitors with higher scaling percentages would move the tray application off of the screen.
Fixed an issue where running a report with report options from a device with a high screen resolution forces the tray app off of the visible screen.

Dashboard Builder
Fixed an issue where adjusting a range slicer would freeze the dashboard to the newly specified range.

Admin Console
Fixed an issue where saving a change within the Jet Administration Console would revert a user's email address back to the email that is associated with that user in the Active Directory.

Jet Professional 2018 R2 Build 18.1.18149.1

June 4, 2018

Changes since 18.1.18137.5

Excel Add-In
Fixed an issue where look-ups for dates, segments, and segment values were not correctly showing localized names.
Fixed an issue where dates returned from a GL() function would not be formatted correctly.
Fixed an issue where using Windows authentication for a NAV SQL direct data source would not behave as expected.
Fixed an issue where the report drop-down within the Upload Report window would not scroll correctly through the list of reports.

Jet Web Portal
Fixed an issue where using Windows authentication for a NAV SQL direct data source would not behave as expected.
Fixed an issue where all dashboards would fail to load when the user did not have permissions to one of the dashboard's supporting cubes.
Fixed an issue where data source look-ups in report options would not work as expected after upgrading to a new version of the Jet Web Portal.
Fixed an issue where some reports containing custom modules would not upload to the Jet Web Portal.
Fixed an issue where uploaded reports containing macros would sometimes become corrupted when run.
Fixed an issue where reports run in the Jet Web Portal containing an NL(Sheets) function would result in a corrupted workbook.
Fixed an issue where NL(Filter) functions that contain a blank value in the results would sometimes cause an error to occur.
Fixed an issue where the "User Name" field would sometimes read as "Usename" upon sign-in.
Fixed an issue where the right-click context menu would sometimes not appear as expected after navigating to a folder.
Fixed an issue where reports with a longer than usual description would sometimes cause errors to occur and cause the report to become inaccessible.
Fixed an issue where lookup dates were not being displayed in the correct format.
Fixed an issue where downloading a report with a "." in the file name would remove the Excel extension of "xlsx".
Fixed an issue where an empty error was being shown when uploading a report when no data sources have been configured.
Fixed an issue where navigating to a non-existent report would not fail with a useful error message.
Fixed an issue where users configured via Groups would be unable to upload reports from the Excel add-in.
Fixed an issue where reports containing "+Lock" would not be protected as expected.
Fixed an issue where report options that are changed before running a report would revert the report options to their original values.

Background Reporting
Fixed an issue where dates from cube data sources were not being properly formatted.

Installer
Fixed an issue when installing Jet Professional where a Jet Service Tier host configuration that contains a "\" would cause Excel to report an error when launched.

Jet Professional 2018 R2 Build 18.1.18137.5

May 21, 2018

Changes since 18.1.18101.2

Excel Add-In
Fixed an issue where sorting in the report options window was not functioning as expected.
Fixed an issue where a confusing error message would be displayed when an empty filter was not allowed in a Jet function.
Fixed an issue where the Jet Database Caption Editor would fail when connected to the Jet Service Tier.
Fixed an issue where the Activate Jet Professional button could be hidden from the ribbon in Jet Express.
Fixed an issue where clicking the function drop-down inside the Jfx Window while editing a report option lookup would sometimes cause an error to occur.
Fixed an issue with batch function optimization where functions referencing relative named ranges would not be included in the batch.
Fixed an issue where Excel 2010 would produce a cryptic error message when auto-debugging #VALUE! cells.
Fixed an issue where connecting to Jet Service Tier versions 18.0 or earlier would cause errors to occur when using the Jfx.
Fixed an issue where Table Builder templates were available to Jet Express users.
Fixed an issue where Fast Financials would not function as expected while using languages that have report option names with illegal named range characters.
Fixed an issue where pressing F8 within the Jfx window when no report options exist would cause an error to occur.
Fixed several layout issues when using languages with messaging that is longer than English messaging.
Fixed an issue with batch function optimization where #VALUE! cells would appear with function tables array.
Fixed several usability issues within the Fast Financials window.
Fixed an issue where an error would occur when attempting to upload a report from their OneDrive rather than a descriptive message.

Jet Web Portal
Fixed an issue where reports and folders would sometimes be unable to be de-selected.
Fixed an issue where a report downloaded from the Jet Web Portal could not be uploaded by another user.
Fixed an layout issue in the "Create New Folder" window.
Fixed a layout issue in the search box where text would sometimes overlay the "X" used to clear the search.
Fixed an issue where non-English locales would sometimes display a login error message in English.
Fixed an issue where non-English locales would display a session timeout message in English.
Fixed an issue where a session timeout would result in the display of an unrelated string error message.
Fixed an issue where the report details page was not updating correctly when the report was running.
Fixed an issue where an object reference error would be mistakenly displayed after a session time out or log out.
Fixed an issue where reports containing the EOMONTH() function was not evaluating correctly within reports run in the Jet Web Portal.
Fixed an issue where some reports fun in the Jet Web Portal would end up being corrupted.
Fixed an issue where some report option lookup values were not displaying correctly.

Background Reporting
Fixed an issue where uninstalling Jet Professional would fail if the background reporting tray application was open.
Fixed the messaging when closing a report for background reporting.
Fixed an issue where closing the background reporting application would sometimes cause an error to be displayed.
Fixed an issue where opening a report in background reporting while a different report is running would sometimes not function as expected.
Fixed an issue where the background reporting application could not be exited while reports are running.
Fixed an issue where cancelling reports running in the background would sometimes cause the report to remain in read-only mode.

Jet Professional 2018 R2 Build 18.1.18101.2

April 19, 2018

Initial Release of Jet Professional 2018 R2

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

Run Reports directly from your Windows Desktop	Run your reports without even starting Excel!  Just right-click.  The new task tray app will let you know when your report is ready.
Run Reports in the Background within Excel	No need to wait for your report before you can start using Excel, again.  Run your report in the background and continue working with your other Excel files.
Updated Jet Ribbon and Windows within Excel	The Jet ribbon has been updated and the entire user interface has been refreshed to be more consistent, throughout. Several items have been rearranged to be easier to find, and other related items have been grouped together for a cleaner experience. All configuration settings have been combined under a single button The run options have also been consolidated. In an effort to better explain what they do, the Refresh and Report buttons have been renamed to Run and Run from Cache, respectively.
Fast Financials Updated	To make it easier to select/deselect your Fast Financials accounts, each account can be toggled on and off with a simple click of the mouse – and you can still use the SHIFT key to quickly select a range of accounts. To make copying or adding replicating functions easier than ever, your Fast Financials Report Option dates are now also placed directly on the report sheet. The GL functions and the variance formulas reference those dates, rather than the named ranges on the Options sheet.
Manage Users and Groups in the Jet Web Portal	Now manage your users and groups directly within the Jet Web Portal. Users and Groups added here can also be seen/managed in the Jet Administration Console and can be assigned the new levels of permissions within the Jet Web Portal, itself. And, non-administrator users can now be given permissions to create, rename, move, and delete folders, as well as to change the owner of an existing report.
Compatible with Dynamics NAV 2018	Our testing with Dynamics NAV 2018 has been completed and Jet Professional 2018 R2 fully supports this exciting update. When used with NAV Web Services, version 2018 R2 of the Jet Excel add-in requires the latest release (12.6) of the Jet Reports Business Objects.

 

Jet Professional 2018 Build 18.0.18060.4

March 8, 2018

Changes since 18.0.18039.1

Excel Add-In
Fixed an issue where some queries would return an error when run in regions where commas are used as decimal points.
Fixed an issue where viewers would sometimes be presented with an error within cell A1.
Fixed an issue where worksheets containing more than one NL(Table) function would only create the first table defined.

Jet Web Portal
Fixed an issue where certain reports would present an error about circular references when run in the Jet Web Portal.
Fixed an issue where nested replicators in certain reports would cause additional data to be returned to the worksheet.
Fixed an issue where cell reference values would sometimes be removed after a report is run in the Jet Web Portal.
Fixed an issue where reports run in the Jet Web Portal that contain cells with #VALUE! would not allow the user to use the "Check error" button in the Jet Ribbon when the report is opened in Excel.
Fixed an issue where reports containing an NP(Eval) function of a named range pointing at '|' separated date ranges would return #VALUE!.
Fixed an issue where certain reports run in the Jet Web Portal would cause the workbook to become corrupted.
Fixed an issue where NP(Eval) functions of a named range that are nested within an IF statement would not evaluate correctly when run in the Jet Web Portal.
Fixed an issue where some reports run in the Jet Web Portal would cause an error from circular references.
Fixed an issue where report option formulas would sometimes be overwritten when the report containing them would be run in the Jet Web Portal.
Fixed an issue where data validation in a report run in the Jet Web Portal would sometimes not expand correctly.
Fixed an issue where some reports uploaded to the Jet Web Portal in Report Mode would sometimes lose data.
Fixed an issue where renaming sheets that contain charts would cause the charts to lose references when run in the Jet Web Portal.
Fixed an issue where reports containing math calculations using a cell reference would sometimes return #VALUE!.
Fixed an issue where certain reports run in the Jet Web Portal would return the error "Object reference not set to an instance of an object".
Fixed an issue where report charts would behave differently in some cases when the report is run in the Jet Web Portal.
Fixed an issue where some reports run in the Jet Web Portal would return empty cells where a #VALUE! is expected.
Fixed an issue where structured references were not supported in the Jet Web Portal.
Fixed an issue where reports run in the Jet Web Portal containing NL(Table) formulas referencing an NP(Formula) function within a column would result in a corrupted workbook.
Fixed an issue where running certain reports in the Jet Web Portal would sometimes result in workbook comments becoming corrupted.
Fixed an issue where reports run in the Jet Web Portal would sometimes not refresh Subtotal amounts automatically.
Fixed an issue where reports containing NL(Table) functions run in the Jet Web Portal would sometimes use incorrect number formats.

Jet Professional 2018 Build 18.0.18039.1

February 15, 2018

Changes since 18.0.18018.1

Excel Add-In
Fixed an issue where large reports would sometimes exhibit less than desirable behavior, including long open and run times.
Fixed an issue where batch function optimization would sometimes incorrectly evaluate functions to #VALUE!.
Fixed an issue where Fast Financials would add the incorrect formula when drag-and-dropping accounts after performing a drilldown.
Fixed an issue where NL functions referencing || in the Table argument would sometimes return #VALUE!.
Fixed an issue where nested replicators would sometimes not expand as expected.

Jet Web Portal
Fixed an issue where data validation did not work correctly in some cases.
Fixed an issue where certain reports utilizing a GP data source would not upload correctly.
Fixed an issue where reports containing "\r\rn" in a formula would not upload correctly.
Fixed an issue where uploading a report with an NL(Table) function that contains no value in the Fields argument would cause the workbook file to become corrupted.
Fixed an issue where uploading a report with an NL(Table) function with an empty value for the "Headers=" special filter would cause the workbook file to become corrupted.
Fixed an issue where the available users for selection in the "Change Owner" window would not be a complete list of all users.
Added the error detail to the report detail page if the report failed to upload completely.
Fixed an issue where report options would become scrambled when run as a scheduled report.
Fixed an issue where reports containing data from multiple companies would sometimes not run correctly in the Web Portal.

Jet Professional 2018 Build 18.0.18018.1

January 25, 2018

Changes since 18.0.17362.4

Excel Add-In
Fixed an issue where Office365 authentication was not functioning properly when configured for a NAV data source that supports it.
Fixed an issue where reports containing a cell with a very large value would sometimes throw an exception.
Fixed an issue where certain report option values would sometimes cause an original function to be removed from the report.
Fixed an issue where switching report modes after using certain features of the Jfx could cause Excel 2010 to hang until it was refocused.
Fixed an issue where Excel 2010 would sometimes not retain application focus after closing the Jfx.
Fixed an issue where refreshing certain reports would take much longer to run than switching from design mode to report mode.
Fixed an issue where scheduling reports containing hidden rows or Values Only would sometimes not behave as expected when batch function execution is enabled.
Fixed an issue where report option lookups on NAV date fields would only show time values.
Fixed an issue where NL(Filter) formulas using a filter value containing <, >, <>, .., etc would not work as expected when run against a NAV Direct SQL data source.
Fixed an issue where subsequent runs of a report after its initial run would sometimes not update report option values correctly.

Jet Web Portal
Fixed an issue where a report downloaded from the Web Portal would sometimes require a workbook repair.
Fixed an issue where conditional formatting rules would sometimes be lost after downloading the results of a report run from the Jet Web Portal.
Fixed an issue where some Jet functions' "what" argument could replace the "what" argument of other Jet functions in the report.
Fixed an issue where some reports utilizing a GP data source would sometimes fail to upload to the Jet Web Portal.
Fixed an issue where reports localized in German that contain NP(Eval) formulas would sometimes fail to upload to the Jet Web Portal.
Fixed an issue where reports in an error state would sometimes be inadvertently removed from the Jet Web Portal under certain conditions.
Fixed an issue where clicking "Next" or "Prev" to navigate between pages of items would sometimes display the wrong items.
Fixed an issue where reports with Jet functions that contain embedded functions would sometimes fail to upload to the Jet Web Portal if the embedded function uses a semi-colon list separator.

Jet Professional 2018 Build 18.0.17362.4

January 4, 2018

Changes since 18.0.17355.0

Excel Add-In
Fixed an issue where lists of tables in the Jfx and Table Builder would sometimes not be sorted correctly.
Fixed an issue where creating a report option lookup using the Jfx would produce an error when pressing ESC.
Fixed an issue where certain reports that ran correctly in the previous version of Jet Professional failed to run successfully in the latest version.
Fixed an issue where drilling down from within the Jfx window in any non-English locale would not work as expected.

Jet Web Portal
Fixed an issue where named ranges that contain any formulas could not be used as arguments to Jet functions.
Fixed an issue where Jet replicator functions that are nested in Excel functions would require the drilldown button to be clicked twice. 
Fixed an issue where reports would fail to publish when external links did not actually exist.
Fixed an issue where reports containing an NL(Picture) function would produce different results in the Web Portal than in the Excel Add-In.
Fixed an issue where some reports with nested replicators in a region larger than its parent's region would not correctly produce an error.
Fixed an issue where conditional formatting would sometimes not work correctly in reports run in the Web Portal.
Fixed an issue where NL(Filter) functions using "Filters=" did not work correctly in the Web Portal.
Fixed an issue where report options containing a date with "Long date" formatting date would sometimes have its formatting removed when running the report in the Web Portal.
Fixed an issue where some reports containing || filters would fail to publish or upload to the Web Portal.
Fixed an issue where some reports containing references to an Excel EOMONTH() function would fail to publish or upload to the Web Portal.
Fixed an issue where reports containing multi-company GL() functions against a GP data source would not run successfully in the Web Portal.
Fixed an issue where NL(Lookup) functions nested within Excel functions were not handled correctly in the Web Portal.
Fixed an issue where reports run in the Web Portal would sometimes produce cells containing #VALUE! instead of being empty as expected.
Fixed an issue where conditional hide did not work as expected in the Web Portal.
Fixed an issue where some reports would become corrupted after uploading or publishing them to the Web Portal.
Fixed an issue where reports containing DAYS functions in a language other than English would produce #VALUE! when running the report in the Web Portal.
Fixed an issue where reports containing NL(Sheets) functions would not produce the expected results when run in the Web Portal.
Fixed an issue where reports containing multiple NL(Sheets) functions would cause an error when uploading or publishing to the Web Portal.
Fixed an issue where some reports would fail to upload or publish to the Web Portal.
Fixed an issue where NL(Filter) functions nested in other functions would not work as expected in the Web Portal.
Fixed an issue where some reports downloaded from the Web Portal would leave Excel unresponsive when switching to Design mode using the Excel Add-In.

Jet Professional 2018 Build 18.0.17355.0
December 27, 2017

Changes since 18.0.17349.0

Excel Add-In
Fixed an issue where batch optimized functions that depend on report options would sometimes return wrong values.

Jet Professional 2018 Build 18.0.17349.0
December 19, 2017

Changes since 18.0.17342.2

Excel Add-In
Fixed an issue where reports would sometimes fail to run on non-English systems.
Fixed an issue when performing a drilldown within the Jfx using a NAV Web Services data source would sometimes only return the first row.
Fixed an issue where dragging and dropping report option lookups for Universal and Warehouse data sources sometimes failed to function correctly.

Jet Web Portal
Fixed an issue where some reports containing cross-sheet range references failed to upload to the Web Portal.

Jet Professional 2018 Build 18.0.17342.2
December 14, 2017

Excel Add-In
The cells contained within the report options window from the Jfx are now selectable.
Fixed an issue where dragging fields from the Browser would sometimes insert the wrong function into the report.
Fixed an issue where navigating away from the advanced page of a new universal data source settings before configuring the connection would sometimes produce an exception.
Fixed an issue where batch function optimization would cause cells to produce #VALUE! as the result.
Fixed an issue where the Browser and Fast Financial windows would not appear above the Excel workbook when more than one workbook was open.
The report options lookup window can now be resized.
Fixed an issue where using the Jfx from within the report options window would sometimes send the Excel window to the background when the report options window was closed.
Usability of the report options window has been improved
 - Tabbing moves you through each option value allowing you to edit the values.
 - Single-clicking a cell edits the value.
 - Clicking or tabbing to edit a cell selects the entire value.
 - ENTER runs the report.
Tooltips appear when hovering either over the title or the value.
Fixed an issue where the options tab within the scheduling window would sometimes disappear when selecting a new tab.
Fixed an issue within Fast Financials where dragging and dropping large amounts of data, then quickly closing the window would sometimes cause Excel to terminate unexpectedly.
Fixed an issue where batch function optimization would sometimes fail when an NP(Eval) function referenced a named range which contains a Jet function.
Fixed an issue where Excel 2010 users would not see updated icons.
Fixed an issue where batch function optimization would fail for a report containing an NL(Filter) function as a filter.
Fixed an issue where the Fast Financials tool would sometimes cause Excel to terminate or become unresponsive when selecting all accounts, all headers, and all columns.
Fixed an issue where large reports would sometimes cause Excel to run out of memory.
Fixed an issue where cancelling a running report with function optimization enabled would sometimes damage the report.
Fixed an issue where an NL(Sheets) function would sometimes produce incorrect sheet names.

Jet Web Portal
Fixed an issue where a report containing an NL(Picture) function would run significantly slower as compared to running within the Excel Add-In.
The icon for a report in a cancelled state now differs from the icon for a report in an error state.
Modified the report details page to no longer accept script tags in the name and description fields.
Fixed an issue where running a report while other reports are uploading would sometimes cause the running report to persist the running state even after the report completes.
Fixed an issue where opening multiple reports into Excel Online would only open the first report.
Fixed an issue where reports containing cross-sheet referenced would fail to upload.
Fixed an issue where successfully publishing a report from the Excel Add-In would sometimes not clear a previous upload error state.
Fixed an issue where some scheduled reports would produce a time-out exception.

Jet Professional 2018 18.0.17321.0
November 27, 2017

Changes since 18.0.17307.5

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

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

Jet Professional 2018 Build 18.0.17321.0

Initial release of Jet Professional 2018

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

Fast Financials	The Fast Financials feature for Dynamics NAV provides a fast and easy way to create financial reports.
Updated Jet Ribbon in Excel	The Jet ribbon within Excel has a new, contemporary look. Outdated features (i.e., Report Builder) have been removed, new features added, and other items have been updated to make them easier to find and use.
Updated Windows	Windows within the Jet Excel add-in have been given a consistent and more contemporary look.
Enhanced Control of the Jet Ribbon	The Jet Application Settings give you more control over the Jet Ribbon than ever before. Do you only use the GL function? Make it the only button available in the Jet Function Wizard (Jfx). Want to see all the Jfx buttons on the ribbon? Select the new Expanded Menu option. Make the ribbon look just the way you need for the way you build and view your reports.
Domain Change for NAV Logins	Those Dynamics NAV users whose data resides outside their standard Windows domain can now specify the necessary domain as part of the username in their data source settings.
Help Menu Updated	The Jet Help Menu has been simplified to correspond to the consolidation of the Jet Reports Support, Help, Knowledgebase, and Community web sites. All of these can be accessed through the single Help Center option.
Specifying Domain Name during Login	In the Jet Web Portal, you can change the domain name associated with your login by entering a different name using either down-level (also known as 'server/username') format or UPN (also known as 'email') format.
Context Sensitive (right-click) Menus	The Jet Web Portal now features right-click menus that reflect the same options available on the action panel.
Easier Scheduling	In the Jet Web Portal, scheduled tasks can be created directly form the Reports List by selecting the desired report(s), and then either selecting Schedule from the action pane or right-clicking and selecting Schedule from the context menu.
Options for Opening Reports	To help everyone understand how to open reports in the Jet Web Portal, once you select one or more reports and click Open you will be prompted to decide if you want to open the reports with Excel Online or want to download the report and open it with an installed version of Excel.
Timeout Feature	When the Jet Web Portal has been left inactive for 20 minutes, a 60-second reminder will be displayed asking if you wish to stay logged in.  If no response is received, you will be logged out.  When you log back in, you will be taken directly to the screen you were on when your session timed out.
Support for More Jet Features	In Jet 2018, the Jet Web Portal supports Dashboard mode as well as the NL(Picture) and NP(Slicer) functions.
Support for More Excel Functions	In Jet 2018, the Jet Web Portal supports additional Excel functions:  RADIANS FACTDOUBLE SEC, SECH, CSC, CSCH, COT, COTH, ACOT, and ACOTH RANK, RANK.EQ, RANK.AVG CEILING.MATH, FLOOR.MATH STDEVA, STDEVPA, VAR.S, VAR.P, VARA, VARPA TIMEVALUE

Jet Professional 2017 R3 Build 17.2.17251.1
September 14, 2017

Changes since 17.2.17230.4

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

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

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

 

Jet Professional 2017 R3 Build 17.2.17230.4
August 24, 2017

Changes since 17.2.17209.1 

Jet Excel Add-In

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

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

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

Jet Professional 2017 R3 Build 17.2.17209.1

August 3, 2017

Initial release of Jet Professional 2017R3

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

• Upload Report from with the Jet Web Portal
• Directly Link to Jet Enterprise Dashboards
• Publish Reports to Web Portal Folders
• Record Keys now available when reporting form a Jet Enterprise Data Warehouse
• Error Logging in the Jet Web Portal

Jet Professional 2017 R2 Build 16.1.17145.0
May 31, 2017

Changes since 16.1.17118.0 

Installer
Fixed an issue where the installer would not stop the Jet Service tier before an upgrade installation.
Fixed an issue where the Customer Experience Improvement (CEIP) window was not displayed on clean installation.

Jet Excel Add-in
Fixed an issue where a Nested NL(Filter) added ‘||’ symbol to SELECT statement and eventually caused the reports to fail.
Fixed an issue where F1 would opens an incorrect web page when pressed from the Report Option windows in the Jet Excel Add-in.
Fixed an issue where reports that used NL(Count,NL(Intersect,NL(Filter),NL(Filter))) with +VALUES returned #VALUE.
Fixed an issue where a corrupted Settings.xml files would create multiple exceptions which, in turn, would crash Microsoft Excel.

Jet Web Portal
Fixed an issue where published reports failed to run on the Jet Web Portal when using result of NF() as filter.
Fixed an issue where certain formatting and Fit tags caused reports to fail on the Jet Web Portal.
Fixed an issue where certain reports that used MONTH() and DAY() arguments with undocumented Excel behavior failed to run on the Jet Web Portal.
Fixed an issue on the Jet Web Portal where scheduled tasks disabled using the “disable” button on the toolbar would not be disabled.
Fixed an issue where reverse sign option did not behave as expected for target value of performance tiles on the Jet Web Portal.
Fixed an issue where an error log was not being created when the process running the report crashed on the Jet Web Portal.
Fixed an issue where reports with an NF() filter on a FlowField returned incorrect values when run on the Jet Web Portal.
Fixed an issue where reports with IFERROR(INDEX(MATCH)) did not work properly on the Jet Web Portal.
Fixed an issue where Scheduled tasks executed from the Jet Web portal on a non-US locale Windows OS passed the dates in US format instead of local format.
Fixed an issue where reports with a filter on a FlowField for <>0 would generate an IndexOutOfRangeException on the Jet Web Portal.

Jet Dashboard Builder
Fixed an issue where reverse sign option did not behave as expected for target value of performance tiles in Dashboard Builder.

Jet Professional 2017 R2 Build 16.1.17118.0
May 4, 2017

Changes since 16.1.17100.0 

Jet Excel Add-in
Fixed an issue in Jet Excel Addin -> Data sources – Advanced Tab where text was cut-off for Cfront data sources.
Fixed an issue where reports with an Excel Subtotal function returned incorrect results when executed in the Web Portal.

Jet Web Portal
Fixed an issue where reports with non-English Jet tags threw an InvalidFieldException in the Web Portal.
Fixed an issue where the column headers were truncated when resizing the scheduler and reports pages.
Fixed an issue where some reports ran slowly in the Web Portal.
Fixed an issue where a catastrophic failure error occurred whenever a non-admin user tried to run a report in the Web portal.
Fixed an issue where some character combinations in the Web Portal User’s password caused a server error and displayed the password on the event viewer.
Fixed an issue where reports with German 'Umlaute' (such as ö, ä, ü) in the name would crash Internet Explorer when it attempted to download from the Web Portal.
Fixed an issue where some reports would generate a “Domain not found“ error and failed to publish to the Web Portal.

Jet Professional 2017 Build 16.1.17100.0
April 14, 2017

Changes since 16.1.17081.0

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

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

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.

Changes since 16.1.17033.0

Jet Excel Add-in

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

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

Jet Professional 2017 Build 16.1.17033.0

February 7, 2017

Initial release of Jet Professional 2017R2

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

 

Overview of Jet Reports 2017 R2

 

Web-Based Scheduling

 

GL Drilldown for Dynamics GP

 

Report Options Design Tool

 

• Jet Web Portal Scheduling
• Improved Drilldown Experience for Jet Web Portal Reports
• Drilldown for Dynamics GP G/L Reports
• Improved User Experience in the Jet Web Portal
• The Jet Web Portal now replaces the iPad app for iPad users.  The iPad is no longer supported
  
  

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

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

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