Create Task Usage Visual Report

[John]

I am trying to create a Visual Report that looks similar to the task
usage view so I can compute all resource availability and assigned
work by week or month. I tried creating the report with the Resource
Usage table and selecting the Resource Name, Work, Work Availability,
and Remaining Availability using a resource pool and a master project
but the data is not displaying what I am expecting. The Work
Availability displays daily availability and the work displays the
total worked assigned in one column by I can't seem to get the day by
day or week by week values. Here a week by week snippet of what I
want:

Resource Name 07/29/07 07/30/07 ......12/31/07
Work
Work Availability
Remaining Availability

Does anyone have a solution?

 

[Jim Aksel]

You will need to create it from a new template.
Here is some general guidance... for the new item,
Reports/Visual Reports/New Template..
select the Assignment Usage
In the Field picker I choose Work, Start/Finish, tasks.

When the pivot table appears, I dragged dates to the top (columns)
Then I dragged Tasks to the left, and resources to the far left.
I dropped Work into the table.

So, as long as Resources are as far left as you can get it, with Tasks to
the right of it, you get something pretty much like a Task Usage View.

Try that and see if it is what you seek. You can adjust the level of detail
displayed from the drop downs on the pivot table.

--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

 

[John]

You will need to create it from a new template.
Here is some general guidance... for the new item,
Reports/Visual Reports/New Template..
select the Assignment Usage
In the Field picker I choose Work, Start/Finish, tasks.

When the pivot table appears, I dragged dates to the top (columns)
Then I dragged Tasks to the left, and resources to the far left.
I dropped Work into the table.

So, as long as Resources are as far left as you can get it, with Tasks to
the right of it, you get something pretty much like a Task Usage View.

Try that and see if it is what you seek. You can adjust the level of detail
displayed from the drop downs on the pivot table.

--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visithttp://project.mvps.org/for FAQs and more information
about Microsoft Project







- Show quoted text -

Thanks, that solves part of the problem. I used the Resource Usage
view to create this report and the work values are correct. However,
the data from the Work Availability and Remaining Availablitly are
zero?

Any suggestions?