Multi-Level Pred Report

[Wilson]

Does anyone know of a way to create a multi-level pred report in MSP 2007. I
only need predecessors 2 levels down.

 

[John]

Does anyone know of a way to create a multi-level pred report in MSP 2007. I
only need predecessors 2 levels down.

Wilson,
What type of "report" are you seeking? For example, do you want a
limited network diagram, do you want a filtered Gantt, or what? And what
data do you want to show in this report?

Since you are interested in predecessor link chains, you might want to
go to fellow MVP, Jack Dahlgren's website at,
http://masamiki.com/project/macros.htm, and take a look at his Trace
macro.

John
Project MVP

 

[Wilson]

I guess I should be a bit more specific....

I'm looking for a Gantt type of report (i.e. listing of tasks). I don't
need a network diagram.

I need a report that will detail a tasks predecessors 2 levels deep and
includes tasks details for each tasks (duration, finish date, etc). (***
there can be any number of Dvlp obj. or Configurations that drive into the
milestones) -- For example.

Dvlp Object(s) --> Milestone #1 --> Assembly Test #1
SDD Config(s) --> Milestone #2 --> Assembly Test #1
Misc. Tasks ------------(FF)----- > Assembly Test #1


REPORT:

Task: Execute Assembly Test - Duration - Est. Finish
Preds L1: Misc. Tasks driving FF into Assembly Test
Preds L1: Start Assy Test - Dvlp Objct Complete - Est. Finish
Preds L2: Approve Dvlp Obj 1 - Est. Finish
Preds L2: Approve Dvlp Obj 2 - Est. Finish
Preds L2: Approve Dvlp Obj 3 - Est. Finish
Preds Level 1: Start Assy Test - SDD configurations Complete
Preds L2: Approve SDD 1 - Est. Finish
Preds L2: Approve SDD 2 - Est. Finish

 

[Wilson]

Task: Execute Assembly Test - Duration - Est. Finish
---Preds L1: Misc. Tasks driving FF into Assembly Test
--------Preds L2: Misc. Tasks
---Preds L1: Start Assy Test - Dvlp Objct Complete - Est. Finish
--------Preds L2: Approve Dvlp Obj 1 - Est. Finish
--------Preds L2: Approve Dvlp Obj 2 - Est. Finish
--------Preds L2: Approve Dvlp Obj 3 - Est. Finish
---Preds L1: Start Assy Test - SDD configurations Complete
--------Preds L2: Approve SDD 1 - Est. Finish
--------Preds L2: Approve SDD 2 - Est. Finish

 

[John]

Task: Execute Assembly Test - Duration - Est. Finish
---Preds L1: Misc. Tasks driving FF into Assembly Test
--------Preds L2: Misc. Tasks
---Preds L1: Start Assy Test - Dvlp Objct Complete - Est. Finish
--------Preds L2: Approve Dvlp Obj 1 - Est. Finish
--------Preds L2: Approve Dvlp Obj 2 - Est. Finish
--------Preds L2: Approve Dvlp Obj 3 - Est. Finish
---Preds L1: Start Assy Test - SDD configurations Complete
--------Preds L2: Approve SDD 1 - Est. Finish
--------Preds L2: Approve SDD 2 - Est. Finish

Wilson,
If your project file consists of a single thread network, then you could
configure a filter to display roughly what you describe. However, it is
very rare to have a realistic schedule plan that has a single thread
network and I'm guessing some predecessors to any given task of interest
will in fact be predecessors to more than just that one task. Are you
following?

To get the report structure you describe, you will really need to export
project data to another application (e.g. Excel) and configure and
format the exact report you want there. This could be done with a VBA
macro, similar to Jack Dahlgren's Trace macro that I referenced in my
original response, except that the data would also need to be exported
to Excel for formatting.

Unfortunately there is no way to configure Project directly to display
what you want.

So the bottom line answer is, yes you can get the report you want, but
it will require VBA.

John
Project MVP