Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Jet Basics User Interface

Jet Basics Help Topics...

basics_rib01.png

Mode and Report

The following features are available in the Mode and Report sections of the Jet ribbon:

  • Design Design mode is used to create reports. In Design mode, Jet function results are optimized for speed and are not guaranteed to bring back correct results.

  • Run from Cache Run from Cache mode is the result of running the report against your database.

  • Run Run enters report mode but clears all cached formula results prior to running the report data. This may make the report take longer to complete, but will guarantee that the most current database results are returned.

  • Drilldown To perform a drilldown with Dynamics NAV, click the down arrow button that appears next to any cell containing a GL() function for which drilldown is possible, or select the cell and click Drilldown on the Jet ribbon.

    By default, a data source for Dynamics NAV 2009 R2 will drill down into the Dynamics NAV classic client. If a you wish to use the Drilldown Grid instead, open the Data Source Settings window and select the data source for which to use the Drilldown Grid. On the General page, in the Drilldown group, select Use the Jet Reports data grid

  • Check Error Check Error helps diagnose problems with Jet functions.  When a Jet function results in an error, #VALUE! will appear in the worksheet cell containing the function.  To get more information, select the cell containing the error and choose Check Error .  A message that helps explain the problem will be displayed.

Tools

  • Jet Function Wizard (Jfx) Provides an intuitive way for users to insert GL() functions into a worksheet. Once the trial starts, it also provides access to the NL function.

  • Report Wizard Provides an intuitive way for users to insert GL() functions into a worksheet. Once the trial starts, it also provides access to the NL function.

  • Table Builder Provides an intuitive way for users to insert GL() functions into a worksheet. Once the trial starts, it also provides access to the NL function.

  • Browser Provides an intuitive way for users to insert GL() functions into a worksheet. Once the trial starts, it also provides access to the NL function.

Settings and Information

The following features are available in the Settings and Information sections of the Jet ribbon:

  • Data Source Name Displays the name of your Jet Basics data source.

  • Company Name Displays the name of the default company.  If your Jet Basics data source contains more than one company, you can select the company here.

  • Settings Contains both the App Settings (for controlling various aspects of Jet Basics) and the Data Source Settings (defining how to access your data).

  • Help Used to access this online help system.

Published:

Jet Basics User Interface

Jet Basics Help Topics...

basics_rib01.png

Mode and Report

The following features are available in the Mode and Report sections of the Jet ribbon:

  • Design Design mode is used to create reports. In Design mode, Jet function results are optimized for speed and are not guaranteed to bring back correct results.

  • Run from Cache Run from Cache mode is the result of running the report against your database.

  • Run Run enters report mode but clears all cached formula results prior to running the report data. This may make the report take longer to complete, but will guarantee that the most current database results are returned.

  • Drilldown To perform a drilldown with Dynamics NAV, click the down arrow button that appears next to any cell containing a GL() function for which drilldown is possible, or select the cell and click Drilldown on the Jet ribbon.

    By default, a data source for Dynamics NAV 2009 R2 will drill down into the Dynamics NAV classic client. If a you wish to use the Drilldown Grid instead, open the Data Source Settings window and select the data source for which to use the Drilldown Grid. On the General page, in the Drilldown group, select Use the Jet Reports data grid

  • Check Error Check Error helps diagnose problems with Jet functions.  When a Jet function results in an error, #VALUE! will appear in the worksheet cell containing the function.  To get more information, select the cell containing the error and choose Check Error .  A message that helps explain the problem will be displayed.

Tools

  • Jet Function Wizard (Jfx) Provides an intuitive way for users to insert GL() functions into a worksheet. Once the trial starts, it also provides access to the NL function.

  • Report Wizard Provides an intuitive way for users to insert GL() functions into a worksheet. Once the trial starts, it also provides access to the NL function.

  • Table Builder Provides an intuitive way for users to insert GL() functions into a worksheet. Once the trial starts, it also provides access to the NL function.

  • Browser Provides an intuitive way for users to insert GL() functions into a worksheet. Once the trial starts, it also provides access to the NL function.

Settings and Information

The following features are available in the Settings and Information sections of the Jet ribbon:

  • Data Source Name Displays the name of your Jet Basics data source.

  • Company Name Displays the name of the default company.  If your Jet Basics data source contains more than one company, you can select the company here.

  • Settings Contains both the App Settings (for controlling various aspects of Jet Basics) and the Data Source Settings (defining how to access your data).

  • Help Used to access this online help system.

For an optimal Community experience, Please view on Desktop