25 Apr 12 11:55
Version 11 Crystal.
I need to store a date value from a status history record and then use that value in the next occuring status history record.
Group 1 Case File Number
Group 2 Status Record Number
In group 2 if Status Outcome = Refused then store Decision Date.
Then go to next Status Record and Recall the previous stored Decision date.
This is in itself not that tricky using shared numbervar variable.
However the bit i am struggling with is if the next status record happens to also be Status outcome = refused. What i want to do is retain the previous record Decision for a calculation. But then after that again store the "new Decision Date" to be used in the next Status Record After That.
This would need to repeat itself until the the next status record is outcome <> "Refused". There is also potentially no limit to how many status record = Refused a case may have.
GH1 Case A.
GH2 Status Record 001; outcome = Refused, Decision date= 01/01/2012 (formula A then stores Decision Date 01/01/2012.)
GH2 Status Record 002; outcome = Refused, Decision Date = 01/02/2012 (formula B uses the stored value "Decision Date 01/01/2012) But (Formula A then stores Status Record 002's Decision Date 01/02/2012)
GH2 Status Record 003; outcome <> Refused, (formula A not used because outcome <> Refused) (Formula B uses uses the stored value "Decision Date 01/02/2012)
This would keep on repeating itself to the end of the Case Record. Then i would use a reset of the variable in the formulas.
Hope someone can help,