>* in the calling PRG
>USE patient
>USE labresult
>
>* get fields needs and then order the data
>SELECT patient.name, labresult.testdate, labresult.testresult ;
>  FROM patient, labresult ;
>  WHERE patient.id = labresult.fk_patientid ;
>        labresult.testdate > date() - 7
>  ORDER BY patient.name, labtest.testdate ;
>  INTO CURSOR cReport
>
>* ensure the cursor is currently select
>SELECT cReport
>* run the report
>REPORT FORM MyReportName PREVIEW
>