SELECT Image, ProductCode, Description, RECNO() AS rn ; FROM crsReport ; INTO CURSOR crsTemp SELECT ; t1.Image AS Image1, t1.ProductCode AS ProductCode1, t1.Description AS Description1, ; t2.Image AS Image2, t2.ProductCode AS ProductCode2, t2.Description AS Description2, ; FROM crsTemp t1 ; JOIN crsTemp t2 ON t1.rn = (t2.rn-1) ; WHERE (t1.rn % 2) = 1 ; INTO CURSOR crsNewReport>I would like to print 2 records on the same line
> T I T L E > > IMAGE 1 IMAGE 2 > Product code 1 Product code 2 > Description 1 Description 2 > > IMAGE 3 IMAGE 4 > Product code 3 Product code 4 > Description 3 Description 4 > > IMAGE 5 IMAGE 6 > Product code 5 Product code 6 > Description 5 Description 6