Sign Up for Training |
insightsoftware Company Site
Submit a Request
Become a Jet Insider
Give Feedback

Jet Reports Field Caches

Related Articles...


When building reports with Jet Reports, the NL() function can be set up to return a specific set of fields from your database.  This set of fields is referred to as a Field Cache.

Understanding Field Caches

A Field Cache may appear in an NL() function in 2 forms:

  • either a comma delimited list of fields inside curly brackets: { "field1", "field2", "field3" }
  • or a range of cell references: $B$2:$G$2.

To add another field to the Field Cache, either:

  • add a comma and then the name of the field (enclosed in quotation marks) to the end of the list inside the curly brackets (in the first case)
  • or extend the cell range and type the name of the field into the last cell (in the second case)

When using a Field Cache, the Jet add-in will treat the unique combination of fields included in the Field Cache as the primary key to the specified table, regardless of whether or not those fields accurately represent a composite key to the underlying data.

See the Related Articles for more information about using Field Caches.

Was this article helpful?
0 out of 0 found this helpful