Good Day Everyone,
Im using Crystal Reports 10 for the first time and would like some help,
ive linked it to VB 6 and MySql.
and use cross-tab to view my reports however,
i got this problem on which i can programmaticaly solve on vb6 listview...
here it is,
i got 5 columns
Int Amount Accu Amount Int/Mo Accu/Int OB
lets say
Val = database amount on SQL
Rate = database amount on SQL
Int Amount = Val
Accu Amount = total of Int Amount or ( X = X + IntAmount)
Int/Mo = if rowcount = 1 then int/Mo = 0 else value of accu Amount(row count - 1) * Rate
Accu/Int = Int/Mo + Accu/Int(row count - 1)
OB = Accu Amount + Accu/Int
on which it would look like this
Val = 140
Rate = .0005
Int Amount Accu Amount Int/Mo Accu/Int OB
140 140 0 0 140
140 280 .70 .70 280.70
140 420 1.40 2.10 422.10
140 560 2.10 4.20 564.20
.......
i can do OB and Accu Amount but i cant get past Int/mo and Accu/int
or i cant get value of row-1 like 140*.0005 to get .70 and 1.40+.70 to get
2.10.
or simply how to get value of previous row values
help anyone?
~liz
IP Logged
