Recently I needed to incorporate some status report data from Project Server 2010 into a custom report. No problem, I though, I just need to find the schema for the related tables. After a lot of searching online, I came up empty. So, after a little digging, here’s a picture of the schema I was able to reverse engineer. Note that the tables are in Project Server’s Published database, not in its Reporting database, so use caution when querying the data.
Thanks for the scheme (which you can basically generate yourself using the Query Editor in the SQL Management Studio ;)).
I posted a SQL-Query on my blog which describes how you can retrieve Status Report Responses into an Excel Pivot-Table – much easier and more intuitive than what the standard features offer.
Check it out here: http://raduner.ch/blog/project-server-2010-export-status-report-responses-using-excel