"trace logic"

[Terry Chisholm]

I would like to have a formula written to one of the text fields to retrieve
the Activity Name for both the Successors and Predecessors to a specific
activity.

I can no longer print out a pert chart due to the extensive tasks that have
to be created on work orders now; there isn't enough paper, or a wall big
enough to hang it on.

I can print out a Gantt chart showing predecessors and successors, but when
asked if there are conflicts with starting a job I cannot answer without
checking what the status of the predecessor is, and I cannot do that without
a name. (Without a name I would have to search the entire project to find
the id to identify the work and answer the question, and that just won't
happen).

 

[Jim Aksel]

Wouldn't this be easier? On the Gantt chart view, select Window/Spit
On the new window that opens in the bottom pane you can right click in a
vacant area and select "Predecessors and Successors" from the context menu.

The bottom pane will now show the precessors/successors with there task
name, the relationship type and any lag. The bottom pane is married to the
top pane so clicking on a new task in the uppoer pane will change the
information below.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

 

[Jack Dahlgren MVP]

A formula won't work for this. You could write some VBA to display the names
in a text field, but the text fields are character limited and may not hold
all of the predecessor or successor names without getting cut off at 256
characters.

If you are using Project 2007,take a look at the "driving tasks" function.
To do this, go to the view menu and choose "turn on project guide". Then
from the project guide toolbar, under the "track" sub-menu select "see what
is driving the start date of this task".

Select the task you want to see details about and you will see the driving
predecessors in the left. You can then click on them to move futher back.

You could also use my trace macro to filter for all predecessors:
http://zo-d.com/project/macros.htm

-Jack Dahlgren

 

[vanita]

Hi
Since you need a hard copy report, why not create a customised report with
the required information.

I hope it helps.
Vanita