If I understand correctly, you have a list of Patients with different appointment times and want to page on field Patient but you want the print order to be based on first appointment time. For example:
To achieve this I would add a PrintOrder table like this - where fields Patient and Appointment already exist in the table Appointments:
LOAD Patient, Min(Appointment) as PR, Patient as DispVal, RowNo( ) as rowno
Group By Patient order by Appointment;
Now you simply need to remove any sorting on DispVal and use it as the Page field. You should then get a report in the required order:
Project attached. Extract to folder C:\Temp\Community\060 or change the paths in the NSQ.
HTH - Daniel.
060.zip 148.7 K