Project Complete Percentage View

[Pete Zerger (MVP)]

I am trying to author a SQL Reporting Services report that incorporates some
of the summary data viewable in the Project Center web view.
In particular, I would like to retrieve the '% Complete' for the entire project,
but cannot find it in any of the summary tables, such as MSP_Project.

Can anyone point me to a relatively straightforward method to extract this
info? The Project Server SDK has not helped me in this regard.

Regards,

Pete Zerger, MCSE(Messaging) | MCTS(SQL 2005) | MVP - MOM
Founder, SystemCenterForum.org
URL:http://www.systemcenterforum.org
BLOG: http://www.it-jedi.net/
mailtoete.zerger AT gmail.com

 

[Jim Corbin [MSFT]]

Assuming you are using Project Server 2007, the query for the Project Review
Report ( http://msdn2.microsoft.com/en-us/library/bb428826.aspx ) in the SDK
includes MSP_EpmProject_UserView.ProjectPercentCompleted from the Reporting
db.

You can get the complete sample for SSRS 2005 in the Project 2007 SDK
download, and then simplify the report to highlight what you want.

--Jim