Typically, a detail dataset (a report or a query) is displayed in a Detail Region. However, using a TableList field, you can display a column from the Report or Query as a list of values, separated by a punctuation mark you specify.

For example, suppose you're using a report to gather a list of Contacts at a given Account:

The merge field would look like the following. Notice the comma (,) as the last component of the field:

Using a TableList field, you can display the results in a list:

The employees at your location are Rose Gonzalez, Sean Forbes, Pablo Estrella.

To create a TableList field:

Create a merge field with the following syntax:{{TableList:DatasetName:FieldName:Punctuation}}

• Where:
  • DatasetName: is the name of the detail data set
  • FieldName: is the merge field name as displayed in the Template Builder window

Punctuation is the character that will separate the list values. You may not use a quote (") or colon (:) as the punctuation value. Duplicate values from the list are removed automatically.