Call Us Today
1.877.838.9273

• How to Buy
• Contact Us
• Member Login

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 # 5101520253050100All

Mss rewards