>I am trying to produce a report based which has a side-by-side comparison of fields from two different rows of the same table. In other words, I'm showing a Current and Past value next to each other.
>
>The question is, how do I get these values on the same page/detail row of a report?

CREATE CURSOR rpt_cursor .....
select table
go nRecords1
scatter to array ...
insert into rpt_cursor from array ...
go nRecords2
scatter to array ...
insert into rpt_cursor from array ...
select rpt_cursor
REPORT FORM ...