The purpose of this document is to provide enough detail to be able to create and deploy reports that support the deployment of a Microsoft Enterprise Project Management (EPM) Solution. Microsoft EPM Solution relies on Microsoft SharePoint Server 2010, Microsoft SQL Server 2008 or 2008 R2, Microsoft Project Server 2010, and Microsoft Project Professional 2010. Although each individual component of the solution is well documented on TechNet and MSDN (for Business Intelligence), little documentation exists, as of today, that describes a step-by-step approach to building reports specific to Project Server 2010 data with Excel and Excel Services. For related information, see the Business Intelligence Resource Center for Project Server 2010.
Microsoft Project Server 2010 Reporting with Excel Services