Hierarchy in crystal

[sunsree]

Hi!

I have a table like the following
| Emp_Id | Mgrno |Levels|
|--------+--------+------|
| | | |
|--------+--------+------|
|Brinkman| | 3|
|--------+--------+------|
|Nobelr |Brinkman| 2|
|--------+--------+------|
|Stackr |Brinkman| 2|
|--------+--------+------|
|W00014 |Stackr | 1|
|--------+--------+------|
|W00015 |Stackr | 1|
|--------+--------+------|
|W000949 |Nobelr | 1|
|--------+--------+------|
|W000997 |Nobelr | 1|


and my question is that in crystal is there any way that i can build the hierarchial structure the same way like if i choose the level 3(brinkman) the two persons under him stackr and nobelr(level2 ) and the Level 1 has to be displayed and if i choose stackr only the 2 persons under him (level1) has to be displayed please do let me know if anybody is familiar with the above ......

thanks

 

[kenhamady]

You might want to read up on the &quot;Hierarchical Grouping&quot; feature - it was made for just this purpose. You should be able to limit the levels by selecting for a level < X . Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[sunsree]

Hi!

I tried to work the same way but it did not work out for me so can you please walk me thru the steps... IT would be great if you can help me with this problem.


Thanks

 

[sunsree]

Hi! i have used the parameter the Mgrno and when i enter the Brinkman iam getting only upto the first level that the stackr and the Nobler (level 2 ) is displayed but i wanted to get the the (level 1) also and i am unable to specify the condition the level no as i wanted it to be parameterized basing on the Mgrno only......


Thanks

 

[kenhamady]

What is your record selection formula? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[chelseatech]

I doubt you can do the hierarchy the way you want by using record selection. There is no record selection criteria for people further down the hierarchy.

Select MANAGER=Brinkman will omit StackR staff as there is no indication in their record that they are in BrinkMan's hierarchy.

But I think it can be done using conditional section suppress. I've developed a report to illustrate partial indents (indent the one field in hierarchical group but not others). It needed to build a &quot;level counter&quot; and you could use that to achive what you want in your report.

Email me directly, and I'm happy to send you the demo rpt (crystal@chelseatech.net) Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm