Group Field

The Group Field module provides the user with the ability to group fields together in a report. Group fields are a subset of the Report fields. The user determines whether to show the Header, Footer, or include Page Breaks. When exporting to Excel, the Group Fields are converted to Report Fields.

 

Click Common Buttons for a description of the buttons found throughout the system and their uses.

 

 

 

 

Field

Description

Group Field

The user selects a field from the dropdown list. This field is required. If the field is not available, return to the Report Fields tab to add the field.

Sort Direction

The user selects whether the field will be listed in ascending (A Z), which is the default, or descending ( ZA) order. This field is required.

Show Header

A check in the box, which is the default, will place the new result of a field above the table for each new field result. For instance, if the field group is country, then the name of the country will appear above its table.

Show Footer

A check in the box, which is the default, indicates that the total will appear at the bottom of each table. For instance, if the field group is country, then the total number of records in the table for a specific country will appear below its table.

Page Break

A check in the box indicates that the page will break when a new result occurs for this field.