Show task hierarchy

D

Deluth

Hi. I am tracking a project across different groups. When I bring up the Resource Usage view to see all the tasks, I only see the actual task, I don't see the parent tasks. Is there a way I can see the parent tasks on the same line with the actual task so that I can differentiate the tasks between all the different categories that the resource is doing?

Example: category1->category2->category3->task name
 
R

Rod Gill

Hi,

Not in Project, but if you write VBA code to export the data to Excel, you
can add whatever data you want.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/
Deluth said:
Hi. I am tracking a project across different groups. When I bring up the
Resource Usage view to see all the tasks, I only see the actual task, I
don't see the parent tasks. Is there a way I can see the parent tasks on
the same line with the actual task so that I can differentiate the tasks
between all the different categories that the resource is doing?
 
T

Todd

Deluth

Below is a VB function that taskes a 'task' object and returns a string showing the path withing the project plan where that task resides. It's used in our Project Assistant application to build reports of task details and thought it may be helpful for your use as well

-Tod

For Project Assistant application, goto
http://www.geocities.com/toddscarola

Public Function Get_Hierarchy(Item As Task) As Strin
On Error GoTo Hel

Dim Hierarchy As Strin
Dim Index As Tas
Set Index = Item.OutlineParen
D
If Index = 0 Then Exit D
Hierarchy = Trim(Index.Name) & " \ " & Hierarch
Set Index = Index.OutlineParen
Loo

If Hierarchy <> "" The
Get_Hierarchy = Hierarch
Els
Get_Hierarchy = "This is a root task
End I

Exit Functio
Hell
Get_Hierarchy = "
End Function
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top