View Specific Tasks in PWA 2003 from Multiple Project Plans

[SirRonald]

Hi,

We have 100 or so project plans published. Each have several common
milestones. Is it possible to view specific tasks in PWA for thos
projects? I would want the xml export to show the project, then the
3-4 milestones underneath each project.

Thanks!

 

[Andrew Lavinsky]

Best solution I've seen is to use SQL Reporting Services to aggregate this
view. You could create a table with the same milestones along the Y axis,
and the projects along the X axis, then present the status using color coded
cells or something like that.

-A

 

[ron]

Best solution I've seen is to use SQL Reporting Services to aggregate this
view.  You could create a table with the same milestones along the Y axis,
and the projects along the X axis, then present the status using color coded
cells or something like that.

-A






- Show quoted text -

Thanks! - So not having access to the SQL Server, what is the best
way to communicate this to our IS folks? Do I tell them to help me
create a report polling the database for the key fields I'm looking
for? Thanks again for the response.

 

[Andrew Lavinsky]

You'll have to check and make sure your IT folks support SQL Reporting
Services development. Assuming they do, here's how you would go about it:

1) Create a custom identifier for the 4-5 (or more) tasks that are common to
each schedule. I usually use a WBS identifier, so you would have WP1.1,
WP2.2, WP3.3...etc. Assign the identifier as an enterprise field.
2) Go through each of the projects and populate them with the custom field.
Flag the tasks you want to track with the correct work package number.
3) Publish all of those projects.
4) have your IT Department develop a report which would go through the
database, and pull out the tasks with the specific identifiers. The report
would then identify the status of the tasks - how that is defined is up to
you, but probably finish variance is a good start.

And that should be it. It may take a bit, and there's a learning curve on
SQL Reporting Services against Project Server, but it's not impossible.