MS Project Report - Next Step

G

Greggy

(posting again in case it's buried too far down the list for people to
notice)

Hi Again ... is there a way to take this report further?

Right now this report creates a long list of incomplete tasks (see below to
refresh your memory) ... is there any way to have the report sort the tasks
by the headings above them. People are saying, it's great to see all the
incomplete tasks, but, we need the greater headings above those tasks so we
can quickly associate the task with where it sits in the timeline.
Hopefully I have explained this properly.

Thanks,
Greg


John said:
Greggy said:
I'm trying to create a report that will show anything not completed that
has
a completion date in the past or within the next week.

Can someone point me in the right direction for how to create a report
like
this in MS Project 2003 Standard.

Thanks much,
Greg

Greg,
OK, that shouldn't be too hard. You didn't mention what information you
want in the "report" but let's assume a standard Gantt Chart has what
you need. I will also assume you don't need to see Summary Lines (i.e.
you are only interested in performance tasks that are incomplete or
won't finish in the next week).

One method is to set up a simple interactive filter as follows:
And/Or Field Name Test Value
% Complete is less than 100%
And Summary equals No
And Finish is less than "Enter date that is one week
from today"?

If you don't want to enter the date each time, you can create a custom
field with a calculated date and then use that in the filter in place of
the interactive question. For example, put the following formula in
spare Date1 and change the "Enter date..." to [Date1].
Date1 = [Current Date]+7

Hope this helps.
John
Project MVP
 
J

John

Greggy said:
(posting again in case it's buried too far down the list for people to
notice)

Hi Again ... is there a way to take this report further?

Right now this report creates a long list of incomplete tasks (see below to
refresh your memory) ... is there any way to have the report sort the tasks
by the headings above them. People are saying, it's great to see all the
incomplete tasks, but, we need the greater headings above those tasks so we
can quickly associate the task with where it sits in the timeline.
Hopefully I have explained this properly.

Thanks,
Greg


Greg,
You didn't need to post again. I answered your latest question in the
same thread as the original - check there.

Generally the only reason someone might want to re-post a question is if
the original post and its threads are more than 4 or 5 days old (that's
working days). That seems to be representative of the volume, at least
as it appears in my newsreader (I have it set for 200 messages).

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