Custom Report

[R Casali]

Good Afternoon,

The project plan that I am working on has a field ("text2") that has been
set to capture one of about eight (8) project sub-codes, for the purposes of
time tracking. This field is on the individual task level.

I would like to be able to tie each resource name to the relevant project
sub-codes, then to the sum of the work associated with all of the tasks
sharing the same subcode.

This is essestially the Resource Usage View, with the individual tasks
grouped by my project sub-code fields.

Any ideas? Thank you and have a great day!

 

[John]

Good Afternoon,

The project plan that I am working on has a field ("text2") that has been
set to capture one of about eight (8) project sub-codes, for the purposes of
time tracking. This field is on the individual task level.

I would like to be able to tie each resource name to the relevant project
sub-codes, then to the sum of the work associated with all of the tasks
sharing the same subcode.

This is essestially the Resource Usage View, with the individual tasks
grouped by my project sub-code fields.

Any ideas? Thank you and have a great day!

R Casali,
First I recommend you go to our MVP website at:
http://project.mvps.org/faqs.htm, and take a look at FAQ 51 - Data
Types: Task, Resource and Assignment. Once you understand that you will
see that you need to translate task Text2 field sub-codes into
assignment Text2 field sub-codes and the quickest way to do that is with
a simple VBA macro (see FAQ 37).

Once you have all the data in place, you probably want to use Project's
grouping function (Project/Group By) to sum up the work for each project.

Hope this helps.
John
Project MVP