Patients Not Vaccinated
Is there a report that can be run to search the database by species by date for something that has not happened? Specifically can I run a report by species to find animals that have not been vaccinated in the past 12 months, but the client has been seen during that time?
Further, can I query the database to find animals over 10 years of age, who have been into clinic during 2009 and 2010 for any reason/service/product but not since that time?
Paul Martin
Re: Patients Not Vaccinated
Both of these reports are quite possible Paul, pretty much any custom report is
You will need an understanding of SQL(Structured Query Language) and use Ireport to create the report your requiring.
Basically Ireport allows you to formulate a query on your database, create the report template which can be uploaded into Openvpms to produce the report when you need it. It also supports the use of runtime variables.
I would suggest examining one of the existing reports such as the Patient List Report in Ireport to see how its done.
If this is a sounds to hard, you can contact an implementor or person skilled in sql to create the report for you.
Ben