Hey all, I have an NP Excel report that creates a PDF report for people with appointments for that day. I used a Page in the template to separate each persons data (a handful of tables and charts) within the report. Right now when the PDF is printed, it's sorted by person alphabetically, just like the Page. The end users are wondering if it's possible to keep the data separated by person, but order the report PDF pages by appointment time instead of person. John has an appointment at 9:00 AM, his three pages print first, followed by two pages for Angie because her appointment is at noon, etc.
I've searched and experimented, but I can't see a way to do this. Does anyone know if it's possible?
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: