Operation Manual

Sorting, Grouping, and Totaling
Grouping data
10
Crystal Reports User’s Guide 181
6. Type “Less than $10,000” in the Group Name field.
This is the name that will appear as the Group Name field value for the group.
7. Since the first group is to contain only those records that have a Last Year’s
Sales figure of less than $10,000, set the fields so your condition reads:
is less than 10000
8. Click OK to return to the Specified Order Tab.
9. Click New.
The Define Named Group dialog box reappears.
10. Set up a second group that contains values between $10,000 and $25,000.
• Type “$10,000 to $25,000” in the Group Name field.
• Set the first field so the condition reads: is between.
• Specify a range of values:
• Type “10000” in the top field.
• Type “25000” in the bottom field.
11. Click OK to return to the Specified Order tab.
12. Click New.
The Define Named Group dialog box reappears.
13. Set up the final group that contains all values over $25,000.
• Type “Over $25,000” in the Group Name field.
• Set the first field so the condition reads: is greater than.
• Type “25000”.
14. Click OK to return to the Specified Order Tab.
15. Click OK.
The report is grouped by interval in a specified order.