Display subsummary data horizontally

[illbe]

Please bear in mind that this may be a stupid question but I'm going to ask anyway. I have a series of invoices that I currently have displayed based on due date, then by invoice number, finally the items per invoice as below, the invoice date and Invoice number are in one table, the line items are in another related table.

01/01/2009 (this is in a subsummary part)

Invoice #12345 (this is in a second subsummary part)

Item1 (these are in the body)

Item2

Item3

01/05/2009

Invoice #12345

Item1

Item2

Item3

I would like to display these horizontally across the screen instead of vertically, could I please get some help in how to do this before my head explodes -), I'm certain it is something silly I have overlooked. I used to be able to do this in Access as a cross-tab query but filemaker has me baffled.

Thanks

in advance

Tom

[bcooney]

you cannot do a horizontal report easily (if at all) in FM.