Patient Sterilisation Report

Submitted by tony on Tue, 27/05/2008 - 10:54

Report

Category:

Patient

This report allows you to find any active patient that is not desexed given a given birthdate range.

To install just create a new Template in Administration ->templates and set the Archetype to Report, the appropriate user level, Report Category (I set as a patient report) and upload the attached jrxml file. You will then see and run the report in the Report ->reports workspace.

Comments

Creating new reports using the import from shared resources

Submitted by ahn (not verified) on Tue, 30/12/2008 - 19:50.

Hi, forgive my ignorance, as I am only learning, but I have managed to copy the code into the report and then the dialogue box comes up to allow me to enter the dates but then comes up with the following error : "Unknown column `r.target_linkld' in `on clause'

What does this mean and how do I fix it?

Amanda Hulands-Nave Bellarine Veterinary Practice

Updated report.

Submitted by dadmin on Mon, 19/04/2010 - 23:55.

I have just updated the report to fix some problems:

capitals in the report query causing issues on unix servers
also enhanced the layout to show some hidden parts such as client contact details
Changed the input names from start and end date to born after and born before date
Fixed some incorrect column references in the report query( as previously discovered by Amanda in this comment- http://www.openvpms.org/patient-sterilisation-report#comment-858)

Please enjoy!

Attachment	Size
Patient Sterilisation Report 2.0.jrxml	11.51 KB

Re: Updated report.

Submitted by garry edgar on Sat, 30/04/2016 - 18:36.

Finally. This is the report I wanted! Can't believe I never found it before.

Now, would be good if we had email addresses and species(or ability to select species so we can exclude rats, mice and birds!)