6.2.2 Creating a Selection Tree from Recursive Hierarchy
You can create a Selection Tree from recursive hierarchy information. For example, consider the following data. The “Child ID” is the ID of the node itself, while the “Parent ID” is the ID of the node's immediate parent. Nodes that lack a “Parent ID” comprise the top level of the tree.
Parent ID |
Child ID |
Label |
|
1 |
Northeast |
|
2 |
Midwest |
|
3 |
South |
|
4 |
West |
1 |
5 |
New England |
1 |
6 |
Mid-Atlantic |
2 |
7 |
East North Central |
2 |
8 |
West North Central |
3 |
9 |
South Atlantic |
3 |
10 |
East South Central |
3 |
11 |
West South Central |
4 |
12 |
Mountain |
4 |
13 |
Pacific |
The columns above represents the following tree structure.

The “Parent ID” and “Child ID” columns indicate that nodes 5 and 6 share node 1 as parent, nodes 7 and 8 share node 2 as parent, nodes 9, 10, and 11 share node 3 as parent, and nodes 12 and 13 share node 4 as parent.
To create a Selection Tree from a recursive hierarchy defined by “Parent ID” and “Child ID” columns, follow the steps below:
1. Drag a Selection Tree component from the Component tree onto the Viewsheet grid. This creates an empty Selection Tree element.
2. Right-click the Selection Tree, and select 'Properties' from the context menu. This opens the 'Selection Tree Properties' dialog box.
3. Select the Data tab.

4. At the top of the dialog box, select the 'Parent/Child IDs' option.
5. In the 'Table' menu, expand the desired Data Block to reveal its columns.
6. In the 'Parent ID' field, select the column that contains the parent node IDs.
7. In the 'ID' field, select the column that contains the child node IDs.
8. In the 'Label' column select the column that contains the labels corresponding to the child node IDs.

9. Press 'OK' to close the dialog box.
The Selection Tree is now populated based on the selected “Parent ID” and “Child ID” columns.

See Also
Creating a Selection Tree from Individual Columns, to create a Selection Tree using nested columns.
Adding Hierarchy Levels to a Selection Tree, to add levels to an existing Tree.
Selection Tree, in End User, for a walkthrough on Selection Trees.
Using Selection Lists and Trees, for details on Selection element symbols.
Selection List, for information on creating non-hierarchical selection options.
| << Creating a Selection Tree from Chart Data Source | © 1996-2013 InetSoft Technology Corporation (v11.5) | 6.2.3 Selection Tree Properties >> |