Custom report to show tasks to be completed

R

Rich Lytle

I am trying to generate a report that shows, by week, the tasks that are
scheduled to complete during that week, and filter it for a selected date
range. For example, I would like a report that shows the tasks that are
scheduled to compelete between May 16th and June 30th.

I have figured out how to create a report that shows "Completed Tasks" by
week, and can filter it by "Date Range," but then I get prompted to enter
"Show tasks that start or finish after" and then "And before." The report
then shows all tasks that have finished before my selected date. I would
like it to show JUST the tasks that will finish DURING my selected date range.

Is this possible? TIA!
 
J

John

Rich Lytle said:
I am trying to generate a report that shows, by week, the tasks that are
scheduled to complete during that week, and filter it for a selected date
range. For example, I would like a report that shows the tasks that are
scheduled to compelete between May 16th and June 30th.

I have figured out how to create a report that shows "Completed Tasks" by
week, and can filter it by "Date Range," but then I get prompted to enter
"Show tasks that start or finish after" and then "And before." The report
then shows all tasks that have finished before my selected date. I would
like it to show JUST the tasks that will finish DURING my selected date range.

Is this possible? TIA!

Rich,
Yes it is possible and should be relatively easy to do with a filter
similar to the Date Range filter but more specific. I don't have Project
open at the moment so this is from memory, but it should get you close.

And/Or Field Name Test Value
Finish equal to or greater than "Week Start?"?
And Finish equal to or less than "Week End?"?

Hope this helps.
John
Project MVP
 

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