Jaa

SQL Server Reporting Services Report Pack for Project Server 2007

  • Artikkeli

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.

 

Technorati tags: Project Management, Project Server 2007, Reporting, Project 2007, SQL Server Reporting Services

Microsoft Project 2007 SQL Server Reporting Services 2005 Report Pack.zip

Comments

  • Anonymous
    January 30, 2007
    Looks good. I like the idea for storing time phased project status data. It raises a lot of interesting thoughts: Could certain values get programatically copied into a bunch of time-phased enterprise codes, and perhaps use event code to secure these so user editing is not allowed? Pretty powerful possibilities. The reporting database seems to have made created a split in reporting for Project Server. Some reports from 2003 are now much easier: time phased data doesn't need to be decompressed, easier to join to custom codes, &c. but many reports are now much more difficult. Reporting on the task update work flow, for example, looks to be much harder. (I haven't looked to see if any of the timesheet tables include task updates, but I'm assuming they don't.) Custom data sources for SSRS, using the PSI, I suppose. It's very tempting to look straight into the published database to get at some of this. I see the tables there just waiting to be loved... -j

  • Anonymous
    January 31, 2007
    Yes, you could do some really cool stuff with the timephasing of status data.  :-) Also, bear in mind that we will not be documenting the published database as the RDB is to be used for all reporting.

  • Anonymous
    February 08, 2007
    Looks like the Timesheet Audit Report "TotalWork" column is just adding up all hours across all Timesheet reporting periods. Thus, all Total Reported Hours for each period is the same. This seems like a bug in the reporting as it makes the Timesheet Audit Report uninformative. Is this planning on being fixed?

  • Anonymous
    February 08, 2007
    Kelly, I'll take a look at that as it should be grouping by reporting period.  Also, can you send me your email address by clicking the email link in the blog header? Thanks! --Treb

  • Anonymous
    February 24, 2007
    I have had many questions with regards to the Deliverables feature and reporting. If your not familiar

  • Anonymous
    April 01, 2007
    The SQL 2005 SP2 has just been out for a couple of weeks now.. It brings a nice new feature in terms

  • Anonymous
    April 23, 2007
    Hi I would like to know if there is a feature in Project Server 2007 to schedule reports, so the management doesn't have to go to web access for report. The idea is to get email notification of the project progress automatically. Any body has any idea if this can be done on project server 2007

  • Anonymous
    May 24, 2007
    It seems that some formatting from project server is removed in the Report Pack.  Is this a limitation, for example not bolding a particular word or phrase, that we have to accept or am I just missing it?

  • Anonymous
    July 03, 2007
    Sree - Reporting Services will happily schedule a report for you and drop it to a web site or file share and email a notification to the reports subscribers.   Milnerphil - you'll need to add your own annotations, we don't pass project professional task highlighting and font settings through right now - interesting thought though! Thanks....pc

  • Anonymous
    August 01, 2007
    hi We are trying to get reports out of project 2007 basically users are puting in administrative time into timesheets and we want to view a report which shows all this data. Ideally be able to see how must time is being spent on each administrative task. Has anyone any experience of this type of report and if they have what fields do we use to pull in all the data. Thanks Brenden Ward

  • Anonymous
    August 05, 2007
    HI, Looks like the Timesheet Audit Report "TotalWork" column is just adding up all hours across all Timesheet reporting periods. Thus, all Total Reported Hours for each period is the same. This seems like a bug in the reporting as it makes the Timesheet Audit Report uninformative. Is this planning on being fixed?

  • Anonymous
    August 05, 2007
    HI, Looks like the Timesheet Audit Report "TotalWork" column is just adding up all hours across all Timesheet reporting periods. Thus, all Total Reported Hours for each period is the same. This seems like a bug in the reporting as it makes the Timesheet Audit Report uninformative. Is this planning on being fixed?

  • Anonymous
    August 15, 2007
    Hi I would like to know if there is a feature in Project Server 2007 to schedule reports, so the management doesn't have to go to web access for report. The idea is to get email notification of the project progress automatically. Any body has any idea if this can be done on project server 2007

  • Anonymous
    September 26, 2007
    hi i downloaded the zip and tried using it but there is no project file in the zip...is the project file missing cause i can see just .rdl files and a solution file. When i try to open the solution it gives me an error mentioning no project available.

  • Anonymous
    November 05, 2007
    hallo, i have a question maybee some one can help, Can install project server and SQL one same server of should installed on different computers Thanks in advanced

  • Anonymous
    March 10, 2008
    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?

  • Anonymous
    April 10, 2008
    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

  • Anonymous
    April 30, 2008
    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?

  • Anonymous
    October 22, 2009
    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?

  • Anonymous
    March 04, 2010
    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.

  • Anonymous
    March 04, 2010
    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.