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
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