Creating Timescaled Resource Data Reports

I have a client with a Microsoft Project schedule that has multiple projects in one schedule:

1. Projects and Areas identified using Outlining
2. Multiple resources assigned against activities
3. Project, Areas, Clients and Funding Sources identified in Text Columns, thus Projects and Areas are available in both outlining and Text columns.

They require reports with:

The Horizontal axis showing Quarters, Months or Weeks (a report for each)
Vertical axis showing
One Text Column (Say Client)
Second Text Column (Say Funding Source)
Budget/Actual/To Complete
Resource Quantity and/or Resource Cost

My understanding is after some experimenting that:
1. Analyze Time Scaled data in Excel does not export Resources
2. Exporting to Excel does not support timescaled data and long activities that span multiple periods will not be split over periods
3. This report is not produced by Views without massive amounts of irreverent detail
4. This report is not produced by Reports

Does any one have a technique for simply creating this type of report?

Regards
Paul E Harris