Specifying the grouping columns
To specify the grouping columns
-
In the DataWindow painter, Select Rows>Create Group
from the menu bar.The Specify Group Columns dialog box displays.
-
Specify the group columns, as described in Using the Group presentation
style. -
Set the Reset Page Count and New Page on Group Break
properties on the General page in the Properties view.
Creating subgroups
After defining your first group, you can define subgroups,
which are groups within the group you just defined.
To define subgroups
-
Select Rows>Create Group from the menu bar and specify
the column/expression for the subgroup. -
Repeat step 1 to define additional subgroups if you
want.You can specify as many levels of grouping as you
need.
How groups are
identified
PowerBuilder assigns each group a number (or level) when you
create the group. The first group you specify becomes group 1, the
primary group. The second group becomes group 2, a subgroup within
group 1, and so on.
For example, suppose you define two groups. The first group
uses the dept_id column and the second group uses the status
column.
The rows are grouped first by department (group 1). Within
department, rows are grouped by status (group 2). If you specify
page breaks for the groups, a page break will occur when any of
these values changes.
You use the group’s number to identify it when defining
summary statistics for the group. This is described in Adding summary statistics.