Multi-layer report

[D Space]

I apologize if this has been answered before but...

I want to create a report based on:

Managers Table:

Mgr #

Cost Center

Hours Worked Table:

Employee

Cost Center

Hours

The report should look like:

Manager

Cost Center managed

Employee charging time to that CC

2nd Emp charging time

...

2nd Cost Center managed

Employee charging time

...

Next Manager

...

I'm sure I'm missing something obvious, but I don't see how to do this short of creating a new table via a script and then reporting from that.

Any help would be appreciated. Thanks.