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:
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:
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.
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?
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?
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?
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?
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.
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.