I have been asked to compile a report with two main queries:
Firstly, and one I can see on your pre prepared reports, I need to list all schemes of patients seen between two dates, (which will be variable as I run the repost week to week) who have completed a course of treatment, then, FROM THAT list, I need to see who has booked a future appointment.
Can you help please?
This can be achieved by creating 2 reports
The first report will find all the completed courses of treatment in a certain period of time
To create a report to find the number of completed CoTs in a given time.
To create a report to find the number of completed CoTs in a given time with a PENDING APPOINTMENT
However, the second report will find the patients who have completed a CoT within the time but the pending appointment they have may be one from the past which wasn't cancelled or completed!
It is easier to find the patients that have not got a booked appointment and that can be done by editing the second report at steps 17 & 18 and choosing the option as follows
17. That don't have an appointment with a status of [Appointment Status]
18. Select 'Specify Criteria' and select 'Pending' in the Value Column
I hope this helps you to get the information you require, if you need any further advice do please get to me.