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.