Specifications

CHAPTER 9 Filtering, Sorting, and Grouping Rows
Users Guide 307
What you can do
You can use any of the techniques available in a tabular report to modify and
enhance the grouped report, such as moving controls, specifying display
formats, and so on. In particular, see “Defining groups in an existing report”
next to learn more about the bands in a grouped report and how to add features
especially suited for grouped reports (for example, add a second group level,
define additional summary statistics, and so on).
Defining groups in an existing report
Instead of using the Group presentation style to create a grouped report from
scratch, you can take an existing tabular report and define groups in it.
❖ To add grouping to an existing report:
1 Start with a tabular report that retrieves all the columns you need.
2 Specify the grouping columns.
3 Sort the rows.
4 (Optional) Rearrange the report.
5 (Optional) Add summary statistics.
6 (Optional) Sort the groups.
Steps 2 through 6 are described next.
Specifying the grouping columns
❖ To specify the grouping columns:
1 In the Report painter, Select Rows>Create Group from the menu bar.
The Specify Group Columns dialog box displays.
2 Specify the group columns, as described in “Using the Group presentation
style” on page 304.
3 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.