Getting Started with Jet v24 Report Design Scheduling & Distribution Jet Data Manager Configuration Installation Troubleshooting Release Notes

Jet from insightsoftware

Fundamentals
Getting Started with Jet Reports Jet Products What is the Jet Excel add-in? Getting Started with Jet Reports Jet Reports User Information - Policies & Procedures
Fundamentals
Zendesk Descriptions are automatically loaded below
More (12)
Sample Reports and Templates
Downloading Sample Reports Table Builder - Sample Templates Jet Reports Financials Report Templates
Sample Reports and Templates
Zendesk Descriptions are automatically loaded below
More (3)
Running Reports
Background Reporting in the Jet Excel add-in Differences between Report and Refresh Running Reports in Jet Hub Drilldown Grid Differences between Run and Run from Cache
Running Reports
Zendesk Descriptions are automatically loaded below
More (5)
Additional Resources
Jet Reports e-Learning Jet Reports Videos Videos for Dynamics NAV Videos for Dynamics GP Jet Basics Help Topics
Additional Resources
Zendesk Descriptions are automatically loaded below
More (8)

Jet from insightsoftware

Fundamentals
Jet Reports User Interface Jet Reports - Best Practices The Jet Function Wizard (Jfx) What is a Designer? A Viewer? An Excel User? Difference between "Design Mode" and "Report Mode"
Fundamentals
Zendesk Descriptions are automatically loaded below
More (42)
Report Building Tools
Your First Reports - a user guide Table Builder and NL("Table") Editing a Table with Table Builder The Report Wizard Create a Word-based report with Export to Word
Report Building Tools
Zendesk Descriptions are automatically loaded below
More (9)
Building Financial Statements
GL Function for Dynamics NAV GL Function for Dynamics GP Best Practices - G/L Reports Converting from Management Reporter or FRx to Jet Reports or Jet Basics Tutorial Videos for using Jet Reports Financials
Building Financial Statem...
Zendesk Descriptions are automatically loaded below
More (17)
Creating and Editing Jet Functions (Jfx)
Multi-level Grouping and Subtotaling Tutorial Sorting Your Jet Reports Report Options in Jet Basics Sorting NL("Last") and NL("First") functions Using NL( Lookup )
Creating and Editing Jet ...
Zendesk Descriptions are automatically loaded below
More (5)
Filtering Data
Special Characters in a Filter Filter Ranges and Excel Blank Filters - using @@ and other techniques Filter Syntax In Your Jet Reports Creating a Filter to include XX* but exclude *YY
Filtering Data
Zendesk Descriptions are automatically loaded below
More (7)
Report Writing Techniques
Useful Excel Date Functions Jet Reports Dashboard Mode Grouping and Subtotaling Tutorial Filtering Based on Data from Another Table Building a Report From Multiple Data Sources
Report Writing Techniques
Zendesk Descriptions are automatically loaded below
More (31)

Jet from insightsoftware

Scheduling Reports
How to use the Batch Report Wizard Using First Sheet and All Sheets with CSV and TXT Outputs in the Jet Scheduler Web-Based Scheduling (Jet Hub) Configuring SMTP Settings for the Jet (Excel) Scheduler The Scheduler within the Jet Excel add-in
Scheduling Reports
Zendesk Descriptions are automatically loaded below
More (13)
Using Jet Hub
Publishing Reports to Jet Hub Jet Hub - Data Source User Credentials Jet Hub - Dashboards Using Folders in Jet Hub Sharing Jet Hub Reports
Using Jet Hub
Zendesk Descriptions are automatically loaded below
More (7)

Jet from insightsoftware

