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

Sorting Your Jet Reports


By default, results returned by a Jet function are sorted in ascending order based on the field values returned; however, you can override the normal sorting and sort in ascending order or descending order based on any field in the table you are using.

Help Topics

NL Function

Sort by Sum or Count

If you want to sort ascending, put a "+" followed by the field name in the FilterField parameters.

To sort descending, put a "-" followed by the field name in the FilterField parameters.

The filtering properties of the FilterField remain intact so you can enter a filter in the Filter parameter. If you want to sort on a field without a filter, put a "*" in the corresponding filter since blank filters are not allowed.

The following NL function sorts by CompanyName while filtering for CompanyName starting with B.

=NL("Table","Customers",,"+CompanyName","B*")

The following NL function sorts the values of the Invoice ProductID field by the values of the CustomerID field in ascending order, then by the values of the Quantity field in descending order.

=NL("Table","Invoices","ProductID","+CustomerID","*","-Quantity","*")

_____________________________________________________________________

Specific Database Examples for Jet Professional

With Northwind, the following NL function sorts by CompanyName while filtering for CompanyName starting with B.

=NL("Rows","Customers",,"+CompanyName","B*")

The following NL function sorts Invoice ProductIDs by CustomerID then by the Quantity, in reverse order.

=NL("Rows","Invoices","ProductID","+CustomerID","*","-Quantity","<>0")

 

=NL("Rows","Customer",,"+Search Name","B*")

=NL("Rows","Customer","Name","+State","*","-Sales ($)","<>0")

=NL("Rows","Customer","No.","+State","*","Sales ($)","<>0")

State, No.,

 
_________________________________________________
This section applies to Jet Reports Version 7.x and older
 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments