Select proper work area before report is run

...
SELECT LettersForThisPatient 
report form ViewReferralLetter preview
...

BTW, the number of records returned by SELECT statement is stored into _TALLY global system variable.

SELECT ... FROM ...
IF _TALLY = 0
  * No records returned
...

>Hi all:
>
>I am developing a very simple report. All I want the report to do is to select all the information for a particular patient into a cursor and then output those results to a report, by date.
>
>I have the following code:
>

if !empty(mHealthCard)
>	select * from referal_to into cursor LettersForThisPatient nofilter;
>		where referal_to.hlth_card = mHealthCard;
>		order by referal_to.refer_date
>endif
>
>* First see if there is any data in the cursor
>* If there is data, then do the report ViewReferralLetter, else
>* tell the user that there is no data avaiable.
>
>count to gaga
>if gaga = 0
>	do form not_find
>else
>	* Select the field required to display the clinic information on the report and
>	* store that information into a cursor.
>	select clnc_name, address2, address22,;
>		alltrim(proper(city))+", "+alltrim(upper(Province))+" "+ alltrim(PostalCode) as CityProvcode,;
>		alltrim(str(area_phone))+" "+alltrim(str(phone)) as telephone,;
>		alltrim(str(area_fax))+" "+alltrim(str(facsimile)) as faxnumber;
>		from clinic into cursor clinicinfo nofilter
>	report form ViewReferralLetter preview
>endif

>
>Current Situation: The ViewReferralLetter does not show any information other than the labels on the report (Detail Section). The Header is getting all of the information popluation from theclinicInfo cursor.
>
>Any suggestions? TIA.