Crystal Reports  

Options Tab

This tab can appear as part of several dialog boxes:

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 define the group name field as:
  • 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. To do this, select the Choose From Existing Field option and choose the appropriate field from the list.

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}

To do this, select Use a Formula as Group Name and click the Formula button to enter your formula in the Formula Workshop.

Note

The Customize Group Name Field option is not available for groups sorted "in specified order."

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.
Note   This option does not appear for the Cross-Tab Group Options dialog box.
Repeat Group Header On Each Page
If you want your groups to break across pages, select this check box to repeat the group header for every successive page.
Note   This option does not appear for the Cross-Tab Group Options dialog box.

See Also

Insert Group Dialog Box | Cross-Tab Expert