SQL Server Reporting Services Report Pack for Project Server 2007


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.


 


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

Comments (21)

  1. jfraser says:

    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

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

  3. Kelly Chu says:

    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?

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

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

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

  7. sree says:

    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

  8. milnerphil says:

    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?

  9. PatrickConlan[MS] says:

    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

  10. Brenden Ward says:

    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

  11. MAHENDRA says:

    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?

  12. MAHENDRA ISHWAR RANE says:

    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?

  13. KETAN R PATEL (SURAT) says:

    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

  14. Amit Joshi says:

    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.

  15. najib says:

    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

  16. KarenF says:

    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?

  17. Frank says:

    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

  18. Ron says:

    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?

  19. subha says:

    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?

  20. BigglesUK says:

    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.

  21. BigglesUK says:

    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.