Maintain Hierarchy

[prabhu0505]

If I select a particular department, then the table box or chart should list the employees of it in a hierarchical way.

Say,

Sr. Manager, Manager, Department Head, Team Lead, Associates..........

Thnx...

[#2]

Hi,

Still you can use the Rikab suggetion.
your code should be as follow

new:
Load Sr.Manager
 if(Destination = 'Sr.Manager', Destination )&'|'& if(Destination = 'Manager',Destination )&'|'& if(Destination = 'Department Head',Destination ) &'|'& if(Destination = 'Team Lead',Destination ) &'|'& if(Destination = 'Associates',Destination ) as Hierarchy,
 Manager as Manager,
 Department Head as DepHead,
 Team Lead as TLead,
 Associates as Asso
 RESIDENT items;

and you do the following changes in listbox property.

List Box --> Properties --> Tick "Show as treeview" --> With seperator |

Hope this may help you.

- Peterson

[prabhu0505]

Hi Kevin,

 Load Sr.Manager,
if
(Designation1 = 'Sr.Manager', Designation1 )&'|'
&
if
(Designation1 = 'Manager',Designation1 )&'|'
&
if
(Designation1 = 'Department Head',Designation1 ) &'|'
&
if
(Designation1 = 'Team Lead',Designation1 ) &'|'
&
if
(Designation1 = 'Associates',Designation1 ) as Hierarchy,
Manager
 as Manager,
[Department Head]
 as DepHead,
[Team Lead]
 as TLead,
Associate as Asso
RESIDENT
items;

I tried this code but it is giving error.

Please go through my code and suggest me.

Thanks for your continuos support...

Prabhu