Project Server 2003 Schema Diagram - Not WEB schema

[brockr]

I'm running Project Server 2003 and I would like to design additional
reports through the use of Crystal Reports. Can anyone provide me with
a link to the Project Server 2003 DB Schema diagram? I have looked
through the diagram of the web tables and it is not what I am looking
for.

 

[Gary L. Chefetz [MVP]]

Brock:

Navigate to the help folder on your Project Server installation. Grab the
files prjdb.htm and pjsvrdb.htm. These are likely what you're looking for.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[Rod Gill]

Try using the pjsvrdb.htm file to see the fields in the MSP_VIEW tables.
These are the ones designed for reporting. Note that Project Server 2007 has
a completely different reporting db so what you do for 2003 won't transfer
to 2007.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx