I am having a bit of an issue getting the kind of report that I want from MS Project 2010. To get some background on my project, I am creating a master scheduled using multiple templates. The templates are in their own project files, so they are subprojects of the master project. What I want to create is a report that shows which subprojects a resource in involved in. Basically I want to be able to give employees their schedule for a year. Is there a way to get such a report?
This you can easily achieve using MS Excel, as Excel provides a good compatibility with Microsoft Project, so you can copy/paste all contents from Excel to MPP and vice versa.
Follow these steps:-
Add an extra column to all your sub-projects MPP and write the Project Name in that column, it should be same within that project and also unique for each sub-project MPP
Copy/paste all your sub-projects to an Excel sheet, place them one beneath the other (i.e. adding more rows), such that same columns are aligned. So while 'Resource' column of Sub-project A, should continue with the same column of Sub-project B
Once all sub-projects are merged into a spreadsheet, apply a Pivot table to get which resource is allocated to which all projects over the specified period of time.
Are you using a resource pool? If so, open the resource pool, add the Project column to show Resources, their assignments and which projects the assignments come from.
I would use the Project field in the Resource Usage view with a group on Name (resource field) and then Project (assignment field). Collapse the group to second level and there's your report.