totals form different fields with reference

[mazamizo567]

I have a table of cement shipping document,every shipping document may consists of different coupon number.every coupon number has a quantity and a material description.

I want to calculate the totals of quantities form different fields depending on the material description form different fields also.

coupon no 1	101
Material description 1	OPC
QNT 1	20

coupon no 2	102
Material description 2	SRC
QNT 2	40

coupon no 3	103
Material description 3	OPC
QNT 3	40

what i need is a fields to calculate the following.
so the OPC totals must be 60
and the SRC totals must be 40
and the shipment total is 100

[ranman256]

in the report, you would put Group headers and footers on,

the records should show as:
coupon, Descr, Qty
coupon no 1,OPC , 20
coupon no 3,OPC , 40
coupon no 2,SRC , 40


in the MATERIAL footer, put a field, set it to =Sum(Qty)
same field in the Report footer.