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

Grouping and Subtotaling

Since you can create a dynamic list using an NL function, the next logical step is to group the items in the list. The mechanism for grouping is nested NL functions.

Help Topics

Grouping Tutorial
Multi-Level Grouping


Nesting NL functions

When one NL is inside the region of another, the NL functions are nested. The outer NL function lists the grouping criteria, and then the inner NL can use the results of the outer NL as a filter.

When you select report mode, the outer NL will evaluate first, inserting copies of its region for each record and filling in its data values.

Once the outer NL has expanded, the inner NL will expand, making copies of its own region for each of the outer NLs.

Jet Professional evaluates the NL functions from left to right, and top to bottom so if you have put one NL function that acts on rows in cell D4, and one that acts on columns in cell B5, Jet Professional will evaluate cell B5 first.

For more information about Grouping and Subtotaling see:

The Grouping and Subtotaling Tutorial

The Multi-Level Grouping and Subtotaling Tutorial

and our Grouping Reports Videos:

Adding Filters,
Lists, and Totals

Adding Columns
and Dimensions
Adding Sheet
Report Options
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request