Displaying resource assignment at the summary task level

[Lars Aurdal]

Hi,

I have a project with several levels of detail, on the top level I have four
summary tasks WP1 to WP4, these have summary tasks below them etc. At the
lowest level are the actual tasks (well.. obviously)

I have 4 resources working in my project, the project runs over several
years. What I would like is to see how many hours each resource is to work
in some year at the topmost summary level. In other words, I need MP to
generate information like

John 2006 2007
WP1 2 10
WP2 10 100
WP3 30 5
WP4 10 10
Lisa
WP1 60 30
etc

I tried the resource usage wiew setting the "assignements keeping outline
structure", but the problem is that it seems impossible to make reports on a
summary task basis, you have to expand to the level just above the final
task level to see any numbers for actual work.

Any ideas on how to obtain such information?

Best wishes from snowy Oslo

Lars Aurdal

 

[John]

Hi,

I have a project with several levels of detail, on the top level I have four
summary tasks WP1 to WP4, these have summary tasks below them etc. At the
lowest level are the actual tasks (well.. obviously)

I have 4 resources working in my project, the project runs over several
years. What I would like is to see how many hours each resource is to work
in some year at the topmost summary level. In other words, I need MP to
generate information like

John 2006 2007
WP1 2 10
WP2 10 100
WP3 30 5
WP4 10 10
Lisa
WP1 60 30
etc

I tried the resource usage wiew setting the "assignements keeping outline
structure", but the problem is that it seems impossible to make reports on a
summary task basis, you have to expand to the level just above the final
task level to see any numbers for actual work.

Any ideas on how to obtain such information?

Best wishes from snowy Oslo

Lars Aurdal

Lars,
If I understand correctly what you want, you can't get there from here
without either restructuring the file or using VBA. The Resource Usage
view shows resources and assignments not resources and tasks. The
outline structure shown in task views (e.g. Gantt Chart) does not exist
for assignments because summary lines are not tasks and therefore do not
(or should not) have any resource assignments.

Probably not the answer you wanted to hear.

John
Project MVP