Filtered Task View across different projects

[Fran?ois]

I'm trying to solve a problem in a BIG Project Server 2002 environment
(think hundreds of users, thousands of plans).

A requirement is to display tasks flagged with a special flag
(enterprise custom field), across all projects:

Project 1
Task 1 - Start - Finish
Task 4 - Start - Finish
Project 2
Task 2 - Start - Finish
Task 4 - Start - Finish
Task 7 - Start - Finish
....

The objective is to let all team members (and possibly even other
employees) see a "poster" view that sums up the "special" tasks.

Giving everyone Project Pro (and using a filtered view) is not an
option, and creating a Master Plan with all Projects isn't either
(would take ~30 minutes to open, due to the number of plans). I can't
see how to create a view like this in PWA - Portfolio View only goes
down to the Project level (we need tasks) and tasks can only be viewed
inside one project, if I'm not mistaken. And not all tasks are
assigned to someone, which is why we're not using the assignment view.

Our current favorite approach is to periodically run a macro (or SQL
query) in order to extract all flagged task lines from all project
plans, paste them into a special "Poster" plan (*not* a Master Plan)
and save that plan as read-only on a shared drive (=> no need to
access the DB for viewing it).

Any other ideas ? Your creativity & experience is appreciated!
Regards
Frankie

 

[Gary L. Chefetz \(MVP\)]

Frankie:

As you have already learned, the only way to do this through a SQL query.
Where you put the results of that query and how you present it is up to you.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-