How do I generate a table view of tasks w dependencies on one row?

[JoshuaP]

In Excel, we list out the delivered functions and then have a column for the
tasks on which that function depends in order to provide a quick snapshot
into the status of different functions, e.g., requirements, design,
development, unit testing and deployment.

However, we have moved to project pro 2007 and project server. Using this
tool, how can I show a grouping by function and the tasks supporting it?

For example:
Req'ts Due | Design Due | Dev Due | Deploy On
Edit ticket: 1/18 1/25 2/1 2/7
Next function ... ... ... ...

Thank you for your time and expertise,

 

[Jack Dahlgren]

Create custom date fields for each of the specific dates you need (Req'ts,
Design ...)
Customize the field so that it uses a formula which will set the value of
the field

for example if it was the "Design" field you could use something like:

iif([Name]="Design",[Finish],"")
then for that custom field set the summary task to roll-up the max from the
subtasks.

There is some polish you can put on it from here, but those are the basics.

-Jack Dahlgren