Grouping Report Data
Suppose, we are asked to generate a report that provides aircraft data for aircraft
registered in the United States, and we are required to divide the data by state. This
is a perfect situation to apply report groups. Recall from Chapter 6 that report groups
. Recall from Chapter 6 that report groups
allow us to divide report data when a report expression changes.
Since our new requirement involves limiting the report data to aircraft registered
in the United States, and dividing the data by state, we need to modify the report
query. This can be accomplished by clicking on Data | Report query and entering
the new query in the Report SQL query tab.
The new query limits the result set to aircraft registered in the United States. To
define report groups, we need to click on View | Report Groups , and then click on
the New button.