PS 2010 Reports for workspace data

Question

Hi All,

we have customized the project workspace template, which has issues, risks, project document list, lessons learned list, action items list etc. we need to create a consolidated report for each item/list from all workspace.  we can generate this report for issues, risks using reporting database or cubes. how can we generate the consolidated report (from all workspaces) for the custom lists(lessons learned list, action items list) and project documents.

Thanks in advance

---

Thanks, Arun

Answer 1

Hey Arun,

I did the similar work for one of my customer. I wanted to pull all the data of all different lists in a report. For Risks/issues & deliverables (all out of box fields), the data is stored in project server reporting database but for the custom lists , data gets stored in Sharepoint content database. Tried using the SSRS using SharePoint integrated mode but it needs a data connection from sharepoint URL , for each project, you have different url so was little difficult. I decided to use Sharepoint feature using the Visual Studio 2010 & wrote the Visual Webpart reports using grid & was able to get the data using SPList of Sharepoint object model.
1. Connected to reporting database & got the project uid & workspace url using the belwo query in Stored proc

select 
ProjectUID,
ProjectWorkspaceInternalHRef 
from MSP_EpmProject

2. on Load got the projectworkspace urls & used SPList/SPweb to open the lists & read the columns data & displayed on grid.

Hope that helps.

---

Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

Answer 2

Hi there,

Following Amit's sound advice, for an off the shelf solution look at IPMO DataMiner:

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

Thanks

Paul

---

Paul Mather | Twitter | http://pwmather.wordpress.com