Notifications
Clear all
Topic starter
I want to run a report to see ho many patients have received a specific vaccination during a specific date range. Since the Immunizations are no longer stored as obsterms I am not sure how to achieve this. Can anyone point me in the right direction?
Posted : November 25, 2015 6:49 am
You can do this using SQL:
SELECT VaccineGroupName, COUNT(*) AS GivenCount
FROM Immunization
WHERE AdministeredDate BETWEEN '1/1/2015' AND '12/31/2015'
GROUP BY VaccineGroupName
Just change the dates as needed.
Posted : November 25, 2015 6:55 am
Topic starter
Perfect! Exactly what I was looking for. Thanks.
Posted : November 25, 2015 7:09 am
Is there a way to run this report without having to login to SQL?
Posted : July 13, 2016 3:08 pm
