Project 2007

[Luis Martinez-Leon]

I need to show a graphical representation of 'Task Status' sorted by resource
name. I have set up a custom field at the "Resource Usage View" and create a
formula; however, the results are only shown at the resource level and not at
the tasks level. Does any one know how to get visual id of task status at
the resource usage view level?

Thanks...LML

 

[JulieS]

Luis,

When you created the custom field, did you select the option to "Roll
down" assignment rows? If you have entered data or used a lookup
field, the value can be rolled down. If you have used a formula, the
option is not available. You can, through VBA code, copy the data
from the Resource row to the Assignment row.

See FAQ 37 at http://project.mvps.org/faqs.htm for sample code.

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

"Luis Martinez-Leon" <Luis Martinez-Leon @discussions.microsoft.com>
wrote in message
news:[email protected]...

 

[Luis Martinez-Leon]

Julie....it worked. Thanks for the help. Luis M-L

 

[Luis Martinez-Leon]

Julie, I ran the Macro several times under different scenarios and it works
but does not give me exactly what I need. I noticed that the macro copies
the data but does not follow the formula logic.
For intance, the formula I created retrieves a "0" if a taks is on time and
a "-1" if the task is late. If a resource has two tasks, one is on time but
the other is late; then, the 'text field' following the formula should have a
'0' in one task and a '-1' in the other; however, the macro copies a '-1' in
both tasks because the resource is late.

Any help you could provide would be highly appreciated.

 

[JulieS]

Hello Luis M-L,

The resource's name in the Resource Usage view contains the summary
information for that resource. If the resource is late on one assignment,
then according to Project, the resource is late. There's not a "sort-of"
late. Although the assigments have a start and finish date for each line,
the resource only has one overall start and finish. As you note, the *value*
was copied, not the formula.

I'm afraid I don't know if a workaround other than manually changing those
few circumstances where the macro carried through information that you don't
agree with.

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

Julie

 

[Luis Martinez-Leon]

Julie, thanks for the help. I was able to find a work around to obtain what
I need. I made the "Status" field available at the 'resource usage' view.
At the moment, I got the values available in a custom field (2=Late;
0=Complete..etc); I am now working on getting a "Graphical Display" rather
than a number.

Thanks again...Luis M-L

 

[JulieS]

You're most welcome Luis and thanks for the feedback.

Julie
Project MVP

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

"Luis Martinez-Leon" <[email protected]>
wrote in message