Sort the rows

PocketBuilder does not sort the data when it creates a group. Therefore, if the data source is not sorted, you must sort the data by the same columns (or expressions) specified for the groups.

For example, if you are grouping by dept_id then status, select Rows>Sort from the menu bar and specify dept_id and then status as sorting columns.

Figure 22-8: Sorting data by columns used to group data

The sample shows the Specify Sort Columns dialog box. At top are instructions to drag and drop items and to double click any items you want to edit. A Source Data area displays the columns that you can drag and drop into the Columns box at right. The Columns box contains the columns to be sorted on, dept _ i d and status. For both, the check box for Ascending order is selected.

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”.