User`s guide

Supervisor (parent)Employee (child)
GillianFrances
GillianRuth
MinaMargaret
MargaretPaul
MargaretCharles
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.
• The report contains hierarchical group footers that include the records that are lower in the hierarchy
of each group. You can summarize data across the hierarchies.
• Use the conditional-X-position feature to ensure that the indenting you set to show hierarchical
relationships does not affect other fields in same section of your report.
• Hierarchical levels are supported in the formula language through the use of the GroupingLevel and
HierarchyLevel functions.
Note:
You cannot use hierarchical summaries in formulas.
2012-03-14161
Sorting, Grouping, and Totaling