>>Select proper work area before report is run
...
>>SELECT LettersForThisPatient
>>report form ViewReferralLetter preview
>>...
>>
>The above did it. Thanks Sergey.
>
>I did place the following code:
>
>
>
SELECT * FROM LettersForThisPatient
>IF _TALLY = 0
> * No records returned
>>* Show a from that tells the user that there are no records to display
>else
> * Do all the dat gathering and display the report
>
>What I see happening is the cursor being displayed on screen before the report is display. Actually I would not want the cursor to show up at all. I even put "Select * from LettersForThisPatient noconsole" and it still showed up on screen.
>
>TIA.
You don't need that additional select. Check _TALLY after the select that creates cursor LettersForThisPatient.
--sb--