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
Labels:
Location: Sector 62, Noida, Uttar Pradesh, India

Comments

Post a Comment

Popular posts from this blog

VIEW SERVER STATE permission on SQL Server?

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------
10 comments
Read Complete Article »

RTC Report It is not possible to instantiate the Visual Studio bridge.

Hi all, As a Navision developers I have Multiple Versions of Navision running in single Machine. As discussed Earlier in the post how to run multiple Version of RTC in single machine. So my machine have following details for RTC Versions - NAV 2009 R2    - is installed. NAV 2009 SP1  - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 SP1 IN\ NAV 2009         - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 IN\ This approach has been working great for execution of Classic and RTC Clients. However, after installing Dynamics NAV 2009 R2, if i tried to view the Layout for an NAV 2009 SP1 Report i was getting the following error: ---------------------------  Microsoft Dynamics NAV Classic  ---------------------------  It is not possible to instantiate  the Visual Studio bridge.  ---------------------------  OK    --------------------------- After searching for the error i figured out the issue was due to - Design change in NA
4 comments
Read Complete Article »

NAV 2013 R2 - Cumulative update 12 Released.

Hi all, Please find below the details of  Cumulative Update 12 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 12 for Microsoft Dynamics NAV 2013 R2 Build No. - 38053 Release Date - October, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK, RU Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.
Post a Comment
Read Complete Article »