How to find/display hierarchy level 1

[damonkimble]

Using Crystal 10 connecting to MS SQL via ODBC.

How do I find, display the hierarchy level of a group? How about manipulating group based upon the level? Obviously, my Hierarchical Group Options is set to Group Data Hierarchially.

thanks,
damon

 

[damonkimble]

anyone, beuller?

 

[GJParker]

I don't understand from your description what it is you are asking, and judging from teh lack of answers neither does anyone else.

Please be more specifiic and explain eaxctly what it is you are trying to achieve.



Gary Parker
MIS Data Analyst
Manchester, England

 

[Madawc]

If your report has several groups, you should be able to tell this from GH1, GH2 etc in the left-hand margin. Is that what you are after?

You can also find Group Export from the menu via Report. This allows you to change the order of the groups.

Does this help? If not, please explain what it is you are after.

Madawc Williams (East Anglia, UK)
Windows XP & Crystal 10

 

[lbass]

If you are drilling down on the hierarchical groups, you can use the function drilldowngrouplevel to identify the group levels during drilldown.

-LB

 

[damonkimble]

drilldowngrouplevel doesn't work as this is not drilldown, but rather hierachy. Everything returns 0.


Using a query of form:
select id, parent, name
from table


Grouping hierarchially would give results such as:

President
VP of this
Sr Director of this
Director of this 1
Director of this 2
Manager of this
Underling of this 1
Underling of this 2
Underling of this 3
VP of that
Sr Director of that
Director of that 1
Manager of that
Underling of that 1
Underling of that 2
Underling of that 3
Director of that 2
Underling of that 4
Underling of that 5
Underling of that 6


In this case the levels would be:
1 - President
2 - VPs
3 - Sr Directors
4 - Directors
5 - Managers & Underling of that 4-6
6 - Underlings (this and that) 1-3


How do I display (access, capture, view, etc.) the level of a record?

thanks,
damon

 

[lbass]

When I suggested the drilldowngrouplevel I did qualify that by saying "If you are drilling down into hierarchical groups..." Anyway, in the help section (at least in CR XI), you can read about the following function, which should give you what you are looking for:

HierarchyLevel (GroupingLevel ({table.groupfield}))

-LB

 

[damonkimble]

Thanks LB, HierarchyLevel (GroupingLevel ({table.groupfield})) does work in XI (testing an eval copy). However, it's not in 10. Any idea how to mimic this in prior versions?

damon

 

[lbass]

Sorry, no.

-LB