Crystal Reports: Duplicate Members in Hierarchy Rolling Up Incorrectly
Posted on 2007-10-09
I have a hierarchial report that is incorrectly displaying records. In my database, there is the real possibility that pairs of parent and dependent members can be duplicated within the hierarchy. For example, here are the results I'm getting:
As you can see, there are multiple pairs of dependents that are rolling up under 'POLAND'. In the database (which I have verified is correct), these multiple child records (and their corresponding parents) roll up under a different "previous" parent entirely. Again for example, the entire 'POLAND' and its dependents also exist under a different third-level parent (other than 'CORP'). Crystal is grouping all of these duplicate members under the first occurrance of the parent member, rather than displaying all of the records in the order that they appear within the dataset.
In my Crystal report, I am grouping on the child field - in orginal order. I need to preserve the original database order in this report.
I would think that this incorrect rollup could be controlled within the report itself, but nothing I've tried so far is handling this.
Any and all help would be greatly appreciated! Please let me know if there is a need for further clarification.
Operation System: Win XP Pro SP2
Crystal version: Crystal Reports XI
Database: Microsoft Jet 4.0
Programming Language: VB .NET