Custom reports

[Angel C.]

I'm currently have a master schedule with over 20 projects linked to the
master schedule. I need to generate a report with the following information:

- Summary of hours assigned by resources based on each project and by month.

I tried the Resource Usage report by filtering on All Resources and sorting
by project, but the report only includes the total hours assigned by each
resource across all projects.

 

[John]

I'm currently have a master schedule with over 20 projects linked to the
master schedule. I need to generate a report with the following information:

- Summary of hours assigned by resources based on each project and by month.

I tried the Resource Usage report by filtering on All Resources and sorting
by project, but the report only includes the total hours assigned by each
resource across all projects.

Angel,
The problem with trying to filter or group on the Resource Usage view is
that the project information you want (i.e. Project field) is in the
assignment data and filtering and grouping do not apply to the
assignments.

The only way I can see to get the type of report you want is through VBA
and probably then only by exporting the timescaled data to Excel. I
guess you could try the "Analyze timescale data in Excel" utility/add-in
and then manipulate the data in Excel to get the totals you want but in
my opinion, a custom macro is more flexible and will get you exactly
what you need.

There might be another option but I'm not sure if it will give you what
you want. One of the MVPs (Rod Gill) has a macro that reports across
multiple projects. To try out his macro, go to the MVP website at:
http://project.mvps.org/vbacode.htm
and click on the link to "Multiple Project Reports".

Hope this helps.
John
Project MVP