Should I use Cross-tab, or a different approach?

[gillmore]

We publish academic journals and I have an Excel-like table I need to create. I want some customer and address data in the first few columns and then product columns with how much each customer spent on the product. (see attached)

I can create the customer and address portion easily enough...and I can create a cross-tab for the product and sales information. What I can't seem to do is get this all into one giant table that can be exported to Excel.

uses these tables:
customer_address for customer data
order_item for order data
order_class for product data

Any suggestions are very appreciated.

Glen