Microsoft Office Tutorials and References
In Depth Information
You can choose to arrange the selected data grouped by table, which is the
default, or ungrouped. For a grouped report , the data from a record in the pri-
mary table appears as a group, followed on subsequent lines of the report by the
joined records from the related table. For the report you are creating, data from a
record in the Customer table appears in a group, followed by the related records
for each customer from the Contract table. An example of an ungrouped report
would be a report of records from the Customer and Contract tables in order by
Contract Num. Each contract and its associated customer data would appear
together on one or more lines of the report; the data would not be grouped
The default options shown on your screen are correct for the report Taylor wants, so
you can continue responding to the Report Wizard questions.
To finish creating the report using the Report Wizard:
1. Click the Next button. The next Report Wizard dialog box opens, in which you
choose additional grouping levels.
Two grouping levels are shown: one for a customer’s data, and the other for a cus-
tomer’s contracts. Grouping levels are useful for reports with multiple levels, such
as those containing monthly, quarterly, and annual totals, or for those containing
city and country groups. Taylor’s report contains no further grouping levels, so you
can accept the default options.
2. Click the Next button. The next Report Wizard dialog box opens, in which you
choose the sort order for the detail records. See Figure 4-21.
Choosing the sort order for detail records
click to display
a list of fields
in the report
click to change
The records from the Contract table for a customer represent the detail records for
Taylor’s report. She wants these records to appear in increasing, or ascending,
order by the value in the Signing Date field, so that the contracts will be shown in
chronological order. The Ascending option is already selected by default. To
change to descending order, you click this button, which acts as a toggle between
the two sort orders. Also, you can sort on multiple fields, as you can with queries.