Show parent tasks in reports...

[ces4848]

Hi,

MS Project newbie...

When selecting [Reports -> Assignments -> To-Do List] I would like to
display all parent tasks under task name and separate them by slashes or
something.

For example:
My root task / Task group / Sub task group / Task Name

Can someone help me out with this?

CES

 

[JulieS]

Hi CES,

Jack Dahlgren (MVP) has made available a macro on his website which
creates a string of summary task names and writes it to the Text12
field. See his macro "SummaryName" at:
http://masamiki.com/project/macros.htm

The formatting won't be exactly as you need -- it will show the
parent name on the same row. You might try exporting to Excel to
format as you'd like or adding the Text12 field to a table, filter
by resource and then print.

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

 

[ces4848]

Hi Julie,

Thanks for the reply!

I had actually found that script and created a new module with hat in it but
that was as far as I got. Can you help me understand how to implement it?

Also, should you be able to runt the script from the VBA editor because I
get an error when I try to run it.

CES

Hi CES,

Jack Dahlgren (MVP) has made available a macro on his website which
creates a string of summary task names and writes it to the Text12
field. See his macro "SummaryName" at:
http://masamiki.com/project/macros.htm

The formatting won't be exactly as you need -- it will show the
parent name on the same row. You might try exporting to Excel to
format as you'd like or adding the Text12 field to a table, filter
by resource and then print.

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

Hi,

MS Project newbie...

When selecting [Reports -> Assignments -> To-Do List] I would like
to
display all parent tasks under task name and separate them by
slashes or
something.

For example:
My root task / Task group / Sub task group / Task Name

Can someone help me out with this?

CES

 

[JulieS]

Hi CES,

Once you have displayed the VBE (Visual Basic Editor) select the
current project file in the Project explorer and insert a module.
(Insert > Module). Copy and paste all of Jack's macro into the
module. Save and return to Project, closing the VBE.

Display a task view and add the Text12 field to the view. (Insert >
Column). You should then be able to run the code through Tools >
Macro > Macros. You should see the macro in the list. Select it
and click the run button.

I tested the macro in Project 2007 and all ran fine here. What
version of Project including service pack are you using?

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

Hi Julie,

Thanks for the reply!

I had actually found that script and created a new module with hat
in it but
that was as far as I got. Can you help me understand how to
implement it?

Also, should you be able to runt the script from the VBA editor
because I
get an error when I try to run it.

CES

Hi CES,

Jack Dahlgren (MVP) has made available a macro on his website
which
creates a string of summary task names and writes it to the
Text12
field. See his macro "SummaryName" at:
http://masamiki.com/project/macros.htm

The formatting won't be exactly as you need -- it will show the
parent name on the same row. You might try exporting to Excel to
format as you'd like or adding the Text12 field to a table,
filter
by resource and then print.

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

Hi,

MS Project newbie...

When selecting [Reports -> Assignments -> To-Do List] I would
like
to
display all parent tasks under task name and separate them by
slashes or
something.

For example:
My root task / Task group / Sub task group / Task Name

Can someone help me out with this?

CES

 

[ces4848]

Thanks Julie, I got it figured out. The error I was getting was caused from
the Text1 field was set as a lookup which is the default. Simple mistake for
someone unfamiliar with Project.

Hi CES,

Once you have displayed the VBE (Visual Basic Editor) select the
current project file in the Project explorer and insert a module.
(Insert > Module). Copy and paste all of Jack's macro into the
module. Save and return to Project, closing the VBE.

Display a task view and add the Text12 field to the view. (Insert >
Column). You should then be able to run the code through Tools >
Macro > Macros. You should see the macro in the list. Select it
and click the run button.

I tested the macro in Project 2007 and all ran fine here. What
version of Project including service pack are you using?

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

Hi Julie,

Thanks for the reply!

I had actually found that script and created a new module with hat
in it but
that was as far as I got. Can you help me understand how to
implement it?

Also, should you be able to runt the script from the VBA editor
because I
get an error when I try to run it.

CES

Hi CES,

Jack Dahlgren (MVP) has made available a macro on his website
which
creates a string of summary task names and writes it to the
Text12
field. See his macro "SummaryName" at:
http://masamiki.com/project/macros.htm

The formatting won't be exactly as you need -- it will show the
parent name on the same row. You might try exporting to Excel to
format as you'd like or adding the Text12 field to a table,
filter
by resource and then print.

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

Hi,

MS Project newbie...

When selecting [Reports -> Assignments -> To-Do List] I would
like
to
display all parent tasks under task name and separate them by
slashes or
something.

For example:
My root task / Task group / Sub task group / Task Name

Can someone help me out with this?

CES

 

[JulieS]

Super CES. I'm glad you were able to get it to work. Good luck and
do drop by again.

Julie

Thanks Julie, I got it figured out. The error I was getting was
caused from
the Text1 field was set as a lookup which is the default. Simple
mistake for
someone unfamiliar with Project.

Hi CES,

Once you have displayed the VBE (Visual Basic Editor) select the
current project file in the Project explorer and insert a module.
(Insert > Module). Copy and paste all of Jack's macro into the
module. Save and return to Project, closing the VBE.

Display a task view and add the Text12 field to the view. (InsertColumn). You should then be able to run the code through Tools >
Macro > Macros. You should see the macro in the list. Select it
and click the run button.

I tested the macro in Project 2007 and all ran fine here. What
version of Project including service pack are you using?

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

Hi Julie,

Thanks for the reply!

I had actually found that script and created a new module with
hat
in it but
that was as far as I got. Can you help me understand how to
implement it?

Also, should you be able to runt the script from the VBA editor
because I
get an error when I try to run it.

CES

:

Hi CES,

Jack Dahlgren (MVP) has made available a macro on his website
which
creates a string of summary task names and writes it to the
Text12
field. See his macro "SummaryName" at:
http://masamiki.com/project/macros.htm

The formatting won't be exactly as you need -- it will show
the
parent name on the same row. You might try exporting to Excel
to
format as you'd like or adding the Text12 field to a table,
filter
by resource and then print.

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

Hi,

MS Project newbie...

When selecting [Reports -> Assignments -> To-Do List] I
would
like
to
display all parent tasks under task name and separate them
by
slashes or
something.

For example:
My root task / Task group / Sub task group / Task Name

Can someone help me out with this?

CES