Avatar of kelsanit
kelsanit
 asked on

Crystal - variable evaluate after with criteria

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

Avatar of undefined
Last Comment
kelsanit

8/22/2022 - Mon
Mike McCracken

That should capture it.

Why do you think there is a problem?

mlmcc
kelsanit

ASKER
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
ASKER CERTIFIED SOLUTION
Mike McCracken

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
kelsanit

ASKER
Thank you
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23