beautypg.com

HP Intelligent Management Center Standard Software Platform User Manual

Page 240

background image

Supervisor (parent)

Employee (child)

Gillian

Frances

Gillian

Ruth

Mina

Margaret

Margaret

Paul

Margaret

Charles

The Employee and Supervisor fields contain overlapping data that implies
a hierarchical relationship. There are 15 unique employee names, with four
of these names also appearing as supervisors (Mina, Thomas, Gillian, and
Margaret). Three employees report to Mina, seven employees report to
Thomas, two employees report to Gillian, and two employees report to
Margaret.

Note:

Mina has no corresponding Supervisor. This data implies that Mina is a
top-level supervisor who does not report to anyone else in this table.

If you group a Crystal report on the Employee field, you can further sort the
data to show the hierarchical relationship between these employees and
their supervisors.

Characteristics of a report that you have grouped hierarchically

In addition to a visual representation of the hierarchy inherent in your data,
a Crystal report that you have grouped hierarchically has several other
characteristics:

When you drill down on a group in the hierarchy, the drill-down view also
shows the records that are lower in the hierarchy.

240

Crystal Reports 2008 SP3 User's Guide

Sorting, Grouping, and Totaling

10

Grouping data