Re: Milestone list by Brian
Brian
Fri Oct 29 09:27:59 CDT 2004
Silvia,
I had to do this same thing for my boss. What I did was inserted all
projects in to a Master Project file so I had all projects and all tasks in
one place. Then I expanded all outline levels so I had all tasks for all
projects visible (by the way this is all in normal gantt chart view). Then
I auto filtered "Scheduled Work" for equals 0 hrs, and that gave me every
milestone in my projects. I then filtered out all other (non-milestone)
tasks using autofilters. At this point you can sort by anything you want...
I sorted by finish date so I had a nice paredoed out view of all milestones
in order. Hope this helps you, if not... sorry for taking up your time to
no avail.
-Brian Stebbins
"Silvia Garcia" <Silvia Garcia@discussions.microsoft.com> wrote in message
news:3C3DA11D-D2F0-4211-A8F7-2C73D38BDE01@microsoft.com...
> Hi,
> Thank you for the tip, but I can see I need to be more specific.
>
> I want to do a milestone list for ALL projects in the server. As project
> manager, I want an overview of milestones in the different projects.
>
> I have tried the Assignment Views, but I cannot manage to make the
> milestones come up because they are not assigned to any ressource.
>
> "Rod Gill" wrote:
>
> > Hi,
> >
> > Simplest way is to read all tasks the MSP_VIEW_tasks table and filter
for
> > Summary=1. I read this data directly into Excel where you can further
format
> > the data.
> >
> > --
> > For VBA posts, please use the public.project.developer group.
> > For any version of Project use public.project
> > For any version of Project Server use public. project.server
> >
> > Rod Gill
> > Project MVP
> > For Microsoft Project companion projects, best practices and Project VBA
> > development services
> > visit www.project-systems.co.nz/
> > Email rodg AT project-systems DOT co DOT nz
> > "Silvia Garcia" <Silvia Garcia@discussions.microsoft.com> wrote in
message
> > news:7BDBEAA2-23DE-4306-931B-43781C33C5E0@microsoft.com...
> > >I would like to make a list of milestones for all my projects from the
> > > Microsoft Project Server.
> > > Is it possible to do so?
> > > Thank you
> >
> >
> >