milestone reporting through ODBC connection

[Brian]

What I'd like to be able to do is connect to the SQL server for Project
Server 2003, and generate a simple HTML table report that would show 1) each
individual project in the database, and 2) for each project, list each of the
milestones and whether they've been met. Are there any SQL scripts out there
that show how to get at that information? The mgmt team does not want to use
views inside PWA.

Thanks!! ~ Brian

 

[Rod Gill]

Hi,

I create views in SQL Server then use a SQL Server login that has read only
for views and create my reports in Excel.

Read pjdb.htm and srvdb.htm, both installed in one of Project's folders, for
what information is stored where. If you publish your projects then the
MSP_VIEW tables are very useful.

 

[Brian]

Hi Rod -

Thanks for the info, looks like this will be a great starting point.

Thanks!!

~ Brian