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...

[spsrk_84]

Hi Saravana,

To create an employee hierarchy or Deoartment hierrarchy use the function like

Hierarchy and HierarchyBelongs To

Using these functions u can create the Hierarchy...

For u reference if u have instaleed Qv9 there is an example file name "What New in Qv 9.Qvw" in examples .In this Sales Rep hierarchy is created like SalesRep-Manager-Superior like this..

Refer the above example stated hope that will help you in achieving ur required task.....

Regards,

Ajay

[prabhu0505]

Thanks alot for your reply.

I will go through and update you.

[prabhu0505]

I have gone through the example but this was not what I expected.

Sorry I need to bit more specific,

Sr. Manager, Manager, Department Head ....

are not fields but value of the field Designation

I hope this help.

Advance Thanks

[prabhu0505]

I have gone through the example but this was not what I expected.

Sorry I need to bit more specific,

Sr. Manager, Manager, Department Head ....

are not fields but value of the field Designation

I hope this help.

Advance Thanks

[#6]

Hi Saravana,

Can you attach your QVW file so that we can work on with that.

[#7]

Try this:

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

Also don't forget to do the following things.

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

[prabhu0505]

Thanks Rikab..

I have a doubt in your example:

whether Sr.Manager, Manager, Department Head...... are fields or value in items table (My expectation is that it should be value)

Advance Thnx..

[#9]

Saravana Prabhu wrote:
I have a doubt in your example:
 whether Sr.Manager, Manager, Department Head...... are fields or value in items table (My expectation is that it should be value)<div></div>

It is a field not a value. That's why I asked for your QVW application. So that I can see why you need hierarchy of a value instead of field.

[prabhu0505]

Sorry Rikab.

Due to some reason, I can't share that file.

Anwsering to your question:

According to me its value of the field "Designation1"

My objective is to achieve the hierarchical order while displaying any object like list box or table box or chart.

Thanks

Prabhu