0

Jet Express for Excel FAQs

About Jet Express for Excel

Jet Express for Excel for Excel was developed as a collaboration between Microsoft and Jet Reports to provide Microsoft Dynamics® NAV and GP customers additional value through improved ad-hoc Reporting and Analysis in Microsoft Excel®. Jet Express for Excel was initially released with Microsoft Dynamics NAV 2009 R2, is currently released with Microsoft Dynamics NAV 2017, available for Microsoft Dynamics GP 2016, and is planned to be released with future versions for Microsoft Dynamics NAV and be available for future versions of Microsoft Dynamics GP.

Our ambitions for Jet Express for Excel extend well into the future. As Microsoft adds new features to Dynamics NAV and GP, Jet Express for Excel will be updated to take advantage of those features that will provide additional reporting benefits.

 

 

What are the software requirements for Jet Express for Excel?

Database

Microsoft Dynamics NAV 2009R2 or later
Microsoft Dynamics GP version 9 or later

Microsoft Office^

Microsoft Office 2007, 2010, 2013, 2016 
Microsoft Office 365 Desktop Edition

Desktop Operating System

Microsoft Windows 10 
Windows 8.1 
Windows 8 
Windows 7
Windows Vista SP2

Server Operating System

Microsoft Windows Server 2008 SP2 - 2012 R2

Prerequisites

Microsoft .NET Framework 4.5**
C/Front*
NAV Web Services***


^Only one version of MS Office may be installed - Jet Express does not support environments where multiple versions of Office have been installed.
*Depending on your version of Microsoft Dynamics NAV, you may be required to install C/Front.
**Microsoft .NET Framework will be installed with Jet Express.
***for NAV 2013 and higher installations where direct access to the SQL server is not available.

 

 

How do I get the latest version of Jet Express for Excel?

To download the latest version of Jet Express for Microsoft Dynamics NAV, please visit our Jet Express for NAV (NAV) Resource Center.

To download the latest version of Jet Express for Microsoft Dynamics GP, please visit our Jet Express for Excel (GP) Resource Center.

 

 

Where do I view the Jet Express for Excel change history?

For a comprehensive list of the changes made to each version of Jet Express for Excel, please see the Jet Reports Online Knowledgebase.

Where do I get the latest Jet Business Objects for Microsoft Dynamics NAV 2013-2017 Web Services?

Currently a small set of business objects must be imported into Microsoft Dynamics NAV 2013-2017 to enable communication with Jet Express for Excel or Jet Professional. These business objects only need to be installed once for a database.

The Jet Reports business objects for NAV 2013 through 2017 are available here --> https://jetsupport.jetreports.com/hc/en-us/articles/219402127

 

 

How do I configure a Microsoft Dynamics NAV SQL data source in Jet Express for Excel?

The Microsoft Dynamics NAV SQL direct data source included with Jet Express for Excel 2015 Update 1 and higher can provide substantially faster reporting access to Microsoft Dynamics NAV 2013 and higher than is typically available with other connection types.

To download directions for configuring this data source type, click the link below:

http://download.jetreports.com/KB%20Resources/NAV_SQL_Connector_for_Jet_Express_2015U1.pdf

 

 

Using Jet Express for Excel with Citrix

In order to use Jet Express for Excel with Citrix, the following guidelines apply.

• Publish the entire desktop (we do not support using Jet Express for Excel with Citrix if the entire desktop is not published)
If using Jet Express for Excel for Dynamics NAV:
• If using NAV 2009R2 or earlier, Jet Express for Excel for NAV, Excel, the NAV Classic Client and corresponding NAV SDK must be installed on the Citrix desktop.
• If using NAV 2013 or later, Jet Express for Excel for NAV, Excel, and the NAV Client must be installed on the Citrix desktop.

• Regardless of how you decide to configure Jet Express for Excel, the Excel options and Jet Express for Excel options are stored on a per-user basis. This means that each user will have to run "Enable" from the Start Menu to get access to Jet Express for Excel in Excel. It also means that your database security will be maintained since each user's credentials are stored separately.

 

 

What are the Benefits of Upgrading to Jet Enterprise?

Jet Professional is a powerful reporting solution with advanced features for creating reports, scheduling, and automatic distribution. It is an excellent tool if you need to access more than one database within a single report. Jet Professional is a complete reporting and distribution solution for Microsoft Dynamics and other databases.

 

 

What are the Benefits of Upgrading to Jet Enterprise?

Jet Enterprise is a complete business intelligence and reporting solution that every company can afford. Access up-to-date information in Excel for strategic and ad-hoc analyses, dashboards and KPIs.

 

 

Is there a limit on how many people can use Jet Express for Excel?

For Jet Express for Excel for Excel with Microsoft Dynamics NAV, as long as you are running Microsoft Dynamics NAV 2009 R2 or later and are current on your Business Ready Enhancement Plan (BREP), you can install Jet Express for Excel on as many machines as you like!

Jet Express for Excel for Excel with Microsoft Dynamics GP can be installed on as many machines as you like!

 

 

How many databases can I connect to using Jet Express for Excel?

Jet Express for Excel for Microsoft Dynamics NAV allows you to connect and write reports from 1 Microsoft Dynamics NAV 2009 R2 (or higher) database. 
Jet Express for Excel for Microsoft Dynamics GP allows you to connect and write reports from 1 Microsoft Dynamics GP v9 (or higher) database.

If you have multiple databases you may wish to upgrade to Jet Enterprise or Jet Professional.

 

 

Can I design my own reports using Jet Express for Excel?

All Jet Express for Excel users have the ability to design their own reports as well as run Jet Express for Excel reports others have created.

 

 

How do I get training for Jet Express for Excel?

Jet Reports has put together some "how-to" quick start videos to get your started using Jet Express for Excel. Our videos are available for viewing from our Jet Express Resource Center. If you would like more training please contact your Microsoft Dynamics partner.

 

 

How can I get pre-built reports for Jet Express for Excel?

The Jet Express Report Player is a tool used to view your stored Jet Express Reports. It automatically comes with a set of pre-built reports. You can download this Jet Express Report Player from our Jet Express Resource Center. If you like the reports and want to get on the list to receive updates when we publish more, simply fill out the form at the bottom of the page!

 

 

Do I need a license to use Jet Express for Excel?

In order to use Jet Express for Excel with Dynamics NAV you need to be running Microsoft Dynamics NAV 2009 R2 or later and be current on your Business Ready Enhancement Plan (BREP). No extra licensing is required for either Jet Express for Excel for Dynamics NAV or Jet Express for Excel for Dynamics GP.

 

 

Where can I obtain a copy of C/Front for Dynamics NAV 2009 R2?

If C/Front is required for your version of Microsoft Dynamics NAV, please contact your Microsoft Dynamics NAV partner to download and install the correct version.

0 comments

Please sign in to leave a comment.