---
title: Summary List and Detail List
description: "\"Summary List\" and \"Detail List\" are used along with the replicator functions **NL(\"Rows\")** or **NL(\"Columns\").**   ### Summary List   It provides a unique list of values from the chosen field. If a value is repeated in the table, you will only see…"
url: "https://globaldata365.com/helpcenter/summary-and-detail-list/"
updated: "2025-05-16"
category: Jet Reports
tags:
  - jet reports NL function
---

# Summary List and Detail List

"Summary List" and "Detail List" are used along with the replicator functions **NL("Rows")** or **NL("Columns").**

 

### Summary List

 

It provides a unique list of values from the chosen field. If a value is repeated in the table, you will only see that value listed once.

 

Typically it can be created using the [NL Function](https://globaldata365.com/helpcenter/nl-function-overview-and-its-usage/). It 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.

 

It has a default sorting of ascending order based on the field used.

![Summary list ](https://globaldata365.com/wp-content/uploads/2022/12/image.png)
Creating a Summary list of **Item No.**from **Item Ledger Entry** table

 **Looking to simplify financial reporting in Excel?**
[👉 Join our Jet Reports Training](https://globaldata365.com/jet-reports-training/) and learn to create real-time, dynamic reports with confidence.

### Detail List

 

A detail list produces a list of record keys based on the filters chosen instead of returning 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](https://support.jetglobal.com/hc/en-us/articles/218953238-NF-Function-Reference) which reference that record key.

 

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

![Detail list](https://globaldata365.com/wp-content/uploads/2022/12/image-1.png)
Function returning record keys from **Cust. Ledger Entry** table

#### If You Need Any Help, [Contact us](https://globaldata365.com/contact/) Now!

[wpforms id="13267"]