Count Item Quantities on Report

[hullstorage]

Hi All,

I have a report for printing delivery notes

on these reports are
customer
stock code
description of goods
quantity

there may be 3-4 deliveries per sheet

at the bottom of the report i want there to be a loading summary for all the deliveries together like this

also bare in mind that there are multiple goods and we will also
add new stock codes as we go along

delivery 1
JOE BLOGGS
AJG001 - 8FT TABLE - 1
AJG002 - CHAIRS - 8
AJG004 - CUSHIONS - 8

delivery 2
STEVEN SMITH
AJG001 - 8FT TABLE - 2
AJG002 - CHAIRS - 6
AJG004 - CUSHIONS - 6

delivery 3
JOHN JONES
AJG005 - 10FT TABLE - 1
AJG002 - CHAIRS - 16
AJG004 - CUSHIONS - 16


AJG005 = 1
AJG002 = 30
AJG004 = 30

 

[gemma-the-husky]

i would try preparing a separate summary report, based on the same query

and embed this in your main report as a subreport.