Featured
Jet Essentials Videos
Author: Harry Lewis Views: 13637 Last Updated: 01/31/2014 11:34 AM 88 Rating/ 2 Voters


Getting Started

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


Configuring Data Sources
Using Shared Settings with the Jet Configuration Service If your organization is using the Jet Configuration Service to share Data Source Settings, this video will show you how to use this.
Dynamics NAV 2013 with Jet Essentials 2013 How to configure a Data Source for Dynamics NAV 2013 or 2013R2 with Jet Essentials 2013
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 Configuration Service & Using the Jet Admin Console  How to configure Jet Essentials to use the Jet Configuration Service to share Data Source Settings (for Jet Essentials users).  Hover for more info...
Configuring NAV 2013 and Jet Essentials 2013 How to configure NAV 2013 for use with Jet Essentials 2013.  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  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 "Toolips" 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
Setup Procedures for Centralized Settings How to configure a Centralized Settings SQL for use with Jet Essentials 2012 and 2011
What's New in Jet Essentials 2012 An overview of the features that were introduced with Jet Essentials 2012