Since each line is a different row shared variables and formulae are the way to go...I think.
Depends on where you want to see the difference, if diff of c2 and b3 are displayed on the b3 line, this should work, I don't know off-hand how to display on the c2 line.
In the detail section you will need to create a formula, and since this is running all the time I will use the 2nd line for the example, that first calculates the value of b2-c1 (datediff should work) and then captures (shared variable) the value of c2 for use the next time around. You could even initialize the value of the variable to some bogus date and skip the calculation if the c value is that bogus date.
Hope this helps or at least provides a glimmer of an idea.
IP Logged
