One way a report can transform data into useful
information is by grouping it into meaningful categories. For
example, customer classes, credit limits, or transaction amounts
are just some of the ways you could group information. To group
information on a report, you will do the following:
Determine the items to appear in the
group. Determine which table or tables contain the information you
want to appear in the group. List the fields that you want to
appear in the group, and the fields that will used to determine the
members of each group.
Sort the report data in an order
appropriate for creating the group. You need to sort the data for
the report so that the report items appear in an order that allows
them to be grouped.
Create additional headers for each group
category. Additional headers for the report will contain the
information that describes each group.
Create additional footers to summarize the
group information. Additional footers for the report can perform
summary actions such as totaling or subtotaling for each