How do I create a report with specifc columns in Project 2003?

[MSProjectUser]

I am wondering if it's possible to create a variation of the "Whoe Does What"
Report in Project 2003? I want to exclude the "Units" and "Work" columns,
include a % complete column, and sort by the start date.

 

[John]

I am wondering if it's possible to create a variation of the "Whoe Does What"
Report in Project 2003? I want to exclude the "Units" and "Work" columns,
include a % complete column, and sort by the start date.

MSProjectUser,
The basic answer to your question is, "yes". However, that is not a
simple "yes". First of all, the Units and Work fields are associated
with the assignment information, not the resource information. Those two
fields can be eliminated by simply unchecking the "schedule" option from
the Assignment options under the "Details" tab. The "Who does what"
report is a resource based report and the only "% complete" field for
resources is the % Work Complete field. This field can be added to the
default Usage resource table under View/Table/More Tables.

However, my guess is that the above is not what you want. My guess is
that you want to see the Task % Complete field (which relates to task
Duration) listed next to each assignment row in the report.
Unfortunately, the only way to get that format is use the Resource Usage
view (instead of the built-in Report) and copy the % Complete field from
each task into a spare assignment text field so it will appear on the
Resource Usage view. This can either be done manually or via a simple
VBA macro to copy the data. You might want to check out FAQ 37 - Custom
fields in tables, on our MVP website at:
http://www.mvps.org/project/faqs.htm

Hope this helps.
John
Project MVP

 

[MSProjectUser]

Thanks John! That was helpful.

MSProjectUser,
The basic answer to your question is, "yes". However, that is not a
simple "yes". First of all, the Units and Work fields are associated
with the assignment information, not the resource information. Those two
fields can be eliminated by simply unchecking the "schedule" option from
the Assignment options under the "Details" tab. The "Who does what"
report is a resource based report and the only "% complete" field for
resources is the % Work Complete field. This field can be added to the
default Usage resource table under View/Table/More Tables.

However, my guess is that the above is not what you want. My guess is
that you want to see the Task % Complete field (which relates to task
Duration) listed next to each assignment row in the report.
Unfortunately, the only way to get that format is use the Resource Usage
view (instead of the built-in Report) and copy the % Complete field from
each task into a spare assignment text field so it will appear on the
Resource Usage view. This can either be done manually or via a simple
VBA macro to copy the data. You might want to check out FAQ 37 - Custom
fields in tables, on our MVP website at:
http://www.mvps.org/project/faqs.htm

Hope this helps.
John
Project MVP

 

[Mike Glen]

Hi MSProjectUser,

Welcome to this Microsoft Project newsgroup

You might like to have a look at my series on Microsoft Project in the
TechTrax ezine, particularly #24 - Customizing Reports, at this site:
http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you'd care to rate the article before leaving the site,
Thanks.)

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP

 

[John]

Thanks John! That was helpful.

MSProjectUser,
You're welcome.

John