You can group data on a column from a detail dataset by including the merge field {{TableGroup:DatasetName:FieldName:Show}} in the first row of a table.

Do not mix and match the Tablegroupstart or End method with the Tablegroup method. You must pick one method for your template.

The TableGroup function is limited to one merge field per table. The FieldName value must be a single merge field from the same dataset you are using for the TableGroup. 

Syntax

{{TableGroup:DatasetName:FieldName:Show}}

OR

{{TableGroup:DatasetName:FieldName:Hide}}

ValuesDatasetName is the name of the dataset from the Template Builder window.


FieldName
 is the name of the field from the Template Builder window, and is the field that creates the groups.

Show indicates to display the value of the field for each grouping. OrHide hides the values in the merged output file.

The Hide value is useful when grouping on a field with a value you don't want to display, such as a record ID.

NotesThe FieldName in the TableGroup field must not contain hyphens (-) or colons (:). If your field name contains these, use the SCHP parameter in your button URL to strip out punctuation from the field name.

The field names for TableStart and TableEnd must not be abbreviated and must be on the same row of the detail table.

Usage

Returns on merge