Skip to Content
0
Former Member
Sep 13, 2010 at 03:51 AM

Grouping

34 Views

In Crystal Report, can we create Hierarchy (using Group), and then restrict them to display only certain Hierarchy for each Group?

Take this example: Product ID as hierarchy in my BW Query. I have the following hierarchy:

World

-->US

-


>South US

-


>Product ID1

-


>Product ID2

-


>Product ID3

-


>North US

-


>Product ID1

-


>Product ID2

-


>Product ID3

-->Europe

-


>South Europe

-


>Product ID1

-


>Product ID2

-


>North Europe

-


>Product ID1

-->Asia

-


>South Asia

-


>Product ID1

-


>Product ID2

In CR, I can create a Group and use Product Parent ID and form the Hierarchy. So I have one Product Hierarchy (Group) that consist of all it sub-group (Child).

However, is there a way for me to create 3 separate group (US, Europe and Asia) separately and independently so that I can place them into different section in the CR, and can drill-down to the each of the sub-group accordingly? Example:

Group 1:

-->Europe

-


>South Europe

-


>Product ID1

-


>Product ID2

Group 2:

-->Asia

-


>South Asia

-


>Product ID1

-


>Product ID2

Group 3:

-


>North US

-


>Product ID1

-


>Product ID2

-


>Product ID3

How can we restrict the Hierarchy Node based on the Group? Example: Group 1 selection = South Europe, Group 2 selection = South Asia, Group 3 selection = North US.

Can this be done in CR?

Please help.