>* 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 >