Skip to main content

Configuration of JET Reports.

Hi all,

For Installation of JET Report Please refer post.

Let's see how to configure JET Report for using Report Development or Viewer.



Before Beginning the configuration please keep these files ready -

a) Navision Licence File (.flf).
b) JET Report Licence File (.jlf). *corresponds to Navision Licence File.
c) Navision Classic client should be installed (JET Report Require ActiveX control to Work).

Steps -

1. Copy the JET Report License File (JLF) File to "C:\Program Files (x86)\JetReports".
*Not Mandatory just Best Practice.

2. Copy the Navision Licence File (FLF) File to location of your classic client "C:\Program Files (x86)\Microsoft Dynamics NAV\60\Classic" with name as fin.flf.

3. In case database in on SQL Server then upload the licence on the Server using NAV Client.

4. JET License contain License No. of Navision Licence, so make sure that you use JET Report Licence which corresponds to NAV Licence, as shown below.



5. So we have all license in place as shown below.


6. Let's start Excel and do the configuration.

7.As of Now Excel Application Setting, Data Source Settings, Help and About are enabled.

8.Open Application Settings - Licensing.

9.Browse the path of Jet Licence - "C:\Program Files (x86)\JetReports".

10.Click on Data Source Settings.

11.Click on Add and Fill in details as shown below.



12.Under General Tab, Provide Detail of Classic Client Folder.

13.Under Authentication Select Type of Authentication.

14.Under Connection Provide Server,Database Name and Company Name.



15. IF all the steps followed as discussed you will see the icon as green as shown below.



16. IF its red you can click on the Red Icon and see the error that is raised.

If you have any errors please put as comment the error message, we will suggest you the solution for same.

In future post related to Jet Reports we will discuss about conman issues in Jet Reports configuration.

Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/

Comments

Popular posts from this blog

Microsoft Dynamics NAV 2016 - How to Configure Phone Client.

Hi All, In this article we will discuss how we can connect Microsoft Dynamics NAV 2016 with New Client Launched i.e. Phone Client. This Article Contain Steps for a Android Phone as I have Only Android Phone. I am doing it having all tiers on my windows 8 machine, steps remain same for multiple servers but issues might be different. What we Need (Other what we discuss in this article) -  The Service Tier should be on Public IP . Some of the Data-card does not Provide you Public IP. check it for sure.

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.

How to Set Up NavUserPassword Authentication in Business Central.

Hi Readers, In this article we will discuss steps to Setup NAVUserPassword in Business Central on-prem. NavUserPassword is an authentication method that's handled by Business Central Server, but isn't based on Windows users or Active Directory. Each user is set up with a username and password that's configured inside Business Central only. The user is prompted for username/password credentials when they start the client. #msdyn365bc, #credentialtype