Hi
Quite new to crystal and need to get a sum in an existing report but need some help?
Have this in GH2
WhilePrintingRecords;
numbervar RunPhysical;
RunPhysical:= {STK_STOCK.STK_PHYSICAL} + {STK_STOCK.STK_QTYPRINTED}
Have this in Details
Whileprintingrecords;
Numbervar RunPhysical;
If {STK_MOVEMENTS.SM_DATE} > {?Report Date} And {STK_MOVEMENTS.SM_STATUS} = 'I'
Then
(if {STK_MOVEMENTS.SM_SERIALTRACK}=1 then
RunPhysical := RunPhysical - 1
else
RunPhysical := RunPhysical - ({STK_MOVEMENTS.SM_QUANTITY}*{STK_MOVEMENTS.SM_QTYUNIT})
)
Else
If {STK_MOVEMENTS.SM_DATE} > {?Report Date} And {STK_MOVEMENTS.SM_STATUS} = 'O'
Then
(if {STK_MOVEMENTS.SM_SERIALTRACK}=1 then
RunPhysical := RunPhysical + 1
else
RunPhysical := RunPhysical + ({STK_MOVEMENTS.SM_QUANTITY}*{STK_MOVEMENTS.SM_QTYUNIT})
)
Else
RunPhysical := RunPhysical
Have this in GF2
whileprintingrecords;
numbervar RunPhysical;
I have totals being generated in the GF2 but need the sum of these in GH1 - is there a way to do this?
Really sorry if anyone needs more info, as I say, im new to CR
Many thanks
Quite new to crystal and need to get a sum in an existing report but need some help?
Have this in GH2
WhilePrintingRecords;
numbervar RunPhysical;
RunPhysical:= {STK_STOCK.STK_PHYSICAL} + {STK_STOCK.STK_QTYPRINTED}
Have this in Details
Whileprintingrecords;
Numbervar RunPhysical;
If {STK_MOVEMENTS.SM_DATE} > {?Report Date} And {STK_MOVEMENTS.SM_STATUS} = 'I'
Then
(if {STK_MOVEMENTS.SM_SERIALTRACK}=1 then
RunPhysical := RunPhysical - 1
else
RunPhysical := RunPhysical - ({STK_MOVEMENTS.SM_QUANTITY}*{STK_MOVEMENTS.SM_QTYUNIT})
)
Else
If {STK_MOVEMENTS.SM_DATE} > {?Report Date} And {STK_MOVEMENTS.SM_STATUS} = 'O'
Then
(if {STK_MOVEMENTS.SM_SERIALTRACK}=1 then
RunPhysical := RunPhysical + 1
else
RunPhysical := RunPhysical + ({STK_MOVEMENTS.SM_QUANTITY}*{STK_MOVEMENTS.SM_QTYUNIT})
)
Else
RunPhysical := RunPhysical
Have this in GF2
whileprintingrecords;
numbervar RunPhysical;
I have totals being generated in the GF2 but need the sum of these in GH1 - is there a way to do this?
Really sorry if anyone needs more info, as I say, im new to CR
Many thanks