MSP 2007 - Report by Resource Group

[Leah the pooch]

I want to create a visual report that shows work availability, work, and work
remaining by resource group. I can only figure out how to do this by
resource now.

Any suggestions?

 

[Rod Gill]

How about selecting Project, Groups, More Groups and create a Group Report?

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Leah the pooch]

Yep that is actually how I do it today the issues are:

I can't add work availability & work remaining.
I can't export to excel easily
My work around is copy and paste to excel and manually calculate work
availability by taking max units *2080 and then calculating work remaining
Then I create my graph

It would be much easier if project would just create a pivot table standard
report.

 

[JulieS]

Hi Leah,

With a bit of modification, you can use the standard Resource Usage
report, add the Group field to the data and then fairly quickly
summarize the data.

Use the Resource Work Availability Report. Once the report is
created add Resources from the Pivot Table field list. Then click
on any single resource in the pivot table, right click to show the
shortcut menu and choose "Show properties in report" and select
"Group". You should now see the Resource Group next to the
Resource's name. Copy/paste the data you are interested in (Group,
Work Availability, Work, and Remaining Availability) to another
sheet. Sort by group and use the Subtotals command to create a
subtotal by Group.

I hope this helps. Let us know how you get along.

Julie
Project MVP

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