locked
Project Workspace Site: Creating Reports RRS feed

  • Question


  • Hi Guys,

    We have created a project workspace site for one of the projects.

    We are looking on how to generate some reports for that project in the project workspace site. In other words, how do we link & display a report of the MSP tasks available in Project on project workspace site.




    • Edited by GanuInMumbai Wednesday, January 25, 2012 3:15 AM
    Wednesday, January 25, 2012 3:12 AM

Answers

  • Hi GanuInMumbai

    Good question. Unfortunaltely there is no reporting DB as per the Project Server Reporting DB. You will be able to get some information regarding Risks, Issues and Deliverables into the Project Server Report DB, but any customised list cannot be retrieved from this database. There are several options

    - Reporting Services has a SharePoint site call that you can use to get information of one site, but if you want a report accross projects that wont work easily. In order to do that we have a tool called Dataminer. Check out this link:

    https://www.ipmo.com.au/Products/DataMiner2010/Pages/Overview.aspx

    This tool essentially replicates the Proejct Server reporting DB for SharePoint. You can then easily generate reports against your project site content. We developed this tool for exactly this purpose. Most of our customers have your requirements and that's how we solve them. Since this is a product of my company, I want to make sure that you dont think I use this as a sales pitch. Please check out the following blog:

    http://blogs.msdn.com/b/chrisfie/archive/2009/12/19/how-to-report-across-multiple-sharepoint-lists-i-pmo-sharepoint-data-miner-to-the-rescue.aspx

    I hope this helps

     

     


    Marc Soester [MVP] http://marcsoester.blogspot.com
    Wednesday, January 25, 2012 4:41 AM