This post contains a zip file attachment which is the SQL Server Reporting Services(SSRS) 2005 report pack for Project Server 2007.
This attachment contains 9 items total:
- One overview document describing the setup for each report as well as any new custom fields/lookup tables that are required to make these reports function.
- Seven PDFs which are sample output for each report
- One zip file of the Visual Studio project with report source code.
This VS project file can be used within the SSRS Business Intelligence Development Studio to deploy and modify these reports to your own needs.
The Project Server 2007 Report Pack provides usable reports for some common requests and illustrates some of the new functionality in Microsoft Office Project Server 2007. The Report Pack also provides report developers with sample queries for correctly retrieving data from the Project Server Reporting database.
The Report Pack includes the following seven reports:
- Cost Center Availability
- Project Give and Get
- Project Portfolio Trend
- Project Proposals Listing
- Project Review
- Timesheet Audit
- Work versus Effort Audit
All of these reports use a shared data source, which makes it easy to direct these reports to your own instance of Project Server. I hope you find these reports useful. If you have questions, please post as a comment to this post.