Grand total in report footer 1

[ajdesigns]

Hi
I am running CR 8.5 and I have created a report that outputs a packing list for palletisation(Packing pallets)
I have a number of formula's

boxes
sum({whbypk.BPK_pickqty},{whbypk.BPK_product})/{@to number}
\\to number changes a text string to a number to enable division\\

roundupboxes

local numbervar roundup :={@boxes};
if int(roundup)/2=(roundup)/2 then (roundup) else truncate(roundup)+1;
\\if the tonumber = 32 and we pack 67 this will roundup the boxes to 2 to account for part boxes and thus gives the the total no of boxes per product on a pallet\\

display

whileprintingrecords;
numbervar totalboxes;
\\gives the total boxes on a pallet\\

This all works fine but I need to display grand total of boxes per shipment I could have upto 20 pallets.
I have tries running total and summing display & roundupboxes but i just get the message "The summary/running total field could not be created"
The other formulas are
roundupBoxes (in a group whbypk.BPK_product)
Display(in a group whbypk.BPK_pallet_no)
I need the grand total no of boxes to in the report footer.
Any help would be greatly appreciated
Thanks
AJD

 

[lbass]

Not sure I follow exactly, but you need to accumulate your results in a variable. If you are trying to add "totalboxes", then you would use two formulas:

//{@accum} to be placed in the section where you display totalboxes:
whileprintingrecords;
numbervar totalboxes;
numbervar grtotboxes := grtotboxes + totalboxes;

//{@displgrtot} to be placed in the report footer:
whileprintingrecords;
numbervar grtotboxes;

-LB

 

[ajdesigns]

Thanks LB
You have saved the day once again.
Again THANKS