I am pleased to announced the release of two Microsoft Project Server 2010 reporting solutions on TechNet Gallery: Project Burn and Forecast Report and Project Spend Report. Both solutions can be deployed and tested with the Microsoft Project Server 2010 v2 Demo Virtual Machine. These reporting solutions leverages Microsoft SQL Server 2008 R2 Reporting Services and were created by Emmanuel Fadullon, a Principal Consultant for Microsoft Consulting Services (MCS).
- The User Guide for the Contoso Project Burn and Forecast Report demonstrates how to use the Project Burn and Forecast Report to estimate the projected spend rate (“Average Monthly Burn Rate”) based on the current spend plan, and it also allows you to forecast a spend plan based on a what-if spend rate in a budget-reduction scenario.
- The Contoso Project Spend Report User Guide walks you through using the Project Spend Report particularly the use of a key concept -- a unifying Expense Code, to track Project Total Actual Cost. The Total Actual Cost is then categorized into its component costs by project work alongside sustainment and common services activities maintained in associated projects in lieu of Administrative Time and Timesheet entries in order to facilitate cost categorization by Expense Code.
Please note that these reporting solutions are not supported by Microsoft Premier Support and instead are meant to demonstrated the rich reporting capabilities of Project Server 2010. We recommend working with Project & Portfolio Management (PPM) Partners or MCS to modify these solutions to meet your specific reporting needs.
PS: while on the reporting topic, I also recommend to check Alex Burton’s recent post: SQL Server 2012 & Project Server, Part 2– Business data visualisation with PowerView