If you select a field to use for grouping, you can click the Grouping
Options button and choose to group the records by exact match or by
the first one to five characters in the field.
8. Click Next to display the sorting options, as shown in Figure 4-6.
You can use these options to make sure that the report is sorted for
improved readability.
9. To add gr oup summarizations to the report, click the Summar y
Options button to display the Summar y Options dialog box, as shown
in Figure 4-7.
10. Select any summarizations you want to add to the report.
In my example, I selected the Sum option to show the total
LowEst
value
by state. Only fields containing numeric values can be summarized.
Figure 4-6:
Select the
sorting
options you
prefer.
Figure 4-5:
Choose a
field to use
to group the
records in
the report.
72
Part I: Accessing Both Ends: Getting Data In and Info Out
08_599658 ch04.qxd 8/31/05 12:46 PM Page 72
|
|