Crystal - variable evaluate after with criteria

kelsanit
kelsanit used Ask the Experts™
on
Attached is a sample report showing one product.  The field is RED shows a evaluate after field taking the previous value - qty on hand.  In this example I need to capture  the value -48.  This is the date where the product first goes negative.  Please let me know how I can capture this value at that point so I can use as shared vairable and pull into main report.sample.rpt
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
That should capture it.

Why do you think there is a problem?

mlmcc

Author

Commented:
the curret report works perfect, however I now need to capture that value of -48 at the time and not the other values so i can put in the footer and use as shared vairable in the main report.  The report currently sends over the "first negative date" but i now also need the qty that needs to be produced by that date which in this case is -48
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Sorry.  JUst need to add a SHARED variable for the first negative quantity.  YOu will need to declare it in the main report just as you did the DATE shared variable.

New formula to use

EvaluateAfter({@zDisp_Qty_OnHand});
SHARED NumberVar Qty_OnHand;
SHARED DateVar First_Negative_Date;
SHARED NumberVar First_Negative_Qty;

Qty_OnHand := Qty_OnHand - {ORDER_TRL.Quantity-Open};
If Qty_OnHand < 0 AND First_Negative_Date = Date(1900,1,1) then
(
    First_Negative_Date := {ORDER_HDR.Ship-Date};
    First_Negative_Qty := Qty_OnHand;
);
Qty_OnHand

Open in new window


mlmcc

Author

Commented:
Thank you

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial