Skip to main content

Specify the version of C/Front that the Jet Excel add-in will use

Overview

C/Front is a Microsoft Dynamics NAV tool which handles communications between Dynamics NAV and other applications.

When using the Jet Excel add-in with Microsoft Dynamics NAV 2009 R2 or earlier, it is important to use a version of C/Front that is compatible with the version of your NAV.  In many cases the Jet Excel add-in can automatically choose the best version of C/Front to use with your version of NAV.  However, Microsoft would often release hotfixes or updates of the NAV executables, and the Jet Excel add-in may not be able to choose a compatible version of C/Front in that situation.

Jet Reports versions 2011 and higher

From the Data Source Settings window, go to the Advanced tab and enter the path to C/Front in the C/Front folder setting.

Pictured is Jet Reports 21.3.21223.1

Jet Reports 2009 (version 9.2) though Jet Reports 2010 R2

Jet Reports selects the version of C/Front to use in this order:

  1. Checks the Data Sources.xml file (located in %AppData%\Jet Reports) for a specific C/Front directory.

  2. Checks the installed version of C/Front.  If that version has the same major version as the NAV executables Jet will use the installed version.
  3. If no C/Front directory is specified in the Data Sources.xml and the there is no version of C/Front installed or the installed version is incompatible with the NAV executables then Jet Excel add-in will attempt to choose the best match from the versions of C/Front in the c:\program files\jetreports\jetfront folder.

To specify a particular version of C/Front to use:

  1. Type %AppData%\Jet Reports in Windows Explorer.

  2. Open the Data Sources.xml file in a text editor (such as Notepad)

  3. Find the data source to change by searching for <dataSource name= " data source name to search for ".

  4. Within this node there is an element called <setting name="CFrontDirectory"

  5. Change the CFrontDirectory element's value to the directory containing the desired cfront.dll and cfrontsql.dll files.

    Initially the element will look like this:

    To specify the C/Front directory as "C:\Program Files\CFront"  change it to this:

  6. Save and close the Data Sources.xml file.

 

 

Was this article helpful?

We're sorry to hear that.