Using CR XI SP 3 with Oracle 9i.
When I get to print the 10th record I need to retrieve the values used by the 5th row.
How do I save it and reuse when I'm in my last row?
My report page print all 10 rows from a view, but I need to look back by using formulas and/or creating share number.
e.g.
whileprinting
numbervar saverow5;
if tbl.row_order=5 then saverow5=tbl.col8 of row 5
else 0
It's not working for mr and I get 0 all the time.
Any ideas of how to do it (I can get the value by using a function to read the view and return the desired column, but this is not the best solution)
Thanks,
Ivan.
When I get to print the 10th record I need to retrieve the values used by the 5th row.
How do I save it and reuse when I'm in my last row?
My report page print all 10 rows from a view, but I need to look back by using formulas and/or creating share number.
e.g.
whileprinting
numbervar saverow5;
if tbl.row_order=5 then saverow5=tbl.col8 of row 5
else 0
It's not working for mr and I get 0 all the time.
Any ideas of how to do it (I can get the value by using a function to read the view and return the desired column, but this is not the best solution)
Thanks,
Ivan.