Resource Usage Report

[uyedasan]

I am using MS Project 2003 and have a need for a Resource Usage Report which
is to be generated from a Resource Pool where I roll up the tasks each
resource is assigned to into each resource then instead of the hours per
period showing in cells in the report I get a horizontal bar graph showing
the overall duration for each resource. The resulting chart should look like
a simplified Gantt Chart showing each resource's allocation as a bar. Oh, we
want to see all resources on a page and not one at a time.

We want to use this simplified report to just show when a resource is
working on a project and when they will be available for their next
assignment. Some of our staff prefer this to seeing the number of hours which
is the default.

Of course, the next thing we will want after we can get this report is which
projects they are working on. I have inserted a column in the Resource Usage
view of the Resource Pool file that shows the path and name of the project
files that use the pool so maybe there is a way to also show the project
number either to the right of each bar or in the bar.

Whew! I hope you guys can help me. Thanks.

 

[John]

I am using MS Project 2003 and have a need for a Resource Usage Report which
is to be generated from a Resource Pool where I roll up the tasks each
resource is assigned to into each resource then instead of the hours per
period showing in cells in the report I get a horizontal bar graph showing
the overall duration for each resource. The resulting chart should look like
a simplified Gantt Chart showing each resource's allocation as a bar. Oh, we
want to see all resources on a page and not one at a time.

We want to use this simplified report to just show when a resource is
working on a project and when they will be available for their next
assignment. Some of our staff prefer this to seeing the number of hours which
is the default.

Of course, the next thing we will want after we can get this report is which
projects they are working on. I have inserted a column in the Resource Usage
view of the Resource Pool file that shows the path and name of the project
files that use the pool so maybe there is a way to also show the project
number either to the right of each bar or in the bar.

Whew! I hope you guys can help me. Thanks.

uyedasan,
In order to get the type of graphical report you want you will need to
export Project data to another application, usually Excel. And the
process to generate the report will require VBA. If you do have some
experience with VBA, you can probably do it yourself will a little help
- that's what we are here for (except you should post this to our sister
newsgroup, microsoft.public.project.developer). If you do not have any
VBA experience, you could hire someone to write the code for you.

John
Project MVP