From: Hadi on
Hello Experts,

I have about 300 projects in a master file that follow the same template.
each project have 9 major summary tasks with 3 or 4 subtasks underneath.
what am interested in is the construction summary task. the construction
summary task comes #7 in the template. I need to design a report/filter that
show that all or some (depending on what i want to show) of the leading tasks
to construction are complete. for example, Design is summary task that is a
predessor to construction. i want to show that all construction activities
happening in 2006 have their design activties complete. the same things
apply for Job estimate, material, contract, etc.

any ideas?

thanks
From: John on
In article <ECC3B9D0-7FB0-40AA-8C4A-CCA2AF5FE068(a)microsoft.com>,
Hadi <Hadi(a)discussions.microsoft.com> wrote:

> Hello Experts,
>
> I have about 300 projects in a master file that follow the same template.
> each project have 9 major summary tasks with 3 or 4 subtasks underneath.
> what am interested in is the construction summary task. the construction
> summary task comes #7 in the template. I need to design a report/filter that
> show that all or some (depending on what i want to show) of the leading tasks
> to construction are complete. for example, Design is summary task that is a
> predessor to construction. i want to show that all construction activities
> happening in 2006 have their design activties complete. the same things
> apply for Job estimate, material, contract, etc.
>
> any ideas?
>
> thanks

Hadi,
As you say, it depends on "what you want to show" - that's pretty wide
open. Without further information I might say that the summary lines 1
through 6 all precede construction and are therefore relevant.

Something you might want to consider is setting up a series of spare
fields for the various groups you need to report on. You could use flag
fields, number fields or whatever. Then a simple filter on that field or
grouping on that field should produce the results you need.

John
Project MVP