3

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?

1
  • 1
    Projects are dynamic: resource assignments may change, employees may leave, or schedule may slip or just change. So, you would probably consider renewing this reporting maybe each month to your employees. Jul 21 '15 at 20:34
2

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:-

  1. 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

  2. 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

  3. 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.

1
  • This is a semi-workable solution. Thank you.
    – Seth39195
    Jul 22 '15 at 18:16
0

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.

5
  • I have too many tasks for this to be a workable solution.
    – Seth39195
    Jul 22 '15 at 18:07
  • Too many tasks for what to be a workable solution? Resource pools? Adding the project column is one step. The Resource Usage view already shows resources and their assignments.
    – JulieS
    Jul 23 '15 at 20:23
  • Yes, but each resource in my project has hundreds of tasks. I just want to show the top level project files that their task comes from in a short report.
    – Seth39195
    Jul 27 '15 at 11:52
  • 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. But of course, if you don't have a Resource Pool - you're out of luck.
    – JulieS
    Jul 28 '15 at 13:09
  • I do have a resource pool, this sounds like a good view to get what I want. Thank you.
    – Seth39195
    Jul 28 '15 at 13:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.