docs.jet.insightsoftware.com Open in urlscan Pro
216.198.53.1  Public Scan

Form analysis
2 forms found in the DOM

GET /hc/en-us/search

<form role="search" class="form-field flex-1 mb-0" data-search="" data-instant="true" autocomplete="off" action="/hc/en-us/search" accept-charset="UTF-8" method="get"><input name="utf8" type="hidden" value="✓" autocomplete="off"><input type="search"
    name="query" id="query" placeholder="Search" autocomplete="off" aria-label="Search"></form>

GET /hc/en-us/search

<form role="search" class="form-field mb-0" data-search="" data-instant="true" autocomplete="off" action="/hc/en-us/search" accept-charset="UTF-8" method="get"><input name="utf8" type="hidden" value="✓" autocomplete="off"><input type="search"
    name="query" id="query" placeholder="Search" autocomplete="off" aria-label="Search"></form>

Text Content

Skip to main content
Toggle navigation menu


Home Videos Support Sign in


JET HELP


SEARCH




The Jet suite of products from insightsoftware offers a comprehensive solution
for financial and business reporting, analytics, and data management. Designed
to integrate seamlessly with Microsoft Dynamics and other ERP systems, Jet
products empower users to create accurate, real-time reports and dashboards
directly within Excel and on the web.


 * RELEASE NOTES


 * GETTING STARTED


 * INSTALLATION


 * CONFIGURATION


 * PRODUCT DOCUMENTATION


 * TROUBLESHOOTING


