>I have a group that is all the records in a table.which are a Depth and a lithological description. I created a variable to store the depth because I want the previous depth in each group
> 10 - 20 where 10 is the previous depth and 20 is the current. The problem that I am having is printing out the previous depth before the variable resets to the current depth. if this makes sence to anybody please help.. thanks.
You can do following:
1. Create 'prev depth' cursor
SELECT tableid,UDF(depth) as prevdepth from ...
2. Combine this cursor and table together by tableid into new cursor.
3. Print this cursor.
This way will save you from report variables.
Edward Pikman
Independent Consultant