>>>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?
--sb--