Jet Essentials Videos
Author: Harry Lewis Views: 72479 Last Updated: 07/06/2015 10:52 AM 79 Rating/ 7 Voters

Getting Started

Activating your Jet License  How to activate your Jet License for Jet Essentials 2013 and higher

Configuring Data Sources
Jet Remote Data Service (JRDS) Data Source - NEW Provides system administrators with Information about how to set up the Data Service and configure a data source to use it with Jet Essentials 2015 Update 1 or higher.
High Performance connection for Dynamics NAV with Jet Essentials 2013 U1 and higher  How to configure a high-performance SQL-direct Data Source for Dynamics NAV 2013 or higher with Jet Essentials 2013 Update 1 and higher.
Using Shared Settings with the Jet Configuration Service If your organization is using the Jet Configuration Service to shareData Source Settings, this video will show you how to use this.
Using Dynamics NAV Web Services with Jet Essentials How to configure a Data Source using NAV's Web Services for Dynamics NAV 2013 or higher with Jet Essentials (2013 and higher)
Dynamics NAV 2009R2 and earlier How to configure a Data Source for Dynamics NAV 2009 R2 and earlier
Microsoft SQL Using Jet Essentials to configure a Jet data source for a Microsoft SQL database
Configuring a Jet Enterprise Cube Connection How to use configure and use Jet Essentials' Pivot Table feature to connect to Jet Enterprise OLAP Cubes.
Dynamics GP Using Jet Essentials to configure a Jet data source for Dynamics GP

System Administrators
Setting up the Jet 2013 Configuration Service & Using the Jet Admin Console  How to configure Jet Essentials 2013 and higher to use the Jet Configuration Service to share Data Source Settings (for Jet Essentials users).  Hover for more info...
Configuring NAV 2013 Web Services and Jet Essentials  How to configure NAV Web Services (2013 and higher) for use with Jet Essentials 2013 and  higher.  Hover for more info...
Administrator Installation Options  Options available to system administrators for installing Jet Essentials for multiple users
Installing Friendly Names and Views with Dynamics GP databases  How to install the Jet Friendly Names and Views to your Dynamics GP database

Creating Reports

The GL() Function for NAV
The GL Function for NAV - UPDATED  An interactive tutorial for using the GL function with a Dynamics NAV data source
Creating a 'Grouping Report' - step by step
Grouping Report 1 Filters, Lists, and Totals
Grouping Report 2 Adding Groups 
Grouping Report 3 Adding Columns and Dimensions 
Grouping Report 4 Adding Sheet Grouping 
Grouping Report 5 Adding Report Options 
Using Table Builder
Introduction to Table Builder An introduction to the Jet Essentials Table Builder
Table Queries Analyzing Data with Table Queries
Multi-Table Reports - Part 1 Step-by-step instructions on how to use the Jet Essentials Table Builder to draw data from multiple tables in your database. 
Multi-Table Reports - Part 2
How to use "Include Duplicates" How to use the "IncludeDuplicates" feature in the Table Builder and the NL(Table) function 
Reporting from Jet Enterprise Cubes
Connecting to your Cubes How to connect to your Jet Enterprise Cubes from Jet Essentials 
Cube Queries An introduction on how to use Jet Essentials to create free-form reports directly from Jet Enterprise OLAP Cube data
Creating Dashboards
Dashboard Mode An overview Jet Essentials' Dashboard mode allowing the viewer to change the filters on the screen and have reports refreshed "on the fly"
Using Report Builder
The Report Builder How to use the Report Builder
Importing Data Views into the Report Builder How to import Data View Categories for use with the Jet Report Builder
The Data View Creator How to use the Data View Creator to create and edit the data views that are available in the Jet Report Builder

Product Features

Product Features
Jet Function Wizard (Jfx) An overview of the Jet Function Wizard
How to use Tooltips for Report Options A quick demonstration of how to use the new "Tooltips" feature for report options in Jet Essentials 2013
Snippets How to use Jet Snippets
Jet Scheduler
Jet Scheduler How to use the Jet Scheduler to schedule your Essentials reports to run automatically
Jet Scheduler - Trigger Based Email Alerts and Dynamics Email Text  How to create trigger-based email alerts and include information from the report in the email (Excel file used in this video)
Jet Scheduler - Dynamic Batch Scheduling How to dynamically schedule batch reports (Excel file used in this video)
Jet Browser
Jet Browser - Intro An introduction to the user of the Jet Browser
Jet Browser - Drag and Drop How to use the Jet Browser's Drag-and-Drop functionality
Jet Browser - Importing Table Details (NAV) How to import Dynamics NAV table details into the Jet Browser.
Favorite Tables and Fields Using Favorite Tables and Fields in the Jet Browser and Function Wizard (Jfx)

Additional Videos

Videos for Older Versions of Jet Essentials and Jet Reports
Dynamics NAV with Jet Reports 2009 Using Jet Reports 2009 to configure a Jet Data Source for Dynamics NAV 2009 SP1 and earlier
Dynamics GP with Jet Reports 2009 Using Jet Reports 2009 to configure a Jet Data Source for Dynamics GP
What's New in Jet Essentials 2012 An overview of the features that were introduced with Jet Essentials 2012