Filter
Top Products
Grouping rows
278 DataWindow .NET
You can also sort on additional rows. For example, if you want to sort by
employee ID within each group, specify
emp_id as the third sorting column.
For more information about sorting, see “Sorting rows” on page 267.
Rearranging the DataWindow object
When you create a group, DataWindow Designer creates two new bands for
each group:
• A group header band
• A group trailer band
The bar identifying the band contains:
• The number of the group
• The name of the band
• The name of each column that defines the group
• An arrow pointing to the band
You can include any control in the DataWindow object (such as columns, text,
and computed fields) in the header and trailer bands of a group.
Using the group
header band
The contents of the group header band display at the top of each page and after
each break in the data.
Typically, you use this band to identify each group. You might move the
grouping column from the detail band to the group header band, since it now
serves to identify one group rather than each row.
For example, if you group the rows by department and include the department
in the group header, the department will display before the first line of data
each time the department changes.