How do I show overallocations across all projects in 1 report?

[Robin]

I am using project server 2003 and have approximately 20 projects that I need
to show resource overallocation on. I need this in 1 report/view. Can anyone
help?

 

[John Bridgman]

We wrote a custom Crystal Report which goes through the OLAP cube grouping by
resource and by week, then only shows the details if the total assigned work
per week is >50 hours.

This only works 100% if you use normal projects for tracking vacation time,
which is proving to be a tough conceptual sell. If you adjust availability or
(I think) use administrative projects to manage vacations then your report
needs to compare total effort with availability... which needs much more
complex logic.