HP Intelligent Management Center Standard Software Platform User Manual
Page 240
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