Report - how to make it more like a table

[fubeca]

My boss wants a statistical report and I only know one way of making - which works - but it's hideous. He wants us to transfer the information into Excel and to make barcharts and such with the information. With the method that I know of making the report, we would have to copy and paste each number in one by one because each comes out on its own line.

Here a sample of what I "made" using a summary Count field on the important information and using subsummary parts when sorted by my desired criteria.

Product 1 <total customers>
Expired Status 1 <Expired Status Summary>
Expired Status 2 <Expired Status Summary>
Expired Status 3 <Expired Status Summary>
Expired Status 4 <Expired Status Summary>

Product 2 <total customers>
Expired Status 1 <Expired Status Summary>
Expired Status 2 <Expired Status Summary>
Expired Status 3 <Expired Status Summary>
Expired Status 4 <Expired Status Summary>

etc.
<grand total>


What I'd love to see is something more table-like.

Product Name Exp Status 1 Exp Status 2 . . . etc
Product 1 <total Exp Status 1 for Product 1> etc.
Product 2 <total Exp Status 1 for Product 2> etc.


Is there any way to get these numbers in a nicer format? The books I have don't really provide enough information about reports.