How do I do something like this:
I have a report which utilizes the page header section.
Page header section contains, patient name and address (from table PATIENT).
The report breaks for each patient (a new page for each patient break).
I have created a subreport that also resides on the page header section also.
The subreport contains appointment schedules (from table SCHEDULE).
What I want is that for each page, only 10 records (from the subreport) will be displayed.
So if the subreport have 19 records, it will display the first 10 records
on the first page and the 9 remaining records will be displayed on the second page.
Say if I have 2 patients, if patient1 have 20 appointments and patient2 have 10 appointments,
there will be 2 pages that will be allocated for patient1 where page 1 contains the
schedule 1 to 10 and page 2 will contain schedule 11 to 20.
Page 3 will be use by patient2.
Can this be done?
I'm using Crystal 8.5 and MSSQL server 2000