I have a scenario that, I should use a value of a column in the next coming records in current record.

 

The data is as follows.

 

ORDER   LINE    Q1 Q2   WEEK-NUM   FINAL_QTY ( Final Qty of Week(i) = Q1 (week i+1) - Q2 (week i+2))
-------------------------------------------------
100        1         10   02     1               8  ( 30 - 22 = 8) 
100        1         10   02     1               8  ( 30 - 22 = 8) 
100        1         30   22     2               7  ( 10 - 3 = 7)
100        1         10   3       3               7
100        1         10   3       3               7
100        1         10   3       3               7

 

Here the column FINAL_QTY is calculated as follows.

 

FINAL_QTY of Week i = Q1 of Week i+1 - Q2 of week i+1

 

For example:  First 2 records belong to week 1.

 

The value of FINAL_QYT for week 1 =  Q1 of week 2 - Q2 of week 3.
Now the value = 30 - 22 = 8.

 

For the last week the calculation = Q1 of current week - Q2 of current week.

 

Is there any way we can do this in crystal reports?

 

Thanks in advance.

 

Regards

Gowtham

 

I am  using Progress Database .. and I don't have access to the database. So I am looking for some workaround in reporting tool itself.

 

Can we do something like this in report level?

 

Thank you

Regards,

 

Gowtham