.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

employee hierarchy using trace tree

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :ASP.Net


I am looking to create an employee hierarchy in a trace tree ( any other suggestions most welcome ) and have 2 specific fields in my table ( employee , reports to )

Now a sample data looks like follows

Employee     Reports to

User A           Manager A

Manager A     Senior manager A

User B           Senior Manager A

User C          Manager A

so on and so forth 

Now how do I get a trace tree so that when i click on Senior manager A  I get Manager A and User B , and then expand manager A to get user A and User C. 

I have been looking around a lot but cannot find a solution. 

Help appreciated. 

View Complete Post

More Related Resource Links

Tree hierarchy



I have a table with a field that points to the key of another record in the table which is its parent, thus creating a hierarchy. Now I want to turn that into a dimension with the hierarchy. How can I accomplish such a thing? Is there any automatic support for that in Visual Studio?



Hierarchy Employee Listing

I am trying create a SQL extract file that has the following layout below.

User  UserBoss Level1 Level2 Level3 Level4 Level5
John               John
Bob    John      John    Bob
Tom    Bob       John    Bob   Tom
Doug   Tom      John    Bob   Tom    Doug
Brad   Doug      John    Bob   Tom    Doug   Brad
Lee    John       John    Lee
Sue    Lee        John    Lee   Sue

This listing doesn't have to be sorted in this order and anyone in the listing could have multiple people reporting to them. Any ideas?

Currently, I have a sql recursive query (plus case statements) working that ranks employees and then puts them in the levels hierarchy as described above. However, I c

suppressing two highest levels of employee hierarchy in excel


Hi.  My recollection is that in mgt studio's cube browser I can drag the highest level executives off an employee hierarchy pivot by dragging level numbers.  After all, we know who the ceo is and the ceo's direct report as well.

I dont see this capability in excel 2007.  When I unclick these top level execs in the filter already being used to hide ex employees, excel still shows the two highest level execs.  Is there an elegant way to suppress them in excel?  I dont want to remove them from the cube, just to suppress them in one particular excel pivot.

How to create a wpf tree with multi-level hierarchy where the children are of the same type as the p


I have a structure of objects as below, where the child elements are of the same type as their parent.  The parent might also contain child elements of different type(s).

My object structure:

Main Site

Main Site

Sub Site

Sub Site

Sub Site


Logical- and Visual Tree

Elements of a WPF user interface are hierarchically related. This relation is called the LogicalTree. The template of one element consists of multiple visual elements. This tree is called the VisualTree. WPF differs between those two trees, because for some problems you only need the logical elements and for other problems you want all elements.

Nested Tracers - is there a way to only log the outer trace?



I have some nested tracers. The outer one has a category of 'PageTrace' and the inner ones have categories of 'DBTrace'. When I set the outer category source to 'All' I get both traces. When I switch on the inner trace, I just get the inner trace.

So, my question: is there any way to just log the outer trace events, i.e. the Page Traces.




May i use the collapse and expand feature (like tree menu) in Report ?


HI all,

May i use the collapse and expand feature (like tree menu) at Report iam using the Report viewer  Control for displaying the Report on my Asp.net Page .


I have number records and each record have detail as i clicked or expand the record then details will be shown is it possible with report viewer control 
If any one have experince before please share the ideas.


Best Regards

Hierarchy ID: Model Your Data Hierarchies With SQL Server 2008


Here we explain how the new hierarchyID data type in SQL Server 2008 helps solve some of the problems in modeling and querying hierarchical information.

Kent Tegels

MSDN Magazine September 2008

Test Run: The Analytic Hierarchy Process


Most software testing takes place at a relatively low level. Testing an application's individual methods for functional correctness is one example. However, some important testing must take place at a very high level-for example, determining if a current build is significantly better overall than a previous build.

James McCaffrey

MSDN Magazine June 2005

The ASP Column: Tree Controls with XSL


Manipulating the TreeView server-side control is very much like programming any other ASP.NET server-side control. There are a number of properties, methods, and events that are available both programmatically and through the designer. Find out how to take advantage of it.

George Shepherd

MSDN Magazine June 2003

Display Employee Record


I have employee table and qualification table

Each employee has multiple qualifications

Now what i want to display is employees basic information like name, identity card, designation etc..

With all the qualification he/she has

please let me know how can i do that

Following is situation which i dnt want


Identity card :123


Qualification one


Identity card :123


Qualification two

Custom tree view for navigating wiki pages

I'm creating an information resource on our intranet (WSS 3.0) using the wiki style format.  The only trick is, unlike a standard wiki, where all pages are directly under the parent, I want to be able to create a customizable tree view where some pages are nested underneath each other.  For example, this particular site talks about all of our different IT systems.  I'll have a wiki page for each system, then underneath each of those pages, there will be more pages for things like training, documentation, etc.  Even though all those pages are at the same level, I need to be able to nest them in a navigational tree view on the quick launch bar.  I suppose if there were also a way to nest the wiki pages themselves, I could just use the pre-packaged tree view.  Anyone have any ideas?

Error in / Application after adding employee search in webpart


Hello everyone,

I am working on sharepoint 2007 and I was editing the webpart of the software and after adding the predefined employee search table, the server has crashed while trying to access the server remotely with the following error message:

Error in / Application

However, while trying to login locally I have no problem and can easily login.

What will be the course of action in fixing this error.

Also the site is complaining of an invalid certificate even after adding an exception.

Any help would be greatly appreciated.

Thank You,

Chris Stanko

Organization Hierarchy - Manger not showing


SharePoint 2007 SP2 on Server 2008 R2

I am doing a custom profile import using AD and a BDC connection.  All the data comes in and populates correctly, including the 'Manager' field which is being populated from the BDC entity. All main fields are being populated from the BDC entity.  Fields are; First name, last name, email, office and cell phone, and manager.

However, when viewing the Organization Hierarchy, the users 'Manager' is not showing up in the Hierarchy. Nothing above the current user is shown in the Hierarchy.  The Manager field is populated with a valid user.  If I display the Manager field in the 'Details' section, I can see the name and click on it to see their profile page as well, so it is all valid and accurate.

Colleagues ( users with the same Manager ) are listed in the Hierarchy, but none of their hierarchy's show the manager either.

I have deleted every profile and then done a full import several times with the same result. Incremental import does ont have any affect either.

Any suggestions or advice on how to get the Manager to display?

Thanks to all!


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend