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
