HP Intelligent Management Center Standard Software Platform - Manual (Page 239)

• There cannot be any circular logic in the data (that is, A cannot be related
to B, while B is related to C, and C is related back to A).
For example, if you want to show the hierarchical relationship of the people
who work in a department, you could group data by employee name (the
child field) and specify the hierarchy by using the field that lists whom the
employee reports to (the parent field). Your database tables might look like
the following example.
Supervisor (parent) Employee (child)
Thomas Jane
Mina
Thomas Gerard
Thomas Albert
Mina Thomas
Thomas Beth
Thomas Teresa
Thomas Gareth
Thomas Valerie
Mina Gillian
Crystal Reports 2008 SP3 User's Guide 239
10 Sorting, Grouping, and Totaling
Grouping data