duzby said:
How can I create a report that looks like this:
- Names of resources down the left, as row headings
- Week number (W1, W2...) across the top as col headings
- At each intersection of row and col, name of project or abbreviation,
or some symbol.
Thanks
duzby,
It looks like your resources are working on different projects each
week. The only way you can create the exact report you want is to export
the data to another application (e.g. Excel). It may be possible to do
the export by using a series of export tables but in my opinion, a VBA
macro is much more efficient.
Depending on the structure of your file, you CAN get a report directly
in Project that comes pretty close to what you want. If I assume you are
working with a master project where each separate project is inserted as
a subproject, you can indirectly get your report by using the Resource
Usage View and adding the Project field as a column. Set up the
timescale to show W1, W2, etc. and display the timescaled Work data.
Whenever there are values of Work under a given week, then that resource
is working those projects. It is not as convenient as the report you
want but then it is a lot easier to create.
Hope this helps.
John
Project MVP
