Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Table Builder and NL("Table")


Overview

The Jet Professional Table Builder helps you to insert an NL("Table") function in your workbook.

This creates an Excel table (from one or more database tables) which can be used as the basis for pivot tables and charts.

Help Topics

Report Builder
Browser
Writing Reports

 

For more in-depth information about using the Table Builder feature of Jet Professional, view the following video tutorials:

Table Queries - NL(Table) Table Builder Introduction Multi-Table Reports
Part 1
Multi-Table Reports
Part 2
Including Duplicate
Results
 
 
 
 
 
note: videos are available in English, only.
 

 

The Table Builder provides an interface which allows for easy table, field,and filter selections.

TIP: When using the Table Builder or the NL("Table") function with both a header and a detail table (e.g., NAV's Sales Header and Sale Line tables), you will usually want to make sure that the detail table is the first one referenced. This will allow you to display more information than if you start with the header table.
Was this article helpful?
0 out of 1 found this helpful
Have more questions? Submit a request

Comments