Date Difference using Prior Detail Row

[wanzek1]

I need a to do a date difference that goes something like this but I don't know how to get the prior detail row information:

if {APUR.ApprovalSeq}=Minimum ({APUR.ApprovalSeq}) then

dateDiff("d", {APUR.DateAssigned},{APUR.DateApproved})

else if {APUR.ApprovalSeq}<>Minimum ({APUR.ApprovalSeq})

then dateDiff("d", {APUR.DateAssigned},Prior({APUR.DateApproved})) <<this is where I get stuck. Is there a way to use the prior DateApproved from the prior detail line?

 

[kenhamady]

There is a Previous() function in CR that pulls a value from the prior detail. Just note that the prior detail could pull from a prior group.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/

 

[wanzek1]

Is there a way to do this without having the possibility of crossing groups?

 

[kenhamady]

You can use an IF statement:

If {GroupField} <> Previous ({GroupField})
then ...

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/