Skip to main content

JET Reports - Types of Jet Users.

Hi all,

For all Earlier Post Related to Jet Report Please follow the Link

In this post we will see Types of Jet Users. You might be thinking why it is important to discuss this but you will find it useful when you are actually creating Reports for a Customer.

Without Wasting much time Jet Report Users Are Classified Into Three Types.


A Designer user Has all permissions in Jet Reports.

He/She Can Edit Existing Jet Report and can create New Jet Reports.

The Menu for Designer is as shown below.


A Viewer Has limited permissions.

He/She Can Only run reports and change filters that have been allowed by the Designer.

The Menu for Designer is as shown below. The actions related to Designing and Modifying the Jet Reports are disabled by Default.

Excel User

A Excel User Can only view reports as Excel workbooks.

He/She Cannot change filters or run reports.

You can consider it a user who does not have Jet Installed.

The Menu for Excel User is as Shown Below.

While Creating a Jet Report we need to take care of Type of Users for which we are creating Reports. He/She can be a Viewer or a Excel Users.

There are certain Keywords which are used so that an Excel user can see the output of Report without installing Jet Reports.

Now in Menu we have below listed points are pending to discuss. Once completed we will look into Development of Jet Reports.

1) Report Tools.
2) Formula.
3) Wizards.

Saurav Dhyani


Popular posts from this blog

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.

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.