Report for Found Animals

Submitted by ppvs on Tue, 14/06/2011 - 12:43

in

General User's Discussion

Hi,

When we have a found dog presented I am using the Patient List Report to try and match any possible patients on file to the found one. I am wondering if there is another report that we could also bring in colour, sex, desexed and DEACTIVATED. I keep our database very current and regularly go thru and deactivate patients and clients.

In our previous Practice management software we had a "query" section that could pull a lot of specific data. Would this be something other users would find beneficial or is this available and we haven't found it?

Thanks

Bernie

Login or register to post comments

Re: Report for Found Animals

Submitted by Matt C on Tue, 14/06/2011 - 13:02.

Hi Bernie,

I will have a go at creating a report that you can provide search filters such as the ones you have described. Give me at least 2 weeks...... others will probably do a better and faster job :)

In the meantime your "query" section sounds intriguing. Did it let you load "queries" and then have the results load into a workspace for working from? I have often thought this would be great. We could even use the templates as the source of the query.

What do others think?

Matt C

Login or register to post comments

Re: Report for Found Animals

Submitted by dadmin on Tue, 14/06/2011 - 21:55.

Hi Bernie and Matt,

there is already a report that can find patients through some of these search criteria in the shared resources. It's the Patient List Report. It could be improved to provide more filters and output better info such as client id.

Matt Y.

Login or register to post comments

Re: Report for Found Animals

Submitted by dadmin on Tue, 14/06/2011 - 21:58.

Stupid me just reread the original question and realised that you already knew that. Sorry misunderstood.

Login or register to post comments

Re: Report for Found Animals

Submitted by ppvs on Wed, 15/06/2011 - 08:34.

Don't be so harsh on yourself!!

Login or register to post comments

Re: Report for Found Animals

Submitted by Matt C on Sun, 26/06/2011 - 20:14.

Hi Bernie,

Finished your patient report with filters for;

sex, desexed, colour and deactivated.

http://www.openvpms.org/customisation/patient-list-report#comment-3617

Link works from forums.

Note that the desexed and deactivated filters are Yes/No filters and are always on.

eg. It will not search for both desexed & entire pets simultaneously as the previous version did.

Login or register to post comments

Re: Report for Found Animals

Submitted by ppvs on Mon, 27/06/2011 - 10:12.

Thanks Matt,

I went to the link but the report is a pdf. Does it need to be one of the jxml types to import?

Thanks Again,

Bernie

Login or register to post comments

Re: Report for Found Animals

Submitted by Matt C on Wed, 29/06/2011 - 18:44.

Hi Bernie,

Sorry, that was the test run!

I have attached the correct report to this reply and fixed the link in Shared Resources section (here).

My apologies,

Matt C

Attachment	Size
Patient List Report_11 06 24.jrxml	21.73 KB

Login or register to post comments

Re: Report for Found Animals

Submitted by ppvs on Thu, 30/06/2011 - 13:34.

Hi Matt,

I don't think I have the report side down pat at all. I think it is correct that I put a precentage before and after if it "includes" and just before if it is the only choice??? I think I have tried all ways.....

This new report still seems to bring up everyone and not for eg the %canine %male %brindle% desexed-ticked deactivated unticked %staff%

If you could shed some light that would be much appreciated.

Sorry to be a pain,

Bernie

Login or register to post comments

Re: Report for Found Animals

Submitted by Matt C on Thu, 30/06/2011 - 16:49.

Hi Bernie,

I think plenty of people get confused with the "%" so don't worry. It is possible the report is misbehaving as well! I did a bit of testing before I released it and today and it is seems to be working fine.

I have uploaded a new version as you might have found that if you ran the report without changing all the options you got no results. It was becuase of the pesky Deactivated and Desexed fields. They have been the reason the report took so long to come out. :) I also added a colour column to the results.

http://www.openvpms.org/customisation/patient-list-report#comment-3626

OK, so let's look at the %.

Example

So say you want to find all;

- Female German Shepards called "Ripley" (The details of my dog :) )

I would enter:

a) "F%" in Sex

b) "Ger%" in Breed

c) "Rip%" in Name

The % literally means "any number of any character"

This will return the following examples:

1. Female German Shepard "Ripples"

2. Female German Short haired pointer "Ripoff"

3. Female German Pooly "Ripped"

Cheers,

Matt C

Login or register to post comments

Re: Report for Found Animals

