Displaying complete task hierarchy in Resource Usage

[Deluth]

Can someone show me how I can display the names of the entire hierarchy of the current task in the Resource Usage view? If the task in question is 6 layers deep, can I display all 6 or at least 4 of the 6 layers? I am walking into a large project designed by someone else, when looking at the Resource Usage, I cannot tell what the resource is doing exactly. Switching between the Gantt and the Resource Usage is a pain... Thanks in advance...

 

[Jan De Messemaeker]

Hi Deluth,

I'm afraid you can't, at least not without some VBA programming.
One of the reasons is that the Resource Usage view does not show tasks.
It shows assignments (the fact that Resource R works on task T)
When you are working on someone else's project it's a bit late, but teh
conclusion is: on a new project, make tsk names explicit enough to
understand them.
The same problem occurs when you will sort tasks by start, for instance:
each time you look at tasks "out of order" you will need more than just the
one-word task names that are often given.

You might be helmped a little bit by showing Resource usage as upper pane
and Gantt Chart as lower pane (See Window, Split) but that does not help you
out completely as Summary tasks without asignments cannot be shown in the
lower pane

Sorry..

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620

Can someone show me how I can display the names of the entire hierarchy of

the current task in the Resource Usage view? If the task in question is 6
layers deep, can I display all 6 or at least 4 of the 6 layers? I am
walking into a large project designed by someone else, when looking at the
Resource Usage, I cannot tell what the resource is doing exactly. Switching
between the Gantt and the Resource Usage is a pain... Thanks in advance...

 

[Deluth]

Jan

Would you recommend a book for me to use to program Project using VBA? I don't know why Resource/Task views can only see Resource/Task Tables, respectively. After all, they're just tables, right? If it takes learning how to program Project so that I can mix the two tables in a custom view, I am willing to do that

Thanks again, Jan!

 

[Jan De Messemaeker]

Hi,

First, to get a feel on how you program VBA in Office (Project, Excel...)
type Alt+F11 and you are in the VB Editor; insert a module and you can write
procedures

A good start is at
prj98vbe.exe at download.microsoft.com
It is for Project 98 but the principles and the great majority of objects
are identical to later versions.

And before you start... in VBA Project you manipulate Project's OBJECTS such
as tasks, resource, assignments, and only rarely selections, rows, columns.

But what you are looking for - making a new view that has essentially
different information from an existing view- is not that easy.
It is NOT JUST A TABLE as you seem to think.
It is about different objects.
Resource Usage displays properties of Resources and Assignments, not of
tasks. So any table you define can only show these properties, and not
things such as the outline parent of the task.
What you need to do is read all assignments, lookup which task they are
about, then copy task properties into assignment fields (such as Text1 or
number7) which you can then display in a table in the resource usage view
But it would still show only one line per assignment8

HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620

Jan,

Would you recommend a book for me to use to program Project using VBA? I

don't know why Resource/Task views can only see Resource/Task Tables,
respectively. After all, they're just tables, right? If it takes learning
how to program Project so that I can mix the two tables in a custom view, I
am willing to do that.