Custom Task Usage Report

[Hilary S.]

Hi,

I would really like to create a custom Task Usage report that has all the
regular stuff plus a couple of text fields (static) that I have entered
myself. I have been reading other posts and usually the first suggestion is
to create a customized table with all necessary fields and then base the
report on that column. Maybe I'm missing something, but I cannot seem to
find where it asks you to specify a table when I create a new Task Usage
report. For a simple task report, it is located in the "Definition" tab...a
Task Usage report asks for Name, Crosstab, and Filter only -- no table. Can
anyone help??

Thanks so much,

Hilary

 

[John]

Hi,

I would really like to create a custom Task Usage report that has all the
regular stuff plus a couple of text fields (static) that I have entered
myself. I have been reading other posts and usually the first suggestion is
to create a customized table with all necessary fields and then base the
report on that column. Maybe I'm missing something, but I cannot seem to
find where it asks you to specify a table when I create a new Task Usage
report. For a simple task report, it is located in the "Definition" tab...a
Task Usage report asks for Name, Crosstab, and Filter only -- no table. Can
anyone help??

Thanks so much,

Hilary

Hilary,
With many of the built-in and customized Reports in Project, the data
making up the report can include user definable fields. However that is
not the case with the Task Usage Report. On the other hand, the Task
Usage view CAN be customized to show the information you want, but be
careful. If the text fields you are using were populated in a Task view
(e.g. Gantt Chart), the information is in Task Text fields, not resource
or assignment text fields - they are all separate independent fields.

You did mention that you want to customize the Task Usage data for
output. As long as you don't expect your custom text information to
appear on assignment rows (it WILL appear on task rows), here is what I
suggest. Forget about trying to use the Reports feature. Instead, set up
the Task Usage view the way you want it and then print it for your
report. Another nice feature about views is that they can be saved -
reports cannot.

Hope this helps.
John
Project MVP

 

[Hilary S.]

I just realized that I never said thank you for this advice....thank you!

The Task Usage view is working just fine.

Hilary