## Hierarchical Options dialog box

This dialog box appears when you choose the Hierarchical Grouping Options command from the Report menu.

##### Available Groups

Select the group that you want to sort hierarchically from the list.

##### Sort Data Hierarchically

Select this check box to sort the data in the selected group hierarchically.

##### Instance ID field

Select the field you want to organize hierarchically.

Note: It will normally be the same field that you grouped by.

##### Parent ID field

Select the field by which you want the Instance ID field organized.

For example, for a company hierarchal report, select the data field listing whom the employee reports to.

The type of the Instance ID and the Parent ID must be the same. For example, they both must be strings (text) or numbers.

##### Group Indent field

Enter the amount you want to indent for each subgroup.

Note:

- The top level of the hierarchy is determined by group instances that match the Instance ID and Parent ID.
- If a group instance is not connected to any Parent ID, it appears at the top of the hierarchy.

###### Related topics

Grouping data hierarchically

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com