Searching for Predecessors

[Sannas]

Hello Everyone!

I have my schedule divided into two specific sections both of which are
quite large. One section (upper level) from ID 1 to 5000 and the 2nd section
(lower level) from ID 5001 to 8320 (as an example). There are tasks that
link the lower level to the upper level and I want to find out what these
links are.

I autofilter or create a filter and it just doesn't seem to work...all the
time. For instance. Task 6000 has predecessors of 5250, 5575, 500, and 21.
My filter is only reading the first predecessor. It doesn't read anything
else so it does not select this task as having a pred in the upper level.

Can anyone tell me how I can create a filter that not only reads the first
pred but all the rest of them?

Thanks!!

Sandra

 

[John]

Hello Everyone!

I have my schedule divided into two specific sections both of which are
quite large. One section (upper level) from ID 1 to 5000 and the 2nd section
(lower level) from ID 5001 to 8320 (as an example). There are tasks that
link the lower level to the upper level and I want to find out what these
links are.

I autofilter or create a filter and it just doesn't seem to work...all the
time. For instance. Task 6000 has predecessors of 5250, 5575, 500, and 21.
My filter is only reading the first predecessor. It doesn't read anything
else so it does not select this task as having a pred in the upper level.

Can anyone tell me how I can create a filter that not only reads the first
pred but all the rest of them?

Thanks!!

Sandra

Sandra,
Unless you use a flag field, (or something similar), to tag each
predecessor, a filter won't get you there. I guess you could create a
filter that only displays tasks with the IDs of the predecessors but
that won't be very convenient.

Have you tried using the Relationship Diagram? If you select the task of
interest, that diagram will show all predecessors and successors of the
selected task.

Or, you could track down the predecessors using VBA. Fellow MVP, Jack
Dahlgren has a macro called "Trace" on his website
(http://masamiki.com/project/macros.htm)

John
Project MVP

 

[JulieS]

Hello Sandra,

I don't believe that it is possible in Project to create a filter that
you describe. However, fellow MVP, Jack Dahlgren has posted a macro
that you may place in a project file to trace through the successors or
predecessors to tasks. You may find Jack's macro page at:

http://masamiki.com/project/macros.htm

Look for his macro "Trace"

You may also have luck working with the Relationship diagram showing as
the lower part of a split from the Gantt chart. From the Gantt chart
choose Window > Split to display the task form at the bottom. Click in
the bottom pane and choose View > More Views, Relationship diagram.
That should show graphically all of the direct predecessors and
successor to the selected task.

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

 

[Sannas]

Hello Julie and John!

A BIG thanks to you two for answering!

The Trace Macro or the relationship diagram won't work in this case. I'd
have to run it on every line of a 4000 line item "bottom level" schedule to
see the links to the top of the schedule. I'd may as well just look at the
pred column.

HOWEVER, you did give me a clue! I use a Network Diagram software called
Graneda Dynamic in which I can zone the upper level and lower level so they
are grouped separately and then just look for the logic lines between the
two. Not as clean as I'd like but the easiest way for now.

Thanks!!!

Sandy

 

[John]

Hello Julie and John!

A BIG thanks to you two for answering!

The Trace Macro or the relationship diagram won't work in this case. I'd
have to run it on every line of a 4000 line item "bottom level" schedule to
see the links to the top of the schedule. I'd may as well just look at the
pred column.

HOWEVER, you did give me a clue! I use a Network Diagram software called
Graneda Dynamic in which I can zone the upper level and lower level so they
are grouped separately and then just look for the logic lines between the
two. Not as clean as I'd like but the easiest way for now.

Thanks!!!

Sandy

Sandy,
You're welcome. It's been years since I used Graneda but it does have
much more flexibility with network diagrams than Project.

John
Project MVP