Crystal Reports  

Grouping Screen (Report Creation Wizard)

Use the Group screen to specify how fields will be grouped on the report. Creating groups is an optional step in the wizard.

Available Fields
This list displays all of the fields available for use in your report. The list is based on the fields you chose on the Fields screen (Report Creation Wizard)and the tables you selected on the Data screen (Report Creation Wizard).
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. You can change the order of the hierarchy by using the up and down arrow buttons.

You can also set the sorting order for each field you add to the Group By list. Select a sort order from the adjacent list:

  • Click in ascending order to sort the values for the field selected in the Group By list in ascending (A to Z, 1 to 9) order.
  • Click in descending order to sort the values for the field selected in the Group By list in descending (Z to A, 9 to 1) order.
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.

See Also

Summaries screen | Grouping, Sorting, and Totaling Data