Hi Dennis --
It's possible, but not easily out of the box.
If you've installed multiple instances of Project Server 2007, then the data
from those instances will be stored in separate sets of databases. For
example:
Project Server 2007 instance #1:
-- PS2007Instance01_Archive database
-- PS2007Instance01_Draft database
-- PS2007Instance01_Published database
-- PS2007Instance01_Reporting database
Project Server 2007 instance #2:
-- PS2007Instance02_Archive database
-- PS2007Instance02_Draft database
-- PS2007Instance02_Published database
-- PS2007Instance02_Reporting database
Whoever installed your instances of Project Server 2007 probably used
different naming conventions for the databases, but hopefully you get the
gist of it.
Because the data from these instances will be found in separate databases,
you'll need another tool for extracting the data, combining it, and
displaying it, such as SQL Server Reporting Services, Crystal Reports,
SharePoint Server, or even a custom-built application.
If you'd like more information on how to accomplish this, let us know.
Good luck!
Tony Zink
Senior Consultant
MSProjectExperts
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We write the books on Project Server"