CATEGORIES

 * Release Notes
    * What's New
      * What's New in Jet Reports and Jet Hub 24.3
      * What's New in Jet Reports 24.2
      * What's New in Jet Reports
    * Release Notes
      * Jet Reports - Release Notes
      * Business Central Extensions - Release Notes
      * Jet Analytics - Release Notes
      * Jet Reports Support Maintenance Schedule

 * Getting Started
    * Additional Resources
      * Jet Reports Videos
      * Customer Experience Improvement Program
      * Guidelines for Support Versus Billable Work
      * Additional Resources for Jet
    * Run Reports In Jet
      * Run Reports in Background using Jet Excel Add-in
      * Run Reports in Jet Hub
      * Differences between Run and Run from Cache
      * Analyze Reports using Drilldown Grid
    * Jet Fundamentals
      * Overview of Jet Products
      * Getting Started with Jet Reports
      * User Personas
      * Connectors and Licenses
      * Jet System Requirements
      * Select the Jet Data Source for your Report
      * About Jet Technical Support
      * Jet Compatibility with New Releases of Supported Products and Versions
        of NAV

 * Installation
    * Jet Third-Party Licenses
      * Jet Third-Party Software
    * Jet Products System Requirements
      * Jet Products System Requirements
    * Install Jet Hub
      * System Requirements for Jet Hub
        * Jet Hub - Windows Feature Requirements
        * System Requirements for Jet Hub
        * Sample Technical Requirements for Hosting Jet Hub in Azure
        * Installing and Binding an SSL Certificate in IIS 8 and Above
      * Overview of Installing Jet Hub
      * Enabling Multi-factor authentication for BC Cloud Web Services data
        sources within the Jet Hub
      * Using an SSL Certificate with Jet Hub
      * Install Platform-Enabled Jet Service Tier or Jet Hub with Microsoft
        Entra ID Authentication
      * SSL Certificates for Jet Hub
    * Install Jet Service Tier
      * Pre-Installation Checklist for the Jet Service Tier and Jet
        Administration Console
      * Install the Jet Service Tier or Jet Hub with Microsoft Entra ID
      * Install the Jet Service Tier or Jet Hub with Active Directory and Single
        Sign-On
      * Install the Jet Service Tier in Active Directory
      * Install Jet Service Tier on Azure
      * Upgrade the Jet Service Tier
      * Upgrade the Jet Services Database
      * Manage the Jet Service Tier with the Jet Services Administration Shell
    * Install Jet Data Manager
      * System Requirements for Jet Data Manager
        * Jet Data Manager Minimum SQL Server Permissions
        * Pre-Installation Checklist for Jet Analytics
        * Sample Technical Requirements for Hosting Jet Analytics
        * Server Environment Configurations
      * Jet Analytics Deployment Options
      * Connecting to Business Central version 16 or later
      * Jet Analytics Installation
      * Ensure SQL Server Components are Installed
    * Set up Jet Reports
      * Install Jet Reports
      * Install the Jet Excel add-in via the command-line
      * Guidelines to use Jet Excel add-in with Citrix
      * Import and Export Data Source Settings and Application Settings
      * Enable or disable the Jet Excel add-in
      * Enable the Jet Excel add-in in a clustered environment
    * System Requirements for Jet Reports
      * System Requirements for Jet Excel Add-In
      * System Requirements for Jet Reports Platform
      * System Requirements for Legacy Dynamics Data Source

 * Configuration
    * Application Settings
      * App Settings (Application Settings)
      * Batch Function Execution Optimization
    * Configuring Security for Jet Reports
      * Kerberos Authentication
      * Configuring user and group access to the JRDS
      * Configure Row-Level Data Warehouse Security
      * Serenic Navigator User Access Rules
      * Configure Domain IP Allowlist on Azure
    * Licensing and Activation
      * Activate License using Microsoft 365 for Microsoft Entra ID installation
      * Activate your Jet License
      * Find Your Jet Activation Code In Jet Analytics
      * Find Your Jet Activation Code in Jet Excel add-in
      * Server-based Activation of Jet Reports
      * Authenticate Jet Reports Reports License
      * Activate the Jet Data Manager
      * Use the Jet License Portal
      * Tabular Cube Security
    * Configuring IIS
      * IIS Features That Can Be Enabled Automatically
      * Create a CSR with IIS
    * Configuring for Dynamics NAV
      * Create a Dynamics NAV data source with Jet Reports
      * Create a Dynamics NAV 2013 to 2018 - SQL Server Data Source with Jet
        Reports
      * Create a Dynamics NAV Web Services Data Source in Jet Hub
      * Create a Dynamics NAV SQL Data Source in Jet Hub
      * Configure Microsoft 365 Authentication for Dynamics NAV or Business
        Central On Premises
      * Add a Generic (ODBC) Data Source to the Jet Data Manager
      * Create a Dynamics NAV Jet Remote Data Source - Admin Guide
      * Create a Dynamics NAV Jet Remote Data Source - Users' Guide
      * Enable Dynamics NAV Web Services (SOAP)
      * Create a Dynamics NAV Web Services Data Source with Jet Reports
      * Connecting to Dynamics NAV
      * Change the Dynamics NAV Data Source in the Jet Data Manager
      * Import the NAV Adapter (NAV 4.0 SP1 through NAV 2009 R2)
      * Dynamics NAV ClickOnce RTC Drilldown
      * NAV 2015 (and higher) Authentication Types
      * NAV 2013 Authentication Types
      * NAV Connection Types in the Jet Excel add-in
      * Create A Dynamics NAV (Multi-Tenant SQL Server) Data Source
      * Local Navision Databases
      * Dynamics NAV Language Modules
      * Update Dynamics NAV Drilldown Forms and Other Information
      * Restart a Dynamics NAV Server Instance
      * Use the Adapterless Setup for NAV 2013 - 2018 with Jet Analytics
      * Microsoft 365 Authentication
      * Remove the Jet Business Objects
      * NAV License Files for NAV 2009R2 and earlier
      * Dynamics NAV Security with Jet Reports
      * NAV Row-Level Security with Jet Reports for NAV 2009R2 and earlier
      * Dynamics NAV Row-Level Security with Jet Reports For NAV 2013 to 2018
      * Create a Dynamics NAV 2009 R2 or earlier Data Source with Jet Reports
    * Configuring for Dynamics 365 and Business Central
      * Business Objects (FOB) for Dynamics NAV and Business Central
      * Requirements for using the Dynamics NAV and Business Central SQL
        Connector
      * Dynamics NAV and Business Central Language Captions
      * Configure Drilldown Settings for Dynamics NAV 2013 - 2018 and Dynamics
        365 Business Central
      * Configure NAV or Business Central Web Services for Jet Reports
      * Set up Dynamics 365 Export to Data Lake
      * Create a Dynamics 365 Business Central Data Source
      * Create and Configure Data Sources
      * Dynamics 365 - Custom Data Source Configuration
      * Connect to Multiple Environments with the Dynamics 365 Business Central
        Public Cloud Data Source
      * Business Central Team Member Licenses with the Jet Excel add-in
      * Create A Business Central (Public Cloud Web Services) Data Source
      * Business Central 16 Or Later Jet Reports Extensions
      * Use Business Central with Jet Analytics
      * Create A Multi-Tenant Business Central (Dynamics 365 SQL Server) Data
        Source
      * Create A Business Central (On-Premises Web Services) Data Source
      * Create a Business Central (SQL Server) Data Source
      * Create a Business Central (public cloud) Data source in Jet Hub
    * Configuring Jet Reports
      * Create and Configure Data Sources- Admin Guide
      * Create a Jet Data Warehouse data source with Jet Reports
      * Create an Azure SQL data source with Jet Reports
      * Create a SQL-based data source with Jet Reports
      * Connect to the Jet Service Tier using Jet Reports
      * set up the F&SCM hybrid connector with Jet Reports
      * specify the version of C/Front that the Jet Excel add-in will use
      * Share Data Sources with the Jet Excel add-in
      * Download and Install ISW Data Entity Packages
      * Remove Active Directory Distribution Groups from Jet Reports
      * Configuration with Active Directory Group Security for Jet Reports
      * Give Jet Reports permission to access Azure Cloud data
      * Use Jet Reports in a Shared Desktop Environment
    * Configuring for Cubes
      * Connecting Power BI to OLAP Cubes
      * Changing the OLAP Locale Identifier in Excel to See Other Language
        Translations
      * Dynamic Cube Security with the Jet Data Manager
      * Create a Jet Analytics Cubes data source with Jet Reports
      * Create a Cube data source with Jet Reports
      * Create an Internet-based OLAP Cube data source with Jet Reports
    * Configuring for GP
      * Database Caption Editor
      * Dynamics GP Security with Jet Reports
      * Create a Dynamics GP Data Source in Jet Hub
      * GP Update Utility
      * Changing the Dynamics GP Data Source in the Jet Data Manager
      * Create a Dynamics GP Jet Remote Data Source - Admin Guide
      * Create a Dynamics GP Jet Remote Data Source - User Guide
      * Connect to Dynamics GP with the Jet Data Manager
      * Create a Dynamics GP data source with Jet Reports
    * Configuring The Jet Data Manager
      * Add an Azure SQL Data Source to Jet Analytics
      * Configure a Native NAV Project in the Jet Data Manager
      * Change the Dynamics AX Data Source in the Jet Data Manager
      * Add a Microsoft Excel Data Source to the Jet Data Manager
      * Adding a Text File Data Sources to the Jet Data Manager
      * Connect to Dynamics SL with the Jet Data Manager
      * Connect to Dynamics AX with the Jet Data Manager
      * Connect to Microsoft CRM Online with the Jet Data Manager
      * Connect Jet Analytics to Dynamics CRM with CData
      * Add Custom Data to a Jet Analytics Project
      * Connect to Salesforce using the Jet Data Manager
      * Use External Tables in the Jet Data Manager
      * Add a SQL Server Data Source to the Jet Data Manager
      * Use an AnySource Adapter in the Jet Data Manager
      * Use Power BI with Jet Analytics
      * Use Analysis Services Tabular Model with Jet Analytics
      * Create a Data Warehouse Remote Data Source - Admin Guide
      * Use Azure SQL for Repository, Data Warehouse and Staging Databases
      * Import the Dynamics AX Adapter
      * Environment Security with the Jet Data Manager
      * Configure Multi-Dimensional Analysis Services (OLAP) Security in the Jet
        Data Manager
      * Data Warehouse Security (JDM 2016 and Newer)
      * Custom Password Protection for SSIS Packages
    * Configuring The Universal Data Source
      * Create an Azure SQL data source with Jet Products
      * Configure Language Captions for a Jet Data Warehouse
      * Add NOLOCK to improve performance
      * Check the Version of CFront
      * Install Friendly Table or Field Names in a Universal Data Source
      * Universal Data Link Properties
      * Use an Excel workbook as a Jet data source
      * Visual FoxPro Prerequisites
    * Configuring The Jet Hub/Jet Service Tier
      * Jet Service Tier - Two Server Configuration
      * User and Data Source Management in Jet Hub
      * Use the Jet Administration Console

 * Product Documentation
    * Report Design
      * Report Design Fundamentals
        * Jet Reports User Interface
        * The Jet Function Wizard (Jfx)
        * Difference between Design Mode and Report Mode
        * Modify the Jet Ribbon
        * Jet Excel add-in Keywords
        * Protect Worksheets
        * Jet Reports Keyboard Shortcuts
        * Jet Reports Best Practices
        * Use Date Filters
        * Use Drilldown
        * Jet Reports Field Caches
        * Find a Table or Field Name using NAV Zoom
        * Design Mode Calculations
        * Use Excel Named Ranges
        * NAV Code and Number fields with Special Characters
        * Dynamics NAV Advanced Dimensions
        * Jet add-in and Excel Array Formulas
      * Excel Add-in Fundamentals
        * Excel Cell Reference Modes
        * Resize rows and columns automatically
        * Hide Columns, Rows, and Sheets automatically
        * Wild Card characters and Filters
        * Simulating Jet Basics with Jet Reports
        * Protecting a Pivot Table
        * Refresh Pivot Table Upon Opening Automatically
      * Create Reports
        * Create Report Options for Jet Excel Add-in
        * Create Report Options for Dynamics Database Lookup
        * create Report Options Lookups for Multiple Columns
        * Prepare Reports for use by Report Viewers
        * Improve Report Performance
        * Add Tooltips to Report Options
        * Create Report Options for non-Dynamics Databases
        * Validate Report Options
        * Create Report Options Manually
      * Report Building Tools
        * How to build reports in Jet Excel Add-in
        * Table Builder and NL Table
        * Edit a Table with Table Builder
        * The Report Wizard
        * Create a Word-based report with Export to Word
        * Create a Pivot Table from Jet Reports
        * Jet Browser Drop-down Functions
        * Use Jet Reports Snippets
        * Use the Jet Browser in Jet Reports
      * Building Functions for Jet Reports
        * NL Function Reference
        * Jet GP Views
        * Most Common GP Tables for Reporting
        * NL Function Replicators
        * GL Function Reference
        * NF Function Reference
        * NP Function Reference
        * Use Jet Reports Fast Financials for NAV and Business Central data
          sources
        * Reverse Signs for Values on Jet Function Results
        * View Fiscal Year Beginning Balances in the GP GL function
        * Exclude Closing Dates for Date Filters
        * Perform GL function drilldown with Dynamics GP
        * create a report with Jet Reports Financials
        * Modify a template with Jet Reports Financials
        * Tutorial Videos for using Jet Reports Financials
        * Best Practices for GL Reports
        * GL Function for Dynamics GP
        * GL Function for Dynamics NAV and Business Central
      * Create and Edit Jet Functions (Jfx)
        * Group Report Data
        * Sort Jet Reports
        * Sort NL and NL functions
        * Use NL Lookup
      * Filter Data
        * Use Special Characters in a Filter
        * Filter Ranges in Excel
        * Use Blank Filters and other techniques
        * Filter Syntax In Your Jet Reports
        * Create a Filter to include XX but exclude YY
        * Use filters in an NL function
        * Exclude inactive accounts in Dynamics GP Reports
      * Report Writing Techniques
        * Excel Date Functions
        * Use Jet Reports Dashboard Mode
        * Group and Subtotal Data
        * Filter Based on Data from Another Table
        * Build a Report From Multiple Data Sources
        * Indicate a Blank Cell
        * Hide Rows, Columns or Sheets Conditionally
        * Sort by Sum with Dynamics NAV and Business Central
        * Sort by Sum for data sources other than NAV
        * Use the Excel IF function with Jet Reports
        * Limit the Number of Records in a Query
        * Use SQL Views
        * Use NL Filter
        * Use Link
        * Use Inclusive Link
        * Use SQL
        * Select the Key Search Algorithm
        * Select the Specific Key by Function
        * Use Schema to return specific data
        * SQL Reference
        * Use a Detail List or a Summary List
        * Compare one NAV field against another field
        * Use GP SmartList SQL Views to speed up reporting
        * Retrieve Special Fields with NL(Table)
        * Array Calculations
        * Add a Date and Time stamp to a Report
        * Table Cache Optimization
        * Evaluate Formulas
        * Load Pictures
        * Use Stored User Data in Reports
        * Use Advanced Stored User Data
    * Scheduling & Distribution
      * Scheduling Reports
        * Set up a Batch Report
        * Select the Sheet option in the Jet Scheduler
        * Schedule Reports in Jet Hub
        * Configure SMTP Settings for the Jet Scheduler
        * AutoPilot Command Line Substitutions
        * Command Line Parameters for Dynamic Batch Scheduling
        * Create a New Task Using the Jet Excel add-in Scheduler
        * Transfer Scheduled Reports to Another Computer
        * Add a Report to a Sharepoint Document Library
        * schedule Batch Reports using the Jet Excel Add-in
        * Upload Reports to SharePoint Using the Jet Scheduler
        * Use Jet Scheduler Without Jet Excel Add-In Installed on Drive C
        * Configure Jet Excel Scheduler Permissions for Running Tasks While
          Logged Off
      * Using Jet Hub
        * Data Source User Credentials for Jet Hub
        * Dashboards In Jet Hub
        * Use Folders in Jet Hub
        * Share Reports In Jet Hub
        * Upload Reports to Jet Hub
        * Features Supported By Jet Hub
    * Jet Data Manager
      * Jet Analytics Fundamentals
        * Add new fields to a Jet Analytics project
        * Create Measures, Dimensions, and Cubes
        * Deployment and Execution
        * Data Selection Rules
        * Jet Analytics Videos
        * Configure Snippets (formally Business Functions)
        * Create Calculated Measures
        * Add a New Company to an Existing Project
        * Revert Project to a Prior Version
      * Project Configuration
        * Configure Multiple Environments Using the Development Toolkit
        * Measure Format Strings
        * Object Dependency Setup
        * Guard Tables and Data Sources
        * Use Parameters in Custom Fields
        * Use Customized Code in the Jet Data Manager
        * Manage CData Providers
        * Migrate Jet Analytics To Cloud Platform
        * Migrate Jet Analytics to a New Server
        * Dynamic Data Selection Rules
        * Configure the Record Load Date on History-enabled Tables
        * Data Tagging
        * Constraint Suggestions in the Jet Data Manager
        * Perform Partial Deployment in Multiple Environment Transfer
        * Guard OLAP Cubes
        * Create OLAP Snippets
        * Custom OLAP Drill Through Actions
        * Change the Cube Date Format
        * Add and Export Translations
        * Null Processing Property
        * Manage Missing Dimension Members in Analysis Services
        * Use Special Characters in Jet Analytics
        * Configure Multiple Environments Manually
        * Use Project Documentation In The Jet Data Manager
        * Configure Conditional Lookups in the Jet Data Manager
      * Using the Jet Data Manager
        * Use Azure Analysis Services
        * Show Data Types on Fields
        * External Business Units
        * Use the +1 button
        * Date Table
        * Supernatural Keys
        * Enable Simple Mode
        * Project Variables
        * Table Visualization in the Jet Data Manager
        * Project Perspectives in Jet Analytics
        * Use the Jet Analytics Query Tool
        * Reverse Engineer an OLAP Database
        * Rename Measure Groups
        * Synchronize and Override Data Types
        * Feature Deprecation in the Jet Data Manager
        * Display Unused Fields
        * Legacy Transformations
        * Add Custom Views In Jet Analytics
        * Enable and Use Team Development
        * Use Field Validations in the Jet Data Manager
        * Create Custom Hash Keys in Jet Analytics
        * Stored Procedures, User Defined Functions, and Script Actions
        * Physical Foreign Keys Setup in the Jet Data Manger
        * Copy Table Structure in the Jet Data Manager
        * Work with Option Values in the Jet Data Manager
        * Additional Scheduler Service Setup
        * Add Custom Table Inserts
        * Define Dependencies for the Scheduler Service
      * Dimensional Modeling
        * Create composite primary key in a dimension
        * Table Relations and Relationship Types
        * Advanced Dimensions (NAV 2013 and Newer) with the JDM
        * Slowly Changing Dimensions (SCD)
        * Add a Week Level to a Date Dimension
        * Advanced Dimensions (NAV 2009 or Older) in the JDM
        * Implement a 4-4-5 Calendar
        * Add Hierarchy Tables in the Jet Data Manager
        * Create a Named Set
        * Add Dimensions to a Project (AX 2012)
        * Cube Perspectives
        * Add Dimension Display Folders
        * Set Dimension Hierarchy Properties
        * Default Measure Setup
        * Junk Dimension Automation
        * Set the default member of a dimension
        * Hide a cube dimension
        * Add Dimension Properties
        * Add Referenced dimension
        * Implement Multi-Currency
        * Hide the All Member in an OLAP Dimension
        * Set up Many to Many Dimensions
        * Handle Early Arriving Facts
      * Database and Data Source Management
        * Configure Multiple Environments
        * Enable Data Warehouse Access through Windows Firewall
        * Back Up a SQL Database
        * Locate SQL Server Version
        * Manage SQL Server Memory
        * Enable SSIS Logging
        * Use the SQL Import Wizard with the JDM
        * SQL and Analysis Management Objects
        * Database Schemas
        * Use SQL Database Cleanup Wizard
        * Use SQL and Business Function (OLAP) Snippets
        * Use SQL Snippets - JDM 2016.1 and earlier
        * Use SQL Unpivot
        * Change the name of a data source table
        * Replicate Data Sources
        * Reuse Data Source Selections
        * Add NAV or Business Central Extension (SIFT) Tables
        * Set up Proxy Connectivity in Jet Analytics
        * Limit Concurrent Transfers on Data Sources
        * Jet Analytics CDATA Connector Types
        * Browse Cubes in the Jet Data Manager
      * Performance Optimization
        * Incremental Loading Configuration
        * Batch Data Cleansing
        * Add Indexes in the Jet Data Manager
        * Configure Table Settings and create Index Compressions
        * Partition Data
        * High Availability Cube Processing
        * Load Cubes Incrementally
        * Direct Read between Data Warehouse and Staging Databases
        * Hashing Algorithms
        * Use Raw-only Fields
        * Clustered Columnstore Indexes
        * Index Automation
        * Disable Automatic Indexing
        * Hashed Primary Key
        * Cube Aggregations
      * Upgrading the Jet Data Manager and NAV
        * Upgrade the Jet Data Manager
        * Upgrade to NAV 2013 - 2018 when using Jet Analytics
      * Execution Packages
        * Create an Execution Package
        * Merge Steps property
        * Default Execution Package
        * Execute Logging and Statistics
        * Execute External SSIS Packages
        * Allow Data Source Failure During Execution
        * Resume a failed Execution
        * Overview
        * Remote Control for Execution Packages
        * Remote Execution of SSIS Packages
      * Jet Data Manager User Guide
      * Jet Analytics Guidelines Regarding Support Versus Billable Work

 * Troubleshooting
    * Jet Reports
      * Error This Account Requires Multi-Factor Authentication
      * Error: The data source not properly configured for Microsoft 365
        authentication
      * Run Button Missing after Jet Reports Upgrade
      * Network Drives Missing in File Explorer with Jet Excel Add-In Scheduler
      * Launch Jet Reports from VBA
      * Error: The FilterField has an empty Filter argument
      * Named Range name appears instead of data while using Export to Word
      * Error: Value Cannot Be Null
      * Columns widths in sample reports are too big
      * Launch Older Versions of Jet Reports from VBA
      * No Support for macro-enabled reports
      * NTFS Permission Precedence
      * Error: reached the maximum number of arguments limit for creating the
        report
      * Prefetching Replicated Data using Shadow Sheets
      * cross-table filtering with Dynamics NAV Drilldown
      * Error Input string not in a correct format
      * Access the Jet Reports Granule on PartnerSource
      * Microsoft 365 Autosave with the Jet Reports Excel add-in
      * Error occured when using the Jet Excel add-in with SQL Server 2012 or
        higher
      * Use Vendor 1099 Code
      * Jet Help Topics
      * Error The Jet activation token is corrupt
      * Generate a Jet Reports Log File
      * Error: Arithmetic operation resulted in an overflow with MySQL database
      * Refresh a Database Schema in the Jet Excel add-in
      * Error with installation of Excel
      * Error: Activation Token used by another process
      * Move a Workbook
      * Missing Period Name in the Date Table for NAV 2013-2018 SQL Server Data
        Source
      * Insufficient Memory or Disk Space in Microsoft Excel
      * NF Field Not Found in Field Cache
      * Launch the Jet Excel add-in from Dynamics NAV Classic Client
      * Excel's Transition Navigation Keys not compatible with the Jet Excel
        add-in
      * Mapped drives do not work in the Jet Scheduler
      * Cannot open Jet Reports directly from an email
      * Set permissions on scheduled tasks
      * Compatibility between Jet Reportsand Microsoft 365
      * Scheduled Tasks do not email when Outlook is open
      * Error: Could not load file or assembly while accessing OLAP Cubes
      * Error: Table X does not have a primary key
      * Error: Either EOF or BOF is true
      * Error: The given key missing in the dictionary
      * Error: Empty filter not allowed
      * Avoid Formatting Cells as Text
      * Error: Invalid Drive P
      * Error: Excel Could Not Evaluate
      * Drilldown button in incorrect cell
      * Module 19 errors
      * Record Key is Corrupted or Invalid
      * Jet Scheduler Sends Corrupt Attachments When Using SMTP
      * Reports Display Dates Four Years Ahead of Filtered Year
      * Error: Object Doesn't Support this Property or Method
      * #NAME Errors
      * Correct Corrupt Workbooks
      * Run Jet Reports with Excel's Automatic Calculation mode
      * Error: Cannot create a file when that file already exists
      * Errors in the text conversion
      * Microsoft Visual Basic Error (Blank)
      * Use the Check Error feature with Local NAV Database Connections
      * #VALUE Errors
      * Report and Design buttons missing when using Excel 2007
      * Activation Error Excel Cannot Access .xll
      * Compile Error in Hidden Module
      * Error: 429 ActiveX component cannot create object
      * Jet Ribbon tab Missing After Install
      * Error: The Login To Microsoft 365 Was Cancelled
    * Jet Data Manager
      * Error: Root element missing
      * Error: Retrieving the COM class factory for component with CLSID
      * Change String Stores Compatibility Level
      * Error: System Array Empty
      * Error an object already exists in the database
      * Error Common Language Runtime detected an invalid Program
      * Dashboard Import Troubleshooting
      * Error: Type String Cannot be Converted to Type Nvarchar
      * Error: No license for the Additional Data Sources Feature
      * Error: No license for the Add Prioritization Feature
      * Error while opening or saving a database
      * Error: The following file is corrupted
      * Error while opening the Project Repository database
      * Error in Command TimeXtender.DataManager.ActivationCommandObject
      * Error in command System.OutOfMemoryException was thrown
      * Error: No permission to alter the object
      * Error: Could Not Load File or Assembly
        Microsoft.SqlServer.DTSRuntimeWrap
      * Resolve an Issue with Closing Entries Being Flagged Improperly for NAV
      * Error: Column SeqNo does not allow nulls
      * Error: Connecting to the Integration Services on the computer localhost
        failed
      * Error: Cannot Run Show Details with Multiple Items Selected in Report
        Filters or Slicers
      * Error: The sort order specified for distinct count records is incorrect.
        Errors in the OLAP storage engine
      * Prevent Execution Package Failure Due to Open Excel File
      * Error: Item Has Already Been Added
      * Error: the Microsoft.ACE.OLEDB.12.0 provider not registered
      * Error getting Engine for Microsoft Analysis Services
      * Error during execution of the JetNavStage Currency Exchange Rate package
      * Error: No Permission to use the language ENU
      * Error: Creating DTS package for tables
      * Timeouts on Databases
      * Error: The product level is insufficient for component X
      * Error: Connecting to the Integration Services server on the computer
      * Error: No Dimension Relationships Exist within the X measure group
      * Troubleshooting Missing Records in Jet Analytics Tables
      * End Users Cannot Access OLAP Cubes from Excel
      * Error: Dragging Date Dimension Level into Pivot Table
      * Error: Could not connect to OLAP server
      * Error: connecting to Integration Services on the Computer
      * Error: LOG file extension can be only .LOG
      * OLE DB or ODBC errors in the high-level relational engine
      * Syntax error in query expression
      * Unable to start Analysis Services
      * Error: Login failed for user NT AUTHORITY\NETWORK
      * Error Mismatch between The locale ids of the source column and the
        destination column
      * Error: Creating an instance of the COM component with CLSI
      * Error: Renaming Default Instance for SSIS
      * Error in Command TimeXtender.DataManager.TXEnvironmentSettingsController
      * Resolving Execution Package Failures
      * Error: No mapping between account names and security IDs done
      * Error: Object reference not set to an instance of an object
    * Jet Hub
      * Jet Hub Error Unable to obtain configuration from file
      * Error: Unable to authenticate with Dynamics 365 Business Central tenant
      * Error: The type initializer for Jet.Data.JetDataSourceFactory threw an
        exception
      * Enable logging for Jet Hub and Jet Service Tier
      * Error: The Given Path's Format Not Supported
      * error: unable to open reports in Jet Hub using IE 11
      * Diagnostic Run in Jet Hub
      * Jet Hub Error The Service is Unavailable
      * An exception of type System.Data.Entity thrown
      * Culture ID not Supported Error in Jet Hub
    * Data Sources
      * Error Connecting to BC Cloud
      * Error: underlying connection closed
      * Error: No Required permissions on TableData What's New Notified
      * Error: not authorized to access Dynamics 365 Business Central data
      * Login Failed while defining SQL Server Data Source
      * Error: No permission to run the Jet Adapter Setup Report
      * Error : Jet Service Tier not running on host
      * Error connecting to Business Central (SQL Server) Using NAV User
        Password authentication
      * Error: specify a drilldown server in the data source settings
      * Error: Incompatible version of Dynamics NAV
      * Error: Invoking the web service failed
      * Error: Unable to load SQLite.Interop.dll
      * Mismatch between Country Codes in License File and STX File
      * Error: Unable to Insert pivot table As the data source failed
      * Unable to connect to Jet Remote Data Service (JRDS)
      * Error: The file contains objects from a different version of Microsoft
        Dynamics NAV Classic
      * Error The type initializer for System.Data.SqlClient.SqlConnection threw
        an exception
      * Troubleshooting issues with Dynamics NAV Web Service Data Source
      * Error: The URL must have exactly five forward slash characters
      * Error: Jet Could Not Verify License Status
      * Error: The Required Dynamics NAV Client Executable Not Found
      * Limitations of the Dynamics NAV 2013 (Web Services) and later
      * Error while setting up OLAP security in the Jet Data Manager
      * Testing the Dynamics NAV Web Service
      * No permission to run the System9110
      * Internal Error 1005 in Module 19
      * Error while using GL Budget with Dynamics NAV 2009R2
      * Navision Language Module Could Not be Loaded
      * Internal Error 1407 in Module 19
      * Jet Reports Automation Error with NAV 2009 SP1
      * Internal Error X in Module X
      * Internal error 53011 in module 93
      * No permissions to read the company table
    * Licensing
      * Error: more users not permitted
      * NAV Licensing Errors
      * Error: No license for the project
      * Error: Unlicensed to design reports
      * Error: Proxy Authentication Required for Authentication
    * Performance
      * Update Microsoft 365 Channel
      * Warning cannot run Jet Functions on multiple threads
      * Slow Performance of Reports in Excel 2016
      * Slow Performance of Reports with Dynamics NAV Web Services
      * Warning Excel in Compatibility Mode
      * Slow Performance of Excel
    * Installation
      * Error Microsoft .NET Framework required for Jet Reports setup
      * Authentication failure after Jet Service Tier Upgrade
      * Mismatch between file format and extension for JetReports.xll
      * Open Default Port to Connect to Analysis Services Cubes
      * Unable to Transition Active Directory to Microsoft Entra ID
      * Error Jet Reports connected to either a Dynamics NAV or Remote Data
        Service
      * Excel add-in missing during installation
      * Error: Unable to cast COM object type to Interface Type
      * Error: ADOMD.NET Installation for SQL Server 2005 failed

Return to top