Hierarchical Grouping Not Right...

[rsknut]

Crystal Reports 8.5
Oracle8i Stored Procedure

Hello,

The report I'm creating uses Crystals hierarchical grouping tool to create a parent-child relationship. The report is also grouped by the following:

Group#1 - Root Value (there can be more than one root [parent] in each report)
Group#2 - Grouping variable (used to group childeren for subtotals)
Group#3 - Child

The report is built off a temp table loaded from a recursively called oracle stored procedure.

PROBLEM:
Example -

level parent child
1 A B
2 B C
3 C D
4 D E
4 D F
4 D E
4 D F
3 G D

The last two level 4 values need to be placed under the last
level 3 G D. Not grouped altogether under the level 3 C D item.

Any suggestions on how to get around this?

Thanks!

 

[Madawc]

I know of no way in Crystal to stop detail lines being assigned to their proper group. The only way I can think of is to make the G_D data appear in C_D, and the C_D show up somewhere else. Some sort of fiddle with a formula field, I have done similar things. But it can be based only on specific values.

Madawc Williams
East Anglia, Great Britain