Take the 2-minute tour ×
Project Management Stack Exchange is a question and answer site for project managers. It's 100% free, no registration required.

I have MS Project 2010 server.

I need to add view or report (whatever fits best), and it may be implemented on client or server (whatever fits best).

I need a crosstab report where Resources will be on one axis, Weeks on another and project list in cells.

Result should look like this:

                | Alice      | Bob  | Jim  |
--------------------------------------------
Dec  3 - Dec  9 | Prj1       | Prj1 |      |
Dec 10 - Dec 16 | Prj1       | Prj2 | Prj2 | 
Dec 17 - Dec 23 | Prj1, Prj2 | Prj2 | Prj2 |
Dec 24 - Dec 30 | Prj2       | Prj2 | Prj3 |

Of course it is acceptable if resources will be vertical, and weeks horizontal.

How should I do this? I tried to setup custom resource assignments view on server but did not succ

Maybe that was discussed already, but I did not find any answer.

share|improve this question
add comment

2 Answers

I'm not aware of a way to generate this report using the built-in reporting features (even with a custom report format). You say that you can run it on the client -- are you able to run VBA? If so, you could generate this using a custom VBA function.

share|improve this answer
add comment

The Resource View will have the Resources listed in a column. The Row headings can be the time span - days, or weeks or months. For each resource, the projects they are working on will be shown.

Wouldn't this, automatically available Resource View, suffice ?

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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