Hi folks - I am having trouble getting a multi column report.

I have a three tier invoice report that groups by customer then delivery number and then by item. The invoice groups together deliveries that have been made during the month. I am trying for this sort of layout...

Customer Name
Address etc


Invoice No.

ITEM QUAN PRICE VAL ITEM QUAN PRICE VAL ITEM QUAN PRICE VAL

Del001 Del002 Del003

Item1 56 6.74 164.66 Item1 12 6.74 120.00 Item1 76 6.74 80.00
Item2 74 1.23 120.54 Item2 38 1.23 138.00
Item3 21 2.47 56.77
Del004 Del005
Item1 12 6.74 38.82 Item1 51 4.54 200.00
Item2 42 1.23 42.00 Item2 21 1.00 21.00
Item3 42 2.47 84.00


Totals - sum of quantities - (price fixed for each item) and sum of value

Item1 1027 6.74 1222.00
Item2 899 1.23 3372.28
Item3 9388 2.47 7482.23

I have got the first bit OK but Del004 starts on a new page although I have not set it to do that...

I am also struggling to get the Totals at the bottom...

Any ideas will be greatly appreciated...

As posting changes the format slightly I am willing to email the layout through if anyone thinks that will help - but I think you can get an idea of what I am after...