Report showing all details and summary at bottom

[janeyd]

I have created a report for a packing list which shows:-
C/no., Order No., Details, Net KG
This has to show all details, ordered by carton no.

After all details are listed I want a summary at the bottom of the page ordered by order no.
Order No., Details, Sum of Net KG, Gross KG(this is picked up from underlying query).

I can have different order no.'s packed into same carton, or one order no. spread over several cartons, therefore normal report wizard summary does not work.

I have tried summarizing in report footer or page footer, but I only get one line rather than summary of everything.

Would be grateful for any advice.

Thanks

 

[Ranman256]

at the footer of the Carton,
put sum fields
txtWt = Sum(Wt)
txtCount = Count(DetailID)