Java Reference
In-Depth Information
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.
