Call Us Today
1.877.838.9273

AVImark Forum::Newbies::Multiple entries in information search

Home

AVImark Forum

Newbies

Multiple entries in information search

AVImark Forum :: Newbies

Board Index

Latest Posts

Welcome Guest

Subject :Multiple entries in information search.. 12-02-2011 09:29:23

Herm1234

User

Joined: 04-29-2011 11:52:21
Posts: 22
Location:

When using some information searches that I have set up, I will get the same pet on
the list multiple times. An example is the below search.

search [Client] code 'VACC' name 'Vaccines due'
category 'Reminders' (
[Client-Codes] does not contain 'i' and
[Patient-Codes] does not contain 'i,m,h,d' and
[Patient Reminder-Code] does not equal 'lbhwt' and
[Client-E-mail-Text] is blank and
[Patient-Last Reminded] equals '12/01/2011'
) report (
[Client-Full Name],
[Patient-Name],
[Client-Address],
[Client-City],
[Client-Zip],
[Client-State]
) sort by (0 ascending)

How can I rework this search to give me only 1 entry per pet?
Thank you!

IP Logged

Subject :Re:Multiple entries in information search.. 12-02-2011 10:03:08

Charles McAllister - AVImark

User

Joined: 12-03-2009 08:31:46
Posts: 12
Location:

Because you are searching in "Patient Reminder", then AVImark will give you a line in the report for every reminder found -- even though you are not reporting on any reminder fields. One way to solve this is to create an "Exists In" condition: Right-click and add a new condition, choose Patient click Next, then choose "Search for Patient in a previously defined search", Click Next, then Finish. Add all of your other conditions so that they're below this Patient condition (note, you can drag and drop conditions so they end up below the Patient Exists In line).

Your search will look like this:

search [Client] (
[Patient] exists in (
[Client-Codes] does not contain 'i' and
[Patient-Codes] does not contain 'i,m,h,d' and
[Patient Reminder-Code] does not equal 'lbhwt' and
[Client-E--mail-Text] is blank and
[Patient-Last Reminded] equals '12/01/2011'
)
) report (
[Client-Full Name],
[Patient-Name],
[Client-Address],
[Client-City],
[Client-Zip],
[Client-State]
) sort by (0 ascending)

Another way to solve the problem is to keep your search criteria the way you have it, but on the Report criteria tab, cilck on Summary and Subtotals Setup at the bottom, and choose the Summarize option, and select the Specify Summary Order option, and use the green arrows to select fields so that on the right side you have Full Name followed by Name -- this will group the results by the client's full name, then by the patient's name.
(If you have several client's with the same Full Name, if may cause an issue; it may be better to select the report column, Client - Account, and summarize on Account then Name).

Hope this helps!

IP Logged


	Page #

" I could be a salesperson for AVImark - the company is great, technical support staff is super - I love the software - if you need to refer new potential users to happy clients....have them call me! "

Angee Baker

Chat Hours:
Monday - Friday
8am - 5pm CST

Mss rewards

Sign up for a year of AVImark technical support and get additional discounts when you use these other services. Click Here to Learn More