How to get count of items on a pick sheet, including multi-page pick sheets.
End user needed the count of items on a page at the bottom of each pick sheet. I found the Crystal tip below to do this. Variables in Crystal are global unless declared as local. In the formulas below, x is global and is modified by each formula.
Formula 1 : @Reset
Code:
NumberVar x;
WhilePrintingRecords;
x:=0;
Formula 2 : @ItemPageCount
Code:
NumberVar x;
WhilePrintingRecords;
x:=x+{DatabaseField};
Formula 3 : @Display
Code:
NumberVar x;
WhilePrintingRecords;
x
Place Formula1 in Page Header section and suppress
Place Formula2 in Details section and suppress
Place Formula3 in Page Footer and don't suppress, this is your page count of items.