New SQL Reporting Services Sample Reports for Project Server

Christophe Fiessinger's Blog

The latest news you need to know about Microsoft Enterprise Social & Project Portfolio Management

New SQL Reporting Services Sample Reports for Project Server

Rate This
  • Comments 19

(August 20, 2009 update, check out this Second Report Pack for Project Server 2007) 

We have released last week an updated version of our EPM 2007 demo VPC. Please find below the SQL Server Reporting Services (SSRS) reports used in that VPC.

All these SSRS reports are using the Project Server 2007 Reporting database as a data source.

Please note the Earned Value Trend reports will require a custom stored procedure (included in the attachment).

This pack includes the following reports:

Earned Value Trend 196 2008-04-10, 09_56_40 Project List 204 2008-04-10, 10_02_00
Issues   200 2008-04-10, 09_58_42 Risks 199 2008-04-10, 09_58_23
Portfolio Status 197 2008-04-10, 09_57_34 Organization Status 201 2008-04-10, 10_00_01
Project Detail 203 2008-04-10, 10_01_12 Timesheet Compliance 205 2008-04-10, 10_02_52

To deploy the Project List and Project Detail reports check the following post: Fields required to run Project List and Project Detail Reports; for the Timesheet Compliance report check this post:How to deploy the Timesheet Compliance Report

Attachment: EPM2007 VPC V2- SSRS Reports.zip
Leave a Comment
  • Please add 3 and 2 and type the answer here:
  • Post
  • Guido please send me an email via this blog ("Email" tab) to take this discussion offline, and let me know what report are you interested in implementing

  • Guido please send me an email via this blog ("Email" tab) to take this discussion offline, and let me know what report are you interested in implementing

  • I posted this set of sample SQL Server Reporting Services (SSRS) reports almost a year ago: New SQL Reporting

  • Hi Christophe,

    Great to see your excited about what can be achieved with RS2008 :).

    Have you tried reporting from SharePoint site content (ie project workspaces) using i-PMO's Data Miner for SharePoint?

    http://www.projectserver.com.au/Products/iPMODataMiner2009forSharePoint.aspx

    You can produce the same stunning reports, across your entire project portfolio (i.e. across site collections) and include those custom lists you developed in SharePoint. How good is that?

    Adrian

Page 2 of 2 (19 items) 12