Please help me create a report?
I need a list of (current) patients aged between 18 - 60 with their dentist's name , last appointment visited, and mobile telephone number all together on an excel sheet.
(I don't need to see those pt's who don't have a mobile number registered)
The information that I am seeing about your office indicates that you are a user of the CS R4+ software. I am going to move this thread over to their section of the Exchange forum. If this is incorrect, please feel free to reopen your question within the CS PracticeWorks section.
To do this you need to create a report, as follows,
1.In Report Manager select a folder and lick 'New Report' and then 'Start'
2.In this window click the ellipsis to create a query
3.create the query as follows:
1.Click on New Query, select 'Start' then 'Next'.
2.Click on 'Specify Criteria'.
3.Scroll down until you find 'Date of Birth' and add it to the criteria window twice.
4.For the first line DoB. In the 'Operator' column select the option 'is earlier than or equal to'
5.In the 'Value' column click the Ellipsis and select the 2nd option (relative to current time) and make it 18 years. Click 'OK' to close this window.
6.For the second line DoB. In the 'Operator' column select the option 'is later than or equal to'
7.In the 'Value' column click the Ellipsis and select the 2nd option (relative to current time) and make it 60 years. Click 'OK' to close this window.
8.Scroll down until you find ‘Mobile Number’ and add it to the criteria window.
9.In the ‘Operator’ column select the option ‘is specified’
10.Click 'OK' then 'Finish' and save the query.
4.Select this query and click 'Next'
5.Click on 'Report Layout'
6.Select the information you require by clicking on 'click here to edit report properties' (in blue).
7.Double click on 'Surname', 'Forename', 'Mobile Number', 'Registered Dentist' and 'Last completed appt date'
8.Click 'OK' then 'Finish' and save the report.
This report will show you all patients aged 18-60 with a mobile number and the date of their last appointment, if they have had one. When you run the report remember to change the Output to Excel and this will give you what you want.