Filter
Top Products
CHAPTER 9 Filtering, Sorting, and Grouping Rows
DataWindow Designer User’s Guide 273
4 Drag the column(s) you want to group on from the Source Data box to the
Columns box.
Multiple columns and multiple group levels
You can specify more than one column, but all columns apply to group
level one. You can define one group level at this point. Later you can
define additional group levels.
In the following example, grouping will be by department, as specified by
the
dept_id column:
If you want to use an expression, you can define it when you have
completed the wizard. See “Using an expression for a group” on page 275.
5 Click Next.
DataWindow Designer suggests a header based on your data source. For
example, if your data comes from the
Employee table, DataWindow
Designer uses the name Employee in the suggested header.
6 Specify the Page Header text.
7 If you want a page break each time a grouping value changes, select the
New Page On Group Break box.
8 If you want page numbering to restart at 1 each time a grouping value
changes, select the Reset Page Number On Group Break box and the New
Page On Group Break box.
9 Click Next.