Show a task custom fields in the Resource Usage form

J

JimS

I'm using the Resource Usage form and trying to display a task custom column.
Task Field Text10 is nicknamed "CP Nbr". I want to display the "CP Nbr"
column next to each task, or group by it at least. Can anyone help?
 
J

JulieS

Hello Jim,

When you add a field (Text10) to the Resource Usage view and add data,
you are adding data to the Resource Text10 field not the Task Text10
field. If you added data to the Text10 field on the indented line
underneath the resource's name, you added data to the Assignment Text10
field, not the Task Text10 field.

If you are using Project 2003 or earlier you could use a variation on a
macro written by fellow MVP Jack Dahlgren to copy the data from the
Assignment Text10 field to the Task Text10 field. Jack's macro "Copy
Task Fields" can be found at: http://masamiki.com/project/macros.htm.
The macro would have to be modified to copy from Assignment Text10 to
Task Text10.

See FAQ #51 for details on task, resource, and assignment data in
Project 2003 and earlier releases. The FAQ can be found at:
http://project.mvps.org/faqs.htm

If you are using Project 2007, there are actually two separate fields
for Assignment data, Resource Assignments and Task Assignment data. If
you are using Project 2007, you'll have to work by entering the data
manually, as far as I know. (There may be a method through VBA, but I'm
afraid I can't help there. If you wish to pursue that option further,
or if you have questions about Jack's macro, please post to the Project
Developer newsgroup.

However, you should be able to group your resource assignment data
through a custom group. When you create the group, make sure you select
to group assignment not resources and then select the Text10 field.

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
 
J

JimS

I found the second reference and executed it. It worked perfectly. Is there a
way with MSP 2003 to do a "startup" macro so it copies those text fields
every time rathe than forcing my client to execute a macro manually?
 
J

JulieS

Hi Jim,

If you place the code in the Open event of the file it should trigger
every time the file is opened.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top