Specifications

Grouping rows
312 InfoMaker
The group trailer band in this example shows the average and total salary for
the group.
At runtime, the average and total salaries are calculated and displayed:
Sorting the groups
You can sort the groups in a report. For example, in a report showing employee
information grouped by department, you might want to sort the departments
(the groups) by total salary.
Typically, this involves aggregate functions, as described in “Adding summary
statistics” on page 310. In the department salary example, you would sort the
groups using the aggregate function
Sum to calculate total salary in each
department.
❖ To sort the groups:
1 Place the mouse pointer on the group header bar (not inside the band) until
the pointer becomes a double-headed arrow.
2 Click.