Custom report showing dependencies' % complete, estimated complete date, and actual complete date

[anewton_lists]

I'm working in Project Standard 2003. I have successfully created a
custom report (via the app's custom reports GUI/dialog) that shows
predecessors for a specific group of tasks that I isolate via a table
and a filter.

However, I cannot figure out how to customize the columns that display
for ea predecessor task. When the report gets generated, info about the
predecessors is always spit out into these four columns in this order:

+===========================+
| ID | Predecessor Name | Type | Lag |
+===========================+

What I want would be this:

+==================================================================+
| ID | Predecessor Name | % Complete | Estimated Complete Date |
Actual Complete Date |
+==================================================================+

Anyone have any ideas?

Thanks in advance for the help.

 

[John]

I'm working in Project Standard 2003. I have successfully created a
custom report (via the app's custom reports GUI/dialog) that shows
predecessors for a specific group of tasks that I isolate via a table
and a filter.

However, I cannot figure out how to customize the columns that display
for ea predecessor task. When the report gets generated, info about the
predecessors is always spit out into these four columns in this order:

+===========================+
| ID | Predecessor Name | Type | Lag |
+===========================+

What I want would be this:

+==================================================================+
| ID | Predecessor Name | % Complete | Estimated Complete Date |
Actual Complete Date |
+==================================================================+

Anyone have any ideas?

Thanks in advance for the help.

anewton,
Unfortunately the Reports feature in Project doesn't have a lot of
flexibility. What you are seeing is a specialized set of predecessor
information that is not represented by specific individual fields, other
than via the composite string information in the Predecessor field
itself. Individual parts of the predecessor information (i.e. Name,
type, lag, etc.) are available via VBA however.

There are basically two choices for getting what you want but both
require the use of VBA which is an advanced feature of Project. The
first method would be to use VBA to gather the predecessor information
and dump it into spare task fields for each task of interest. Then your
"report" would be created as a customized view. However, if there is
more than one predecessor for the task, this could get messy. The second
approach will give you exactly what you want but it requires using VBA
to export the data to Excel where it can be formatted exactly as you
want.

Probably not the answer you wanted, but yes, it can be done.

John
Project MVP

 

[anewton_lists]

John, approach #1 sounds like a non-starter. My tasks often have
beaucoup predecessors, so messiness sounds like an issue. I'm
interested in the Project/Excel/VBA approach described in #2. Can you
tell me more about it in a separate reply off-list?

 

[John]

John, approach #1 sounds like a non-starter. My tasks often have
beaucoup predecessors, so messiness sounds like an issue. I'm
interested in the Project/Excel/VBA approach described in #2. Can you
tell me more about it in a separate reply off-list?

anewton,
Sure, just write me direct - I receive a fair amount of "off-list"
queries.

John
Project MVP
mjensenatattheriverdotdotcom
delete obvious redundancies