First Steps
Migrating Jet Analytics To Cloud Platform Add New Fields to a Jet Analytics Project Jet Data Manager User Guide Deployment and Execution Explained Creating Measures, Dimensions, and Cubes
First Steps
Zendesk Descriptions are automatically loaded below
More (12)
Project Configuration
Configure Multiple Environments Using the Development Toolkit Measure Format Strings Object Dependency Setup Guarding Tables and Data Sources Parameterizing Custom Transformations
Project Configuration
Zendesk Descriptions are automatically loaded below
More (21)
Using the Jet Data Manager
Using Azure Analysis Services Show Data Types on Fields SQL Database Cleanup Wizard External Business Units Using the +1 button
Using the Jet Data Manager
Zendesk Descriptions are automatically loaded below
More (32)
Dimensional Modeling
Composite Dimension Key Level Table Relations and Relationship Types Physical Foreign Keys Setup in the JDM Advanced Dimensions (NAV 2013 and Newer) with the JDM Working with Option Values in the JDM
Dimensional Modeling
Zendesk Descriptions are automatically loaded below
More (31)
Database Management
Configuring Multiple Environments Migrating Jet Analytics to a New Server Enabling Data Warehouse Access through Windows Firewall Backing Up a SQL Database Locating SQL Server Version
Database Management
Zendesk Descriptions are automatically loaded below
More (10)
Performance Optimization
Incremental Loading Configuration High Availability Cube Processing Batch Data Cleansing Adding Indexes in the Jet Data Manager Table and Index Compression Control
Performance Optimization
Zendesk Descriptions are automatically loaded below
More (15)
Documentation
Project Documentation In The Jet Data Manager Upgrading the Jet Data Manager Upgrading to NAV 2013 - 2018 when using Jet Analytics Jet Analytics Guidelines Regarding Support Versus Billable Work
Documentation
Zendesk Descriptions are automatically loaded below
More (4)
Execution Packages
Creating an Execution Package Merge Steps property explained Default Execution Package Execution Logging and Statistics Executing External SSIS Packages
Execution Packages
Zendesk Descriptions are automatically loaded below
More (11)

Jet from insightsoftware

Connecting to Data Sources
Setting up Dynamics 365 Export to Data Lake How to Download and Install ISW Data Entity Packages How to set up the F&SCM hybrid connector with Jet Reports Connecting Jet Analytics to Dynamics CRM with CData Create a Dynamics NAV 2013 to 2018 - SQL Server Data Source with Jet Reports
Connecting to Data Sources
Zendesk Descriptions are automatically loaded below
More (99)
Licensing and Activation
Microsoft Entra ID Installations - Microsoft 365 License Activation How to Activate your Jet License How To Find Your Jet Activation Code in Jet Excel add-in Server-based Activation of Jet Reports License Activation for Jet Reports
Licensing and Activation
Zendesk Descriptions are automatically loaded below
More (8)
Permissions and Security
Jet Reports – Configuration with Active Directory Group Security Dynamics NAV Security with Jet Reports Dynamics GP Security with Jet Reports Jet Excel Scheduler Permissions - Running Scheduled Tasks When Logged Off Configuring Multi-Dimensional Analysis Services (OLAP) Security in the Jet Data Manager
Permissions and Security
Zendesk Descriptions are automatically loaded below
More (21)
App Settings
Connecting Power BI to OLAP Cubes Configuring SMTP Settings in Jet Hub Protecting a Pivot Table Automatically Refresh Pivot Table Upon Opening Changing the OLAP Locale Identifier in Excel to See Other Language Translations
App Settings
Zendesk Descriptions are automatically loaded below
More (8)

Jet from insightsoftware

