Mode / Report
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 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.
To perform a drilldown with Dynamics NAV, click the down arrow button that appears next to any cell containing a Jet formula for which drilldown is possible, or select the cell and click Drilldown on the Jet ribbon.
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.
Jet Function Wizard (Jfx)
Provides an intuitive way for users to insert GL or NL(Table) functions into a worksheet.
The Table Builder creates an Excel table (from one or more database tables) which can be used as the basis for pivot tables and charts.
Settings / Information
Data Source Name
Displays the name of your Jet Basics data source.
Displays the name of the default company. If your Jet Basics data source contains more than one company, you can select the company here.
Used to access this online help system.