Partilhar via

New SQL Reporting Services Sample Reports for Project Server

  • Artigo

(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

EPM2007 VPC V2- SSRS Reports.zip

Comments

  • Anonymous
    April 10, 2008
    Hello, Christophe just released the reports that ship with the updated EPM 2007 VPC: http://blogs.msdn.com/chrisfie/archive/2008/04/10/new-sql-reporting-services-sample-reports-for-project-server.aspx

  • Anonymous
    April 10, 2008
    hi~ where is "MSPLT_Organization_UserView" table?? Thank you...

  • Anonymous
    April 11, 2008
    In Project Server 2007, custom views are created in the Reporting Database for all custom Lookup Tables. So in this case, we have a LT called Organization in the database.

  • Anonymous
    April 13, 2008
    Following this post ( New SQL Reporting Services Sample Reports for Project Server ), please find below

  • Anonymous
    April 14, 2008
    Hi, the reports look great - what steps would I need to follow to make the available in my customized environment? Guess there are lookup tables etc to create? I wonder if you have a step-by-step install procedure. Thanks in advance

  • Anonymous
    May 07, 2008
    I recently posted a series of SQL Server Reporting Services (SSRS) reports that are used in our newly

  • Anonymous
    June 15, 2008
    The comment has been removed

  • Anonymous
    June 17, 2008
    Are you a Microsoft partner? Would you like to see these reports live ?: New SQL Reporting Services Sample

  • Anonymous
    June 19, 2008
    If you want to run the reports, get the sample databases used to build them here: http://blogs.msdn.com/chrisfie/archive/2008/05/22/project-server-2007-sample-databases.aspx you'll then be able to figure out the custom fields and lookup tables required.

  • Anonymous
    August 27, 2008
    A few weeks ago, I did my 200th post since starting this blog, so following Brian Smith’s initiative

  • Anonymous
    December 08, 2008
    Following the release of this sample SQL Server Reporting Services 2005 report pack: New SQL Reporting

  • Anonymous
    January 05, 2009
    Dear Christophe or any other member, thanks a lot for providing the report pack. Very good work. Like others, I am facing the same problems with the database model/settings. We would like to use the reports with our own reporting database. What do we have to do to get the reports working? Whick lookup tables do we have to create (Which records have to be inserted)? What else has to be changed to the database? Additional tables/columns? Hope you can help us. It would help a lot! Thanks in advance. Best regards, Guido

  • Anonymous
    January 05, 2009
    The easiest is to start reviewing the report pack that's in the SDK.

  • Anonymous
    January 06, 2009
    Hi Christophe, these reports are already working. As your reports fulfill more of our requirements, we would like to use these reports as well. At a first step, do I have to create a lookup table called "Organization" in PWA? If yes, which fields and records do I need? Do you have SQL update/create scripts for the modification of the "original" reporting database? Best regards, Guido

  • Anonymous
    January 06, 2009
    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

  • Anonymous
    January 06, 2009
    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

  • Anonymous
    January 06, 2009
    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

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

  • Anonymous
    December 01, 2009
    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