Project Reports

A

Angela

How do I get a to-do list by Resource detailing the summary tasks within a
time period?

I've used the reports function to give assignments to-do lists, but they
don't give any info about what the task relates to - is there a way to filter
by summary task?
 
J

John

Angela said:
How do I get a to-do list by Resource detailing the summary tasks within a
time period?

I've used the reports function to give assignments to-do lists, but they
don't give any info about what the task relates to - is there a way to filter
by summary task?

Angela,
By definition the to-do list report shows the TASKS a resource is
working on during a specified period. Normally resources are not
assigned at the Summary line level so Summary Lines will not show up on
the to-do list.

I find that the built-in reports are rather limited and in many cases do
not have a lot of flexibility when it comes to customizing. However I
have a couple of suggestions to get the information you want or at least
something close. First, add more information to the Task description so
it is clear what the task relates to. With a more compete Task Name, the
to-do list should work fine.

A second suggestion is to use the Task Usage view or the Gantt Chart
view and then apply the "Using Resource" filter. This will provide a
complete hierarchy of the file structure for the given resource. The
Gantt Chart will actually provide a graphical to-do presentation for the
filtered resource. Keep in mind though that if multiple resources are
assigned to a task, the Gantt bar will apply to all assigned resources.

A third option will give exactly what you want but it requires the use
of an advanced feature of Project, namely VBA. Through VBA, the Project
data can be exported to Excel where a custom report (e.g. to-do list)
can be generated. a side advantage of this approach is that the report
can be electronically provided to others (e.g. performing resources).

Hope this helps.
John
Project MVP
 
H

Hung

John said:
A third option will give exactly what you want but it requires the use
of an advanced feature of Project, namely VBA. Through VBA, the Project
data can be exported to Excel where a custom report (e.g. to-do list)
can be generated. a side advantage of this approach is that the report
can be electronically provided to others (e.g. performing resources).
John
Do you have any basic code that can help us to export the data to Excel from
project for this customized to-do-list ?

Thanks in advance, John

Hung
 
J

John

Hung said:
John
Do you have any basic code that can help us to export the data to Excel from
project for this customized to-do-list ?

Thanks in advance, John

Hung

Hung,
Well, yes I probably do depending on what you want to export, but you
would have to contact me directly via e-mail to start a dialogue. I
would need to know exactly what you want to do. As an alternate you
could take a look at fellow MVP, Jack Dahlgren's website at:
http://masamiki.com/project/macros.htm
In particular take a look at Jack's macro, "export hierarchy to Excel".
If you have some Project VBA experience, you should be able to modify it
for your needs.

If you want to contact me directly, see below.

John
Project MVP
jensenj6atatcomcastdotdotnet
(remove obvious redundancies)
 
J

John

Hung said:
Thank you John,
I will look at the webpage you adviced first.
Thanks again
Hung

Hung,
You're welcome. Any macro I might have would also have to be modified
for your needs, so Jack's macro is a good place to start.

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top