How to install Jet Reports for Dynamics 365 Business Central?

Install
  • Find the files where they are downloading in your browser.
Installer
  • After the downloading is complete, you can go to the folder where the files are downloaded.
Reports
  • Right-click on the file and extract its contents…
Reports
  • Open folder 1 – Jet Reports – REQUIRED and run the Jet Setup.exe file. You can only install a single version of Jet Reports at a time. This makes upgrading the current version easy as the newer version of Jet Reports replaces the older version.
Reports
  • You will see the End User License Agreement which needs to be scrolled till the end to be able to Agree.
Install Jet Reports
  • During the Installation process you have different options and can proceed with only Client Components, only Server Components, or All Components:
install jet reports

Client Components are those applications that reside on your local system. Jet Excel add-in is the primary example of this.
Server Components are those applications that typically reside on a server (for example, Jet Hub and the Jet Service Tier). These would require an administrator to implement them properly.

We will choose Client Components in order to install the Jet Excel add-in.

  • After selecting Client Components, you have to select the specific features you want to install.
install jet reports
  • You will be prompted to enter the Activation code, sent to you at the time of purchasing Jet Reports.
Install Jet Reports
This code looks something like this:
12ABCD34-56E7-890F-A1BC-234D567EF89A

Follow the Activation Instructions to activate your installation of Jet Reports.

  • You can finally click the Install button to complete the process and install Jet Reports.
install jet reports

Configuring your Jet Reports Data Source

The Jet Excel add-in supports data source connections to Dynamics NAV, Dynamics GP, Jet Analytics Cubes, and Jet Analytics Data Warehouses.  In addition, you can define “Universal” data source connections to MSSQL databases as well as most databases that provide an OLE (preferred) or ODBC connector.  Configure the settings for the data source license you received:

install jet reports

Now you can operate jet reports for business central. You can also check out various Jet functions such as NL FunctionNF Function, and NP Function.

If You Need Any Help, Contact us Now!

Scroll to Top