Displaying Individual Work for Multi Resourced Task

[Nicola A.]

Is there anyway that I can create a table that combines fields from task and
resource tables? I want to be able to display task IDs, task name, various
custom task fields, and the individual work for a specific resource if the
task has multiple resources assigned to it? I want to create single line
report that I can develop a filter that selects only for the specific
resource. Similar to the example below with additional information.

Task #1, Start, End, Baseline Work for Resource #1, Resource #1

 

[John]

Is there anyway that I can create a table that combines fields from task and
resource tables? I want to be able to display task IDs, task name, various
custom task fields, and the individual work for a specific resource if the
task has multiple resources assigned to it? I want to create single line
report that I can develop a filter that selects only for the specific
resource. Similar to the example below with additional information.

Task #1, Start, End, Baseline Work for Resource #1, Resource #1

Nicola,
The only way to get combined view data is either via a split window or
by using the Resource Usage or Task Usage views. However, be advised
that your custom task fields will not appear in the Resource Usage view.
See FAQ 51 - Data types: task, resource and assignment, on our MVP
website at, http://www.mvps.org/project/faqs.htm.

You can get the exact report you want but you will have to export
Project data to another application (e.g. Excel). If you do not need
timescaled data, you can use an export map. If you do need timescaled
data (e.g. resource work over a time span), you can try the "Analyze
timescaled data in Excel" utility or for Project 2007, try the visual
reports feature. To get the exact report you want with a single custom
menu item or toolbar button, VBA is the way to go.

John
Project MVP

 

[BillieTX]

I would like to find a template that guides Economic /Commercial Development
Processes in a small city

BillietX

 

[JulieS]

Hello BillieTX,

I sincerely doubt that such a Project template has been created. If
you are trying to encourage economic development, I'd suggest starting
with a web search. Several years ago Jack Schultz wrote a book called
Boomtown USA. Not the definitive answer, but a good start in your
search.

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