Hierarchical Grouping issue

[dev1212]

Hierarchical grouping..

I am grouping on Hierarchy_ID and the parents are Hier_Parnt_ID and Hier_Ult_Parnt_ID..

The data is as follows..

Hier_ID Hier_Parnt_ID Hier_Ult_Parnt_ID
23002 77002 85001
13002 55002 75001
71002 35002 55001
60002 (NULL) 45001
31002 45001 45001


Now when i am going to report-> Hierarchical group options, i have only one parent id to choose. But i have 2 parents here. Hier_Ult_Parnt_id is the parent of Hier_Parnt_id which is the parent of Hier_id

Please let me know how to solve this one.

I would really appreciate your help..

Thanks

 

[Madawc]

Please clarify what you are after. You can have groups within groups, or you can group using a formula field that may use one or another data field as the source. Or you can use Crosstab to group data differently from the main report. Are any of these useful?

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP