Please help with Crystal report formula

[RayComp]

Please help: Unique problem

I have a Crystal 8 report to print a packing slip with following Access Database fields:
Currently print on report and is OK for domestic use

items.Qty items.description items.CtnNo

items.Qty items.description items.CtnNo

5 Motherboards #1
3 VGA Cards #1
2 Keyboards #2
3 Modems #2
1 Case (loose item)
1 Screen (loose item)

Packing note should be (required by customs at Botswane border post)

5 Motherboards
3 VGA Cards
All above packed into Carton #1
2 Keyboards
3 Modems
All Above packed into Carton #2
1 Case
1 Screen

In other words no case number next to each item but under neath the items that is packed packed in Carton # 1 the wording as above

Sequence must be all in cartons first sorted by carton number then followed by the loose items

Suppose I should create a formula or formulas of some sort but are at a loss. Tried different ways but no luck


In other words no case number next to each item but under neath the items that is packed packed in Carton # 1 the wording as above

Sequence must be all in cartons first sorted by carton number then followed by the loose items

Suppose I should create a formula or formulas of some sort but are at a loss. Tried different ways but no luck

[pnish]

I assume the carton number is stored in your database. If so you could try designing your report so that it Groups by carton number. Then in the Group Footer, you would have 'All above packed into Carton #n'