Skip to Content
0
Former Member
Mar 11, 2009 at 09:52 PM

Support for more than one hierarchy

21 Views

Is it possible to include more than one hierarchy in a Crystal Report? I have tried and am getting some unexpected results. I have two groups, each with it's own hierarchy. When I run the report, the top level hierarchy is returning "extra" summary nodes for each level below the top level.

Let's say the hierarchy looks like this:

USA

East Coast

Central

West Coast

When it is brought back into Crystal, it looks like:

USA

Central

West Coast

East Coast

Central

West Coast

The summaries get split up between the extra summary nodes.

It works fine if I remove the hierarchy from the second level group. It appears that Crystal doesn't handle two hierarchies correctly. Has anyone else tried this? Is the solution to use a structure for the second level group?