Generating resource tasking reports sorted by task start date

[MG Borrego]

How can I generate a comprehensive project report that lists the tasks
assigned to each resource sorted by task start date? The "Who Does What"
report is very close to what we need except that the individual task
assingment table listed under each resource is by default ordered by task id
not start date. I was not able to figure out how to re-sort the assignment
schedule table.

I searched the online help and played with custom reports and table
definitions with no success. Is sorting this table by start date possible or
is there another way to generate this type of report? Help!

Thanks,
Marissa

 

[JulieS]

Hi Marissa,

As you have discovered, the Who Does What report" has some flaws. The
workaround I use is to create a new new table and view using the
Resource Usage Report as the basis and then print the view. The steps
are outlined below:

Display the Resource Usage View.
Copy the Usage table (View>Tables>More Tables, selected the Usage table
and copy.)
Rename the table "Who Does What".
Insert the following columns (fields) to the copy of the Usage table:
Assignment Units, Assignment Delay, Start, and Finish.
Apply the new table to the Resource Usage view.
Create a new view ( View> More Views...select the resource usage view
and choose Copy)
Rename the view "Who Does What"
In the View definition dialog box, confirm that the table showing is the
"Who Does What" table.
Check "Show in Menu"
Apply the new view.
Drag the split bar separating the timescaled portion (right side) from
the
table to the far right. Print the view and it's close to the Who Does
What report.

--
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