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

Using a Detail List or a Summary List


A common design question when using the replicator functions NL("Rows") or NL("Columns") is whether to create a "Detail List" or a "Summary List".

 

Summary List

A Summary List is always a unique list of values from the field chosen. If the value is repeated in the table, you will only see that value listed one time.

A typical summary list consists of a replicator function - NL(Rows), NL(Columns) or NL(Sheets) - and data functions such as NL(First), NL(Sum), NL(Count) which reference the replicator.

The Summary List has a default sort order of ascending based on the field used.

 

Detail List

A Detail List will produce a list of records based on the filters chosen.  The replicating function returns a Record Key rather than an individual field from the database.

A typical Detail List consists of one replicator function (which returns the Record Key) and one or more NF data functions which reference that record key.

The Detail List has a default sort order of ascending based on the primary key for the table used in the replicator.

 

How do I decide which is best for my report?

Detail_or_Summary2.png

 

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

Comments