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

Configuring a Jet Remote NAV Data Service Data Source in Jet Excel add-in - Users' Guide

Configuring the data source connection in the Jet Excel add-in


The first step in the Jet add-in is to create a new data source of the type “Dynamics NAV 2013 and later (Remote Data Service)”.

Next, the authentication information needs to be configured. These options are the same credentials that are used to access NAV.

The user can authenticate against the JRDS using any one of the following:


  1. their own Windows credentials (this usually only applies to demo environments)
  2. another user's Windows credentials (e.g., a user on a different domain - usually the domain where the data resides)
  3. NAV User Password credentials.

You will need to contact your system administration to obtain the exact settings being used in your organization

In this example, Windows authentication is selected for a user account on a separate domain.


Figure 1 - Windows authentication for the current user is the selected authentication scheme


note: It is expected that users will be given a username, domain, and password to use for authentication - the same used to connect to the NAV RTC or Web Client.  System administrators should see the JRDS Admin Guide for more details.

Finally, the connection information to the instance of the JRDS must be configured.

Figure 2 - Connection configuration for an instance of the Jet Report Data Service

The marked settings shown in Figure 2 will come from your system administrator.

If the settings are correct, the dropdown to select the company will populate when opened.


All remaining settings pages are typical of other NAV data sources.  Be sure to select the desired drilldown type and, in the case of RTC drilldown, the directory where the RTC is installed.

Important Note:
When upgrading versions of Jet to a much newer release, ensure that both the Jet Remote Data Service version installed on the server and the client versions are on the same version to reduce potential issues.
Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request