Group Expert Dialog Box
Use the Group Expert to specify how fields will be grouped on your report. You can also use the dialog box to reposition groups and to edit the criteria used for triggering and sorting groups. This dialog box appears when you right-click a Group Header in the Report Designer or Group Name in the Field Explorer and select Group Expert, or when you right-click in the Report Designer, point to Report and choose Group Expert.
Note
To display the Field Explorer, click the Crystal Reports menu, click Field Explorer.
| Available Fields | This list displays all of the fields available for use in grouping. The list is based on the report fields you chose in the Field Explorer and the tables you selected on the Data tab of the Database Expert. |
| Browse Data | Click this button to browse the data of the field that is selected in the Available Fields list. |
| Find Field | Click this button to enter the name of a field you'd like to locate in the Available Fields list. |
| Add or remove arrow buttons | Use the > arrow adjacent to the Group By list to add fields from the Available Fields list. Use the < arrows to remove fields you've already added. Double arrows add or remove all fields. |
| Group By | This list displays all of the fields you've selected for grouping. As you add fields, they are added in a hierarchy. This hierarchy establishes the order the groups will appear in the report.
When you enter a group, that group appears directly above and below the Details section. When you add a second group, it appears between the Details section and the first group. The third group is between the Details section and the second group, and so on. Thus, when you look at the Report Designer, the Group Header for the first group is the top group header, and the Group Footer for the first group is the bottom group footer. This Group By list reflects the group footer order of groups; the bottom group in the list is the first group, the group next to the bottom is the second group, and so forth. When you select a group in this list, the program activates those buttons that apply to the selected group. |
| Up or down arrow buttons | Use the up and down arrows adjacent to the Group By list to change the order of fields you've added from the Available Fields list. |
| Options | When you click this button the Change Group Options dialog box appears. Use this dialog box to edit the criteria used for triggering and sorting groups. |