Skip to Content
author's profile photo Former Member
Former Member

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.


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Aug 02, 2012 at 02:51 PM


    Right click on the field and select Format Field... and check on the option to Suppress if Duplicate...


    pastedImage_0.png (37.0 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.