Hierarchical report -urgent

[yehong]

This is the sample data:
Supervisor ID Employee ID Level
Div Manager Div Manager 0
Div Manager Dist Managerx 1
Div Manager Dist Managery 1
Div Manager Dist Managerz 1
Div Manager Sales Managerx 2
Div Manager Sales Managerz 2

This is how the report should look:
Div Manager
Dist ManagerX
Sales Managerx
Sales Managerz
Dist Managery

I have tried using Hierarchical grouping options, but still not able to generate the correct hierarchy.
Any help idea is highly appreciated.

 

[synapsevampire]

Add the table a second time and join the Supervisor ID to the Employee ID.

-k

 

[yehong]

Thanks for your response. I am thinking that you have lead me to a right path. Here are some questions, hope you will help on those too.
I have added the same table with different alias and joined the supervisor id of TableA to employee id of TableA_1.
So, how should the grouping work now? On which field of which table should I create the Group and how should I use the hierarchical grouping options? thanks.

 

[yehong]

Hi, I am still waiting on some help on this issue. Can someone else also put their input here?
Thanks.

 

[Madawc]

Which Crystal? For Crystal 8.5, [Change Group Expert] under [Report] allows you to decide which groups are top, middle and lower.

Madawc Williams
East Anglia, Great Britain

 

[yehong]

I am using CR8.5. By using Change Group Expert, do you think it will handle the hierachy grouping?

 

[kskid]

Based on what you have, there is no logical connection. How did you arrive at Sale Managerx and Sales Managers reporting to Dist Managerx?

Or is it laid out this way

Supervisor ID Employee ID Level
Div Manager Div Manager 0
Div Manager Dist Managerx 1
Div Manager Dist Managery 1
Div Manager Dist Managerz 1
Dist Managerx Sales Managerx 2
Dist Managerx Sales Managerz 2

 

[yehong]

This is how it is put in the table and it is based upon the Level. So for Dist MangerX we have two Sales Mangers x, and y at level 2. Lets say if some people also work under Sales Mangerx, then if we want to show them for Dist Manager X,here is how it should look:
level
Dist Managerx
Sales Managerx 2
Emp1 3
Emp2 3
Sales Mangerd 2
Emp6 3
Sales Managerk 2
Emp4 3

....

 

[Madawc]

With Crystal, it's usually best to try something and see what happens. It's a report writing tool rather than a full programming language, which means you have to fit your needs to what Crystal is good at.

Madawc Williams
East Anglia, Great Britain