Sign Up for Training |
Jet Global Company Site
Submit a Request
Give Feedback

Introducing the NF Function

The NL function works great if you want a single field from a record, but if you want to retrieve more than one field from the same record, retyping all the filters for each field can be tedious.

The NF function provides a fast way get multiple fields from your NL.

Help Topics

NF Function Ref
NL Function
GL Function


NAV Cronus Example Access Northwind Example

With Northwind, the following report lists CustomerIDs with their City and Phone.

The CustomerID uniquely identifies each customer, so you make a list of CustomerIDs, then use it as a filter to get the City and Phone for each customer. A sample of the output of this report is listed below.

The NF function is a shortcut that will return the value of a field in a record. One or more NF functions can be used with a single NL function that has the NL field parameter left blank. The report listed above can be created with much less typing by using this method. The simpler version of the report is shown below.

As you can see, the second version requires much less typing. The list of fields in the NL function is enclosed in brackets {} and must include all of the fields you want to use in the NF functions. The first parameter of the NF function has a cell reference to the NL command, and the second parameter is the name of the field in which you are interested. Note that this type of NL function returns what is called a record key, which will be discussed later. A sample of the output of the report is listed below.

As you can see, the first column does not contain information that you want to see on the report so you can hide this column (see Automatic Hidden Columns, Sheets and Rows below).

Since you are working in the Customers table, you can make this report even easier. The CustomerID field uniquely identifies each record in the Customers table so it is called the primary key for that table. Since the Customers table has a primary key, you can just leave the Field parameter blank and Jet Reports will take care of the rest. The same report is pictured below with the shorter NL command.

If there is no primary key in the table, Jet Reports will give an error message if you leave the Field parameter of the NL blank so you can try leaving the Field blank, then fill in a list of field names if necessary.

Was this article helpful?
0 out of 1 found this helpful
Have more questions? Submit a request