The Jet Function Wizard (Jfx)

This article mainly discusses the Jfx feature of Jet Reports.

Overview

In the Jet Reports , the Jfx offers the ability to add all four Jet Functions ( NL , GL , NF , and NP ).

Once you click one of the options for the Jfx, the Jfx window defaults to that particular function; you can change this if you wish. You are presented with the list of parameters for the function you chose. For example, What , Table , and Field
Clicking the arrow next to the What parameter will give you a list of possible arguments for that parameter:
When you click the arrow next to the Table parameter you will get a Lookup window with a list of tables in your database.
Similarly, clicking the arrow next to the Field parameters will give you a lookup window with a list of the fields in that table.
To reference a cell for the FilterField parameter: With the cursor in the FilterField parameter, click the appropriate cell in your worksheet.
When you click the Evaluate button at the top of the Jfx window, you will get an approximate result for your function.

This approximate result is the same as the result you will see in Design mode before you run your report and may not be accurate (always Run the report to ensure accuracy).

When you click OK , your function will be inserted into the active cell on your worksheet.