Who does what Report.

[nde]

Hi,

In the Who does what report, I would like to see the WBS in the detail of
each resources tasks.

I tried to use different tables, but I am not able to get it display.

Any idea?

Thanks.

 

[John Lucero Criswell]

As a suggestion, perhaps you can insert a WBS column into whichever table in
your view.

John

 

[nde]

I tried that but it does not show. it looks like the value is hidden by the
detail of each resources.

Thanks anyway.

 

[JulieS]

Hi nde,

Although the Who Does What Report is based upon the Usage table the
assignment information is coming from the Assignment schedule checkbox on
the Details tab of the report definition, so even if you modify the Usage
table with WBS column it doesn't appear correctly in the report.

I created a quick table that mimics the information from the report and
applied it to the resource usage view. I copied the Usage table
(View>Tables>More Tables, selected the Usage table and copied.) I renamed
the table Usage with WBS. I then inserted the following columns (fields) to
the existing copy of the Usage table: WBS, Assignment Units, Assignment
Delay, Start, and Finish. Then I dragged the split bar separating the
timescaled portion from the table to the far right. Print the view and it's
close to the Who Does What report.

Hope this helps. Let us know how you get along.

Julie

 

[nde]

That's a good idea,

Thanks.

Hi nde,

Although the Who Does What Report is based upon the Usage table the
assignment information is coming from the Assignment schedule checkbox on
the Details tab of the report definition, so even if you modify the Usage
table with WBS column it doesn't appear correctly in the report.

I created a quick table that mimics the information from the report and
applied it to the resource usage view. I copied the Usage table
(View>Tables>More Tables, selected the Usage table and copied.) I renamed
the table Usage with WBS. I then inserted the following columns (fields) to
the existing copy of the Usage table: WBS, Assignment Units, Assignment
Delay, Start, and Finish. Then I dragged the split bar separating the
timescaled portion from the table to the far right. Print the view and it's
close to the Who Does What report.

Hope this helps. Let us know how you get along.

Julie

 

[JulieS]

You're welcome and thanks for the feedback.

Julie

 

[Sonnia]

I want to add the Group column to the Workload Resource Usage Report. How do
I do that?

 

[JulieS]

Hi Sonnia,

Have you tried adding the Group Field to the table in the Resource Usage
view and just printing the view? With a bit of easy formatting in the view,
the print out can look very similar to the Resource Usage Report.

Hope this helps. Let us know how you get along.

Julie

 

[Margaret als]

I am a very new user of Project 2003 and I have another question re this
report. The Who does What report is pretty well what I want BUT I really
want to sort the detail so that each resource person has a list of tasks in
Start Date order. I have tried editing the report but nothing seems to
generate the list in this way.

Would really appreciate some help.

 

[Sonnia]

Yes but I didn't want to keep changing the Resource Usage table to print it
and then back again to see what I want. I guess I can create two different
tables. I just thought that MS would have a way to add that field in the
report. Really a drag that you can't. You can add fields to other reports
but not that one.

 

[JulieS]

Hi Sonnia,

The Resource Usage report is a cross tab report (similar to a Pivot Table in
Excel), so unlike a "straight" task report or resource report it is not
really based upon a table that can be easily edited.

I would go with your suggestion and create a new view, based upon the
Resource Usage view formatted for printing how you would like and then
easily switch between the new view and the standard Resource Usage view.

HTH.

Julie