## Change Group Options dialog box

This dialog box appears when you click the Options button in the Change Group dialog box.

Use the Change Group Options dialog box to edit an existing group.

##### Database field

Use this list to select a new database field to group by.

##### Order

Use this list to select the sort order for your group.

##### Customize Group Name Field

The group name field is displayed in the group tree and in the group header. By default, the group name field has the same values as the group field. Select this check box to change the group name field to:

- a database field
- a group name formula that returns a string value, to generate values for a group name field.

For example, you could group on the Customer ID, but display the Customer Name as the group name.

Alternatively, you could group on the Customer ID, but use the following formula to display both the Customer ID and the Customer Name in the group name:

`ToText ({Customer.CustomerID}) + " : " + {Customer.CustomerName}`

Note: You cannot include a field that is evaluated at runtime, such as a running total field, summary field or another group name field, in a group name formula.

##### Keep group together

Select this check box to keep your groups from breaking across pages.

##### Repeat group header on each new page

If you want your groups to break across pages, select this check box to repeat the group header for every successive page.

###### Related topics

Change Group dialog box

Insert Group dialog box

Specified Order tab

Others tab

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com