Reporting includes the status of the predecessor

[dave]

I'm want to build a report for over due tasks. But I wish to include the
status of the predecessor. Not just the immediate predecessor but the one
affecting the current task as defined in an Issue.

Task
Start
Finish
Predecessor 'Affecting' Current Task

Any suggestions?

Dave

 

[JackD]

Some VBA which exports the tasks would probably be the answer. You just need
to figure out what you mean by affecting the current task. If you mean the
latest predecessor, then it is fairly simple to do, but you might have some
other criteria.

I have an example on my website which finds the earliest predecessor to a
task, with a slight modification it could find the latest one instead. Then
export the task, task info and the predecessor name/info to excel.

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

Give it a try. If you are really stuck let me know - and tell me what it is
about the predecessor that would make it special enough to include in the
report.

-Jack