Wednesday, March 07, 2012 3:06 AM
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
Wednesday, March 07, 2012 5:22 AMHey 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_EpmProject2. 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
- Marked As Answer by ArunRaj_2010 Sunday, March 25, 2012 8:23 AM
Wednesday, March 07, 2012 8:41 AM
Following Amit's sound advice, for an off the shelf solution look at IPMO DataMiner: