Project ID display for external tasks

[dm0502]

I have a custom report based on the Top-level Task report, which displays all
tasks, with predecessor and successor task descriptions.

This report is being used on a Master Project that has 3 inserted projects,
with links between the 3 projects. Is there a way for the task description,
predecessors and successors to show the Project ID that the task belongs to?

For example:

Project A has a Task 1 as does Project B and Project C. Project A task 1 is
linked to Project C task 4. The report displays:

Task 1
Predecessor: Task 4

Task 1

Task 1
Task 4
Successor: Task 1

Is there a way to display on the report:

Project A:Task 1
Predecessor: Project C:Task 4

Project B:Task 1

Project C:Task 1
Project C:Task 4
Successor: Project A:Task 1

This is what is displayed on the task info predecessors tab, but not on the
report. I’m not sure if there is an option for this.

TIA

 

[John]

I have a custom report based on the Top-level Task report, which displays all
tasks, with predecessor and successor task descriptions.

This report is being used on a Master Project that has 3 inserted projects,
with links between the 3 projects. Is there a way for the task description,
predecessors and successors to show the Project ID that the task belongs to?

For example:

Project A has a Task 1 as does Project B and Project C. Project A task 1 is
linked to Project C task 4. The report displays:

Task 1
Predecessor: Task 4

Task 1

Task 1
Task 4
Successor: Task 1

Is there a way to display on the report:

Project A:Task 1
Predecessor: Project C:Task 4

Project B:Task 1

Project C:Task 1
Project C:Task 4
Successor: Project A:Task 1

This is what is displayed on the task info predecessors tab, but not on the
report. I’m not sure if there is an option for this.

TIA

dm0502,
There is not a specific option to display this but you can create a view
table to do it. There are two approaches. The first is to simply add the
project identifier to all task names in the subprojects. However you may
not want to do this. The second approach is to designate 3 spare text
fields to replicate the Task Name, Predecessor and Successor fields
except prefix the text with the appropriate project identifier. For the
emulated task name field you can use a simple formula (in each
subproject) that prefixes the Project field to the existing Task Name
field. For example, assume you are using Text1 to emulate the Task Name
field. The formula would be,
Text1=[project] & [name]

A similar thing could be done for predecessors and successors except you
will have to parse out the path to find just the project name to use as
the prefix. A little more complex, but none the less doable.

Then of course you will need to modify the view table for the report to
show the customized fields instead of the normal fields.

Hope this helps.
John
Project MVP

 

[dm0502]

Thanks, John.

For my purposes, I may just stick with what it is doing now. I was hoping
there was a quick setting I was missing, but it sounds as if I'd need
considerable time to get this set up. But if I need to distribute this
report to others, I will probably have to use your suggestions.

DMM

I have a custom report based on the Top-level Task report, which displays all
tasks, with predecessor and successor task descriptions.

This report is being used on a Master Project that has 3 inserted projects,
with links between the 3 projects. Is there a way for the task description,
predecessors and successors to show the Project ID that the task belongs to?

For example:

Project A has a Task 1 as does Project B and Project C. Project A task 1 is
linked to Project C task 4. The report displays:

Task 1
Predecessor: Task 4

Task 1

Task 1
Task 4
Successor: Task 1

Is there a way to display on the report:

Project A:Task 1
Predecessor: Project C:Task 4

Project B:Task 1

Project C:Task 1
Project C:Task 4
Successor: Project A:Task 1

This is what is displayed on the task info predecessors tab, but not on the
report. I’m not sure if there is an option for this.

TIA

dm0502,
There is not a specific option to display this but you can create a view
table to do it. There are two approaches. The first is to simply add the
project identifier to all task names in the subprojects. However you may
not want to do this. The second approach is to designate 3 spare text
fields to replicate the Task Name, Predecessor and Successor fields
except prefix the text with the appropriate project identifier. For the
emulated task name field you can use a simple formula (in each
subproject) that prefixes the Project field to the existing Task Name
field. For example, assume you are using Text1 to emulate the Task Name
field. The formula would be,
Text1=[project] & [name]

A similar thing could be done for predecessors and successors except you
will have to parse out the path to find just the project name to use as
the prefix. A little more complex, but none the less doable.

Then of course you will need to modify the view table for the report to
show the customized fields instead of the normal fields.

Hope this helps.
John
Project MVP

 

[John]

Thanks, John.

For my purposes, I may just stick with what it is doing now. I was hoping
there was a quick setting I was missing, but it sounds as if I'd need
considerable time to get this set up. But if I need to distribute this
report to others, I will probably have to use your suggestions.

DMM

DMM,
You're welcome. If you have further questions, please post again.

John
Project MVP

I have a custom report based on the Top-level Task report, which displays
all
tasks, with predecessor and successor task descriptions.

This report is being used on a Master Project that has 3 inserted
projects,
with links between the 3 projects. Is there a way for the task
description,
predecessors and successors to show the Project ID that the task belongs
to?

For example:

Project A has a Task 1 as does Project B and Project C. Project A task 1
is
linked to Project C task 4. The report displays:

Task 1
Predecessor: Task 4

Task 1

Task 1
Task 4
Successor: Task 1

Is there a way to display on the report:

Project A:Task 1
Predecessor: Project C:Task 4

Project B:Task 1

Project C:Task 1
Project C:Task 4
Successor: Project A:Task 1

This is what is displayed on the task info predecessors tab, but not on
the
report. I’m not sure if there is an option for this.

TIA

dm0502,
There is not a specific option to display this but you can create a view
table to do it. There are two approaches. The first is to simply add the
project identifier to all task names in the subprojects. However you may
not want to do this. The second approach is to designate 3 spare text
fields to replicate the Task Name, Predecessor and Successor fields
except prefix the text with the appropriate project identifier. For the
emulated task name field you can use a simple formula (in each
subproject) that prefixes the Project field to the existing Task Name
field. For example, assume you are using Text1 to emulate the Task Name
field. The formula would be,
Text1=[project] & [name]

A similar thing could be done for predecessors and successors except you
will have to parse out the path to find just the project name to use as
the prefix. A little more complex, but none the less doable.

Then of course you will need to modify the view table for the report to
show the customized fields instead of the normal fields.

Hope this helps.
John
Project MVP