Project Server and SQL report....

[Vit]

Hi all,

I'm trying to understand the Database of Project server 2007...

Is there any white paper??

For example, what tables in SQL can I tap into to create some custom
reports using 3rd party software????

Any suggestion to increase my knokledge into the SQL sde of Project
Server?

Thanks

Cheers

Vit

 

[Christophe Fiessinger [MSFT]]

Hello,
The best way to start is by reading the SDK:
http://www.microsoft.com/downloads/...F9-7028-4B30-99A2-18CB1EED1ABE&displaylang=en
In 2007 you should only leverage the Reporting database.

 

[.jussi]

I found the reporting database to be very straight-forward and descriptive.
The pre-defined views are excellent. The published and active -databases are
much more cryptic, but for at least 90% of my reporting needs the reporting
database has been sufficient and I'm doing quite extensive custom reporting
through MS Reporting Services.

- Jussi

 

[Sean Hanson]

One main area the Reporting Database does not have available is the Local
Custom fields developed within each project. These can be moved
programmatically to a custom table in the RDB and then use SQL Reporting
Services to create reports.
--
Sean Hanson

http://www.randsmanagement.com
Mass Resource Tool for 2007
Project Server 2007 Archive Tool
2007 ULS Log Reporting
SRS Report Packs