I'm trying to create org charts for our business. The org data is in an oracle table. The problem is, I'm not sure how to get the data formatted to work the way it needs to in an org chart.
Currently the table has the following columns:
Employee Name, Division, Bureau, Section, Unit, Group, Org_Code(a concatenation of the previous 5 columns), Manager Name, Responsibility_Type
Logic:
The definition of an employee’s supervisor is relative to the org that they are in.
Supervisors of unit employees have responsibility type code starting at ‘07’.
Supervisors of section employees have a responsibility type code starting at ‘06’.
Supervisors of bureau employees have a responsibility type code starting at ‘05'. Supervisors can have codes of ‘04’ as well
Supervisors of division employees have a responsibility type code starting at ’03’.Supervisors can have codes of ‘02’ and ‘01’ as well.
Supervisors of employees with the min rspb ty cd in their org (ie rspb ty cd ‘04’ in bureau) will have min rspb ty cd in the next level up.
For example, a person in a bureau with rspb ty cd = ‘04’ will report to the person in their division the rspb ty cd that is the min of ‘02’, or ’03.
In org’s where there are supervisors with various responsibility type codes (bureau and section), the supervisor with the maximum code that is greater than the employee’s own responsibility type code should be used.
Here is an example:
Emp name org code rspb ty cd mgr org (based on rules, above) mgr rspb ty cd
Employee1 0202000000 ‘04’ 0200000000 max of ‘01’, ‘02’, ‘03’
Employee2 0202000000 ‘05’ 0202000000 ‘04’
Employee3 0202000000 ‘07’ 0202000000 max of ’04, ‘05’
Employee4*0202000000 ‘08’ 0202000000 ‘05’
Employee5 0202170000 ‘06’ 0202000000 '04’
*Note that Employee3 is not Employee4’s manager because this is the bureau level. Only at the unit level would Employee3 be Employee4’s supervisor
Can this be accomplished in Crystal Reports? Using the Oracle table and logic? I'm looking for suggestions or ideas opn how to accomplish this.
Currently the table has the following columns:
Employee Name, Division, Bureau, Section, Unit, Group, Org_Code(a concatenation of the previous 5 columns), Manager Name, Responsibility_Type
Logic:
The definition of an employee’s supervisor is relative to the org that they are in.
Supervisors of unit employees have responsibility type code starting at ‘07’.
Supervisors of section employees have a responsibility type code starting at ‘06’.
Supervisors of bureau employees have a responsibility type code starting at ‘05'. Supervisors can have codes of ‘04’ as well
Supervisors of division employees have a responsibility type code starting at ’03’.Supervisors can have codes of ‘02’ and ‘01’ as well.
Supervisors of employees with the min rspb ty cd in their org (ie rspb ty cd ‘04’ in bureau) will have min rspb ty cd in the next level up.
For example, a person in a bureau with rspb ty cd = ‘04’ will report to the person in their division the rspb ty cd that is the min of ‘02’, or ’03.
In org’s where there are supervisors with various responsibility type codes (bureau and section), the supervisor with the maximum code that is greater than the employee’s own responsibility type code should be used.
Here is an example:
Emp name org code rspb ty cd mgr org (based on rules, above) mgr rspb ty cd
Employee1 0202000000 ‘04’ 0200000000 max of ‘01’, ‘02’, ‘03’
Employee2 0202000000 ‘05’ 0202000000 ‘04’
Employee3 0202000000 ‘07’ 0202000000 max of ’04, ‘05’
Employee4*0202000000 ‘08’ 0202000000 ‘05’
Employee5 0202170000 ‘06’ 0202000000 '04’
*Note that Employee3 is not Employee4’s manager because this is the bureau level. Only at the unit level would Employee3 be Employee4’s supervisor
Can this be accomplished in Crystal Reports? Using the Oracle table and logic? I'm looking for suggestions or ideas opn how to accomplish this.