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?