Grouping the Data
Data in a table is usually organized into groups based on certain criteria. You can define multi-level groups in your table either when creating it or after the table has been built. In this topic, you will be shown how to define groups in an existing table.
To group data of an existing table:
- Select the table and do one of the following:
- Select Insert > Group.
- Right-click the table and select Table Wizard from the shortcut menu.
- In the Group screen of the Table Wizard, select the field in the Resources box as the group by field and select or drag and drop it to the group by box on the right.
- Set the sorting manner of groups at this group level in the Sort column.
- Select the Select N button to specify the Select N condition.
- If the table is in a page report based on query resource, you can also specify the following:
- If the group by field is of Numeric/String/Date/Time type, you can select a special function for the it from the Special Function drop-down list.
- If you want to filter groups at this group level, select the Group Filter button, and then specify the filter conditions.
- To add another group to the table, specify the position of the group by selecting Table or the existing group in the group by box, then select the field in the Resources box as the group by field and select or drag and drop it to the group by box. The new group is then added below the selected group level. Define the group settings as described in steps 3 to 5.
- Repeat the above step to add more groups.
To adjust the order of the groups, select or above the group by box.
To remove a group, select it in the group by box and select or drag and drop it to the Resources box.
- Select Finish to apply the settings.
One or more GH-GF (group header and group footer) row pairs with the selected group fields will have been added to the table.
Note: The following SQL type of data cannot be grouped: Db.SQL_BINARY, Db.SQL_BLOB, Db.SQL_CLOB, Db.SQL_LONGVARCHAR, Db.SQL_LONGVARBINARY, Db.SQL_VARBINARY and Db.SQL_OTHER.
The following topics provide additional information about grouping: