todo list question

[William Bernat]

I've been playing around with "Reports | Assignments | Todo List" and
"Reports | Assignments | Todo List" and I can't seem to get what I want,
which is:

Resource, Day, Task, Time

So, someone can print it out at the start of a week and see what tasks he or
she should work on for how long each day.

Who does what comes close, but still doesn't list tasks by time by person
(resource) by day.

Is such a report available?

Thanks!
-billb

 

[Jim Aksel]

Who Does What When seems to include what you need if you set the top row to
Days.
It gives you a list of resources, by name, and what they should be working
each day.

If you want the reciprocal report (Tasks) then use a Work Load/Task Usage
report. There is a check box to include assignments. Again, make the header
row "days." Now you have a list of Tasks and who is working them on a given
day.

 

[William Bernat]

Thanks Jim, but I had tried "Who does what when." Problem is it prints all
days and can't be limited by date or selected tasks. Even if I tell it to do
tasks by work and then select resource for the person I want, I still get a
*lot* of whitespace and pages.

I'm looking for a simple list like:

Resource, Day, Task, Time

I'm getting the sense that project just doesn't do this. Maybe I'd need to
build a custom report?

-billb

 

[Mike Glen]

Hi Bill,

Welcome to this Microsoft Project newsgroup

You might like to have a look at my series on Microsoft Project in the
TechTrax ezine, particularly #24 on custom reports, at this site:
http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you'd care to rate the article before leaving the site,
Thanks.)

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP

 

[Jim Aksel]

Try this. You can set a filter on the Gantt view to show only the tasks of
interest. How you do that is up to you and the rules you want to apply. Use
the AutoFilter, etc.

Within the WDW report, you can filter by ResourceID (it is a dropdown). So,
you will need to run some resource ID ranges keeping in mind that a range is
1 or more resources by ID number.

The report should honor both your filters. Try it and let me know.

Also, there is the VBA route and you could have it wake up Excel with the
output.

 

[William Bernat]

Thanks Jim, we're small enough that looking at the View | Resource Usage is
pretty convenient.

Thanks!
-billb

 

[William Bernat]

Thanks Mike!
-billb

Hi Bill,

Welcome to this Microsoft Project newsgroup

You might like to have a look at my series on Microsoft Project in the
TechTrax ezine, particularly #24 on custom reports, at this site:
http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you'd care to rate the article before leaving the site,
Thanks.)

FAQs, companion products and other useful Project information can be seen
at this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP

 

[Mike Glen]

You're welcome, Bill

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials