Skip to main content

NAV 2013 R2 - JET REPORT Configuration with NAV - Part 1

Hi all,

I guess most of us know how to install JET Reports. If you still don't know then just follow the steps in Post.

The Configuration before NAV 2013 is different than in NAV 2013 or Later.

Reason - JET Report used C Front till NAV 2009 R2 to connect to database. As now C Front component have been discontinued by Microsoft.

How Jet Report Connects to Navision Database in NAV 2013 onward?

JET Report usages web services to connect to the database.

What we will cover in the post?

We will see, How to -
 1) Install Jet Reports.
 2) Jet Report Objects (Require to import them before configuring).
 3) Create a new service or you can use the same service. (I Prefer a new one)
 4) Create a web service by connecting to windows client.
 5) Setup Web service details into JET Report in Excel.
 6) Provide the license (Licensing have also been changed by Jet Report. Now you require the activation code.)


So Let's Begin -

1 Install Jet Reports.

- Download the Latest Build of Jet Report LINK.



- Unzip the downloaded File in step 2 and Install the JET from Client Component based on your excel version (32 / 64 bit).
How to check excel version

- During Installation it will ask for activation code.


- Activation Code is Provided by Jet Report in the Email when you purchase / Upgrade your License.
OR
You can ask for activation code from LINK.

Enter your details -
  Email address as per license.
  Jet License Number ( you can find it in your license file as shown below)

Once you click submit on activation page as shown below.



After few hours you will get the activation code on email.

2 Jet Report Objects.

- You can find the objects in the downloaded folder of Jet Report under Server Component.
FileName - Jet Reports Objects.fob 

OR

Download the Objects required for Navision database. Link



- Import objects into Navision database on which you want to configure the JET Reports.



3. Create a new service or you can use the same service.

Now we need to create a new service for Jet Reports.
*How to create New Service Instance in NAV 2013 R2

I have created a Service Named as Jet Report with Port 1045,1046,1047 & 1048.



We have covered Three Parts of our agenda, In Next Post we will see how to do rest of configuration.

Thanks & Regards,
Saurav Dhyani

Comments

Popular posts from this blog

BC 21 and Higher - PowerShell Cmdlet (Replacement of Business Central Administration).

Hi Readers, As discussed in last article about deprecating of Business Central Administration, there are few common actions that we use in administration till Business Central 20. For our on-prem customers, we will still require doing activities. As Microsoft suggest we need to start using PowerShell cmdlet.    Let's see how to do those via PowerShell, or Administration Shell. I will be keep adding commands as you comment to this article.

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

MSDYN365BC - Data Upgrade To Microsoft Dynamics 365 Business Central on premises.

Hi Readers, We have already talked about the number of steps for upgrading to Business Central on Premises from different NAV versions. After that article, I received multiple requests for an article which list down steps for Data Migration. In this article, we will discuss steps of data migration to MSDYN365BC (on-Prem) from NAV 2017. For this article, I am considering a Cronus Demo Database without any customization. For an actual upgrade project, we will have to complete object merge using compare and Merge process. After the Merge Process, the next step is data migration. Let's discuss those steps. Direct Upgrade to Microsoft Dynamics 365 Business Central (on-Prem) is from following versions - 1. NAV 2015. 2. NAV 2016. 3. NAV 2017. 4. NAV 2018.