Jet Reports
Installing Jet Reports (step-by-step) Getting Started with Jet Reports Installation Guide - Jet Reports Command-Line Installation of the Jet Excel add-in using MSI Using The Jet Excel add-in with Citrix
Jet Reports
Zendesk Descriptions are automatically loaded below
More (14)
Jet Data Manager
Server Hardware Sizing Recommendations Jet Analytics System Requirements Jet Analytics Deployment Options Connecting to Business Central Version 16 or Later Jet Analytics Installation
Jet Data Manager
Zendesk Descriptions are automatically loaded below
More (8)
Jet Service Tier
Installing the Jet Service Tier / Jet Hub with Microsoft Entra ID Installing the Jet Service Tier / Jet Hub with Active Directory and Single Sign-On Installing the Jet Service Tier in Active Directory Installing Jet Service Tier on Azure Upgrading the Jet Service Tier
Jet Service Tier
Zendesk Descriptions are automatically loaded below
More (8)
Jet Hub
Jet Hub - Overview, Installation, setup, and use Jet Hub - Windows Feature Requirements Enabling Multi-factor authentication for BC Cloud Web Services data sources within the Jet Hub Using an SSL Certificate with Jet Hub How To Create a SHA-256 Self-Signed Certificate
Jet Hub
Zendesk Descriptions are automatically loaded below
More (8)
Technical Requirements
Jet Analytics D365 BC Supported Countries and Editions Jet Reports D365 BC Supported Countries and Editions Sample Technical Requirements for Hosting Jet Hub in Azure IIS Features which can be Automatically Enabled Jet System Requirements
Technical Requirements
Zendesk Descriptions are automatically loaded below
More (29)

Jet from insightsoftware

Jet Reports
Error: This Account Requires Multi-Factor Authentication... Error: The data source is not properly configured for Microsoft 365 authentication Run Button Missing Following Jet Reports Upgrade Network Drives Do Not Appear In File Explorer When Using The Jet Excel Add-In Scheduler Error - The remote server returned an error (429) when using a Business Central Public Cloud data source
Jet Reports
Zendesk Descriptions are automatically loaded below
More (68)
Jet Data Manager
Error: Root element is missing Error: Retrieving the COM class factory for component with CLSID Change StringStoresCompatibilityLevel Method not found '!!0[]System.Array.Empty()'. There is already an object in the database
Jet Data Manager
Zendesk Descriptions are automatically loaded below
More (50)
Jet Hub
Jet Hub Error: IDX20803: Unable to obtain configuration from file: '[PII is hidden]' Error: We cannot currently authenticate you against your Dynamics 365 Business Central tenant. Error: E_ACCESSDENIED or "The type initializer for 'Jet.Data.JetDataSourceFactory' threw an exception" Jet Hub and Jet Service Tier Logging Error: The Given Path's Format Is Not Supported
Jet Hub
Zendesk Descriptions are automatically loaded below
More (10)
Data Sources
Error: Error opening connection to BC Cloud: System.ApplicationException: Invalid response from Business Central calling API GetLanguage Error - The underlying connection was closed: An unexpected error occurred on a send. Error: You do not have the following permissions on TableData What's New Notified: Read Error: You are not authorized... You must sign-in using your Microsoft 365 credentials Login Failed with Dynamics NAV 2013-2018 or Business Central SQL Server Data Source
Data Sources
Zendesk Descriptions are automatically loaded below
More (34)
Licensing
Your program license does not permit more users NAV Licensing Errors Error: "You do not have a license for the project" You are not licensed to Design Reports... Error: Proxy Authentication Required or Activation Failed
Licensing
Zendesk Descriptions are automatically loaded below
More (5)
Performance
Changing Your Microsoft Office Update Channel Warning: An open report contains CalcFields or CalcFilters Reports Running Slowly in Excel 2016 Reporting Performance with Dynamics NAV Web Services Warning Message - Excel is Currently in Compatibility Mode
Performance
Zendesk Descriptions are automatically loaded below
More (6)
Installation
Microsoft .NET Framework required for Jet Reports setup - 0x8007090 - Element not found Unable to Authenticate your User Account after Jet Service Tier Upgrade The file format and extension of 'JetReports.xll' don't match Cannot update Existing Active Directory installation to Microsoft Entra ID Error: We have detected that Jet Reports is connected to either a Dynamics
Installation
Zendesk Descriptions are automatically loaded below
More (9)

Jet from insightsoftware

What's New
What's New in Jet Reports
What's New
Zendesk Descriptions are automatically loaded below
More (1)
Release Notes
Jet Reports - Release Notes Business Central Extensions - Release Notes Jet Analytics - Release Notes Jet Basics - Release Notes Jet Reports Support Maintenance Schedule
Release Notes
Zendesk Descriptions are automatically loaded below
More (5)
For an optimal Community experience, Please view on Desktop