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.