Skip to Content
Former Member
Aug 02, 2012 at 01:14 AM

To Remove Duplicate nodes from hierarchy


Hi experts,

I am working with Crystal enterprise BO4.0. I have connected a BW query as datasource having a hierarchy in rows and 3 KFs in columns.

My hierarchy has some duplicate nodes Say:

Hiearchy Node values Measure1 Measure2 Measure3

1000 10 20 30

2000 20 30 40

2000 20 30 40

As shown above Hierarchy Node with value 2000 has another underneath node with same value. I want to suppress this duplicate node. OR please tell me the method to suppress a duplicate ROW in crystal report.