This tutorial describes how to use the detail band's Hierarchy Print Options property to create a hierarchical report.

 

Each record in this data source includes the "parent ID" field that defines the parent-child relationship and thus builds the hierarchy.

1.Arrange controls on the report.

oAdd the Report Header and Page Header bands (see the Manage Report Bands | Add Bands section in the Introduction to Banded Reports document for details)

oAdd data-bound labels to the Detail band.

Switch to the Preview tab to see an intermediate result.

2.Specify the Detail band's Hierarchy Print Options property.

Set the following options:

oKey Field Name and Parent Field Name, or Child List Field Name

Set the Key Field Name and Parent Field Name properties if your report's data has the Id-ParentID related fields.

Set the Child List Field Name property if your report's data is recursive. Assign the collection of child objects (records) if they have the same type as the parent objects (records).

oIndent

Specify the child level node offset.

oKeep Together with First Child

Specify whether to print a parent node together with its first child node on the next page if these nodes do not fit at the end of a page.

As you can see in the image above, the Detail band that contains child rows is printed with the specified indent. However, the row (the sum of the label widths) does not fit the page now.

3.Align labels.

oAnchor the first data-bound label to the Detail band's left and right edges. Set the label's Anchor Horizontally property to Both.

oAnchor the rest of the data-bound labels to the right edge of the Detail band (their container). Set their Anchor Horizontal property to Rignt.

4.Add a drill-down control to expand/collapse child rows.

oAdd the Check Box control to the Detail band at the left-most position.

oSet the Check Box control's glyph options. Use custom glyphs for the checked and unchecked checkbox states.

oSet the Detail band's Drill Down Control property to the added Check Box control.

oSet the Check Box's Check State property to the following expression: [ReportItems].[Detail].[DrillDownExpanded] (in the control's Smart Tag or the Property Grid's Expressions tab).

5.Sort report data.

Use the Detail band's Sort Fields property to sort data on each hierarchy level.

6.Highlight root nodes.

To format rows based on their nesting level, use the Current Row Hierarchy Level variable in expressions. For example, specify the Detail band's appearance properties as listed below:

oSet the Back Color property to iif([DataSource.CurrentRowHierarchyLevel] == 0, Rgb(231,235,244), ?)

oSet the Font | Bold property to [DataSource.CurrentRowHierarchyLevel] == 0