>>>>The issues of the detail band printing on the same page is resolved. This was due to empty fields required by the report. A newer observation is that the same report appears as the second page. How do I access the cursor while the report is running? Thanks.
>>>
>>>How do you create the cursor for report?
>>
>>The following privdes for the header.
>>
>>
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
>>
>>The reset of the fields are based on the information input for each field in the report.
>
>Why do you need to access the cursor when report is running?
To see if there are duplicate records in the cursor.
- Ravi
True greatness consists in being great in little things.
- Charles Simmons