Microsoft Project 2010
The official blog of the Microsoft Project product team. Learn how to manage your work effectively

SQL Server Reporting Services Report Pack for Project Server 2007

SQL Server Reporting Services Report Pack for Project Server 2007

Rate This
  • Comments 21

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: 

  1. 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. 
  2. Seven PDFs which are sample output for each report
  3. 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:

  1. Cost Center Availability
  2. Project Give and Get
  3. Project Portfolio Trend
  4. Project Proposals Listing
  5. Project Review
  6. Timesheet Audit
  7. 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.

 

Attachment: Microsoft Project 2007 SQL Server Reporting Services 2005 Report Pack.zip
  • Hello,

    I read the instructions on how to configure the database and publish the reports to the SSRS instance, but how do you link these into PWA 2007 so users can use them?

  • Hi,

    The SRS Reports are a great way to get the data out of Project Server and I created quite a few usefull reports, but I'm still struggeling getting out information regarding:

    - Pending MyTasks that should be submitted by the resources. We want to check if all resources have submitted their hours to the PM's

    - A complete Timesheet overview per resource that also puts surrogate Timesheet information behind the corresponding resource (surrogate data seems to disappear in the Reporting database)

    Has anybody some experience with these specific reporting topics?

    Rgds,

    Frank

  • Is there a way to add the Calendar items from the Project Workspace? It's capturing Risks, issues and deliverables but we would also like to capture the calendar items. Thoughts?

  • We are using EPMS for Task Sheet rather than the Time Sheet. I would need to create the report for the project that list the available task name,resource allocated, work completed.

    I am using the  Reporting database and the tables i'm accessing are Msp_epmproject_userview,

    Msp_epmtask,Msp_epmassignment and Msp_epmresource.

    When i update any task details, it is not reflecting in the reporting database.

    Can any one help me out in this?

  • I liked the pack, thanks for providing it.

    Im actually trying to produce an audit to find out when the task was put into the project and who is altering it and the resources etc.

    Do you know of any such was of tracing this data? I can see information such as revision number but can't seem to find any revision tables etc.

    thanks.

  • I liked the pack, thanks for providing it.

    Im actually trying to produce an audit to find out when the task was put into the system and who is altering it and the resources it uses.

    Do you know of any such was of tracing the data within Project? I can see revisions numbers but cannot find any tables that seem to contain any revision data.

Page 2 of 2 (21 items) 12