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
  • 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

  • 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.

  • 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?

  • 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

  • I have had many questions with regards to the Deliverables feature and reporting. If your not familiar

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

  • 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

  • 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?

  • 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

  • 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

  • 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?

  • 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?

  • 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

  • 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.

  • 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

Page 1 of 2 (21 items) 12