Submitted by ppvs on Fri, 01/07/2011 - 09:07.

Morning,

Well I think we are getting closer - did you play with the deactivated tick as I am still doing something wrong as none of the patients that we have deactivated are coming up.

Thanks

Bernie

Login or register to post comments

Re: Report for Found Animals

Submitted by Matt C on Fri, 01/07/2011 - 20:04.

Evening Bernie,

Hmmm. I just checked on our OpenVPMS using the "11 06 30" version.

Ticking Deactivated shows all deactivated animals.

Unticking shows all active animals....

Not so for you?

Matt C

Login or register to post comments

Re: Report for Found Animals

Submitted by ppvs on Sat, 02/07/2011 - 09:58.

Hi Matt,

Sorry this is taking so much time.

I have searched in our old system and open so I know there are deactivated dogs that are not deceased (old system would bring both up) with that description and when I tick deactivated I get a blank screen.

I have checked the version and it seems correct.

Bernie

Login or register to post comments

Re: Report for Found Animals

Submitted by Matt C on Sun, 26/06/2011 - 20:15.

Oh and Bernie,

Not the same as your post regarding searching for duplicate patients but these reports look for duplicated customers.

http://www.openvpms.org/customisation/duplicate-customers-identical-address-patient

Cheers,

Matt C

Login or register to post comments

Re: Report for Found Animals

Submitted by dadmin on Sat, 02/07/2011 - 17:32.

From a brief look at the query I believe it is looking for deactivated clients, not patients.

Matt Y.

Login or register to post comments

Re: Report for Found Animals

Submitted by Matt C on Sun, 03/07/2011 - 22:58.

Hi Bernie and Matt Y,

You are spot on Matt.

I fixed the query and have uploaded the last version.......

Fingers crossed. :)

http://www.openvpms.org/customisation/patient-list-report#comment-3638

Matt C

Attachment	Size
Patient List Report_11 07 03.jrxml	22.17 KB

Login or register to post comments

Re: Report for Found Animals

Submitted by ppvs on Mon, 04/07/2011 - 12:57.

Hi Matt & Matt

I am not sure what I am doing wrong. I have added a screen shot so you may be able to see something in the criteria I have entered... If only people had a collar, tag & UTD detailed microchip this report would not be needed.......

Login or register to post comments

Re: Report for Found Animals

Submitted by paradisevet (not verified) on Mon, 04/07/2011 - 18:13.

Hi,

I have tried running this report with Matts latest file but get the attached error before it even gets to entering any details. Earliest version worked fine. Any idea of what is wrong?

Nick

Attachment	Size
Doc1.doc	87.5 KB

Login or register to post comments

Re: Report for Found Animals

Submitted by Matt C on Mon, 04/07/2011 - 19:20.

Hi Bernie & hi Nick,

Whew! I admire your patience.

I have tested and attached yet another version to this post and updated the version in the shared resources section.

It specifically did not work when the Deactivated box was ticked due to me missing an old filter that excluded all deactivated pets!

Nick,

I am not sure why you are getting that error. If you upload the latest version and it happens again, let me know. I may be able to test remotely for you :)

Keep the faith.

Matt C

Attachment	Size
Patient List Report_11 07 04.jrxml	22.16 KB

Login or register to post comments

Re: Report for Found Animals

Submitted by paradisevet (not verified) on Tue, 05/07/2011 - 08:40.

Hi Matt,

Still some weird Boolean error message. No other reports are doing this. Any advice?

Nick

Login or register to post comments

Re: Report for Found Animals

Submitted by Matt C on Thu, 07/07/2011 - 00:03.

Hi Nick,

Your boolean error is a jasper report engine issue but I have changed the the report so it is more backwards compatible. It now works in Version 1.4.

Attachment	Size
Patient List Report_11 07 06.jrxml	27.05 KB

Login or register to post comments

Re: Report for Found Animals

Submitted by paradisevet (not verified) on Thu, 07/07/2011 - 10:34.

Hi Matt,

Thanks for your time - all issues resolved now

Nick

Login or register to post comments

Re: Report for Found Animals

Submitted by ppvs on Tue, 05/07/2011 - 09:46.

Morning Matt,

Thanks so much!!! :) :)

Runs perfectly. I hope others will find this report beneficial after all the work that has gone in to it. No worries keeping the faith, I am glad you were happy to keep at it.

Cheers

Bernie

Login or register to post comments