Tree View

Applies to: Kyvos Reporting

Tree view allows users to view and select parameter values in a hierarchical format, providing additional context such as groupings or classifications. This helps users make informed selections by understanding where a value fits in a broader structure.

Use Case Example

Text Box View	Tree View

Text Box View	Tree View
Indore Bhopal Bangalore Los Angeles San Francisco Las Vegas	India Madhya Pradesh Indore Bhopal Karnataka Bangalore United States Nevada Las Vegas California San Francisco Los Angeles

Enabling Tree View

To enable tree view for a parameter:

Select the Tree View checkbox on the Tree View tab header.
Configure one of the following tree types:

Tree Types

Type	Description

Type	Description
Flat	Use when the source data is in a flat structure. Display values (leaf nodes) are set under Dropdown Source, while upper levels (nodes) are configured in Tree View Details.
Hierarchical	Use when the source database supports hierarchical relationships (e.g., Oracle with `START WITH... CONNECT BY`). Requires structured SQL returning hierarchy fields.

Configuration Guidelines

For Flat Tree

Ensure the SQL query retrieves all required fields to construct the hierarchy.
In Tree View Details, define each level of the tree hierarchy.
- Topmost level in the first row.
- Child levels in subsequent rows.
- Click Add to include more levels.
- Click Delete to remove a level.

For Hierarchical Tree

Your SQL must return the following columns:

Column	Description

Column	Description
`NODEID`	Unique ID of the current node
`PARENTNODEID`	ID of the parent node
`NODELEVEL`	Numeric level of the node
`NODEVALUE`	Value to be displayed for the node

Example query (Oracle):

SELECT child AS "NODEID", parent AS "PARENTNODEID", LEVEL AS "NODELEVEL", child AS "NODEVALUE"
FROM test_connect_by
START WITH parent IS NULL
CONNECT BY PRIOR child = parent;

User Behavior at Runtime

When running a report with a tree-view parameter:

A dual list panel is presented for selection.
Users can select:
- One or more leaf nodes under a parent (if Multi Select is enabled).
- Entire parent nodes with or without selecting individual children.
Tree view is not supported for Search-enabled parameters.