>>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.
- Ravi
True greatness consists in being great in little things.
- Charles Simmons