I've got the same results on LAB & MIC reports. What appears to be happening is that the patient has as many entries on the query dictionary as there are queries associated with that specimen. So, for whatever Meditech reason it is, it loops and prints the queries as many times as there are queries associated with that specimen (in your case, with that rx).
Since you're selecting only one patient at a time, you could just sequence the report by query, and then remove the duplicates by allowing only the first of any of the duplicates to print via line check. Good luck, let me know if you need more info...! Gary Hall Clinical Applications Specialist Estes Park Medical Center Information Systems Department 970-577-4443 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, February 12, 2007 12:49 PM To: [email protected] Subject: [MEDITECH-L] NPR report writer help pulling responses from group response to different queries/keeps repeating lines I have a report writer problem that has me really befuddled. I have about a dozen queries (not multiple queries) They are all single response queries. The answers to the queries can be free text or can be an answer from a group response. I have all that on the report, nice and neat. The problem is, whether I put the fields for the queries into the detail region or make it a key and put them into the HK region, once the initial answers print, the answers continue to repeat. I suspect this has something to do with multiples but I can't figure it out. My report is written in PHA.RX with the detail segment of pha.rx.queries because I can't seem to pull the information any other way. I want to eventually pull this report onto another PHA report containing patient's current meds. I will attach a text file of some of the queries and the report, Any help is appreciated. I also tried doing it a different way with a method I found on the IATRICS site for making a macro for the strings. My macro (called setmap)looks like this: 'PHA.HOMEDA,PHA.DOSE1,PHA.SIG1'^/MAP[1], 'PHA.HOMEDB,PHA.DOSE2,PHA.SIG2'^/MAP[2], 'PHA.HOMEDC,PHA.DOSE3,PHA.SIG3'^/MAP[3], 'PHA.HOMEDD,PHA.DOSE4,PHA.SIG4'^/MAP[4], 'PHA.HOMEDE,PHA.DOSE5,PHA.SIG5'^/MAP[5], 'PHA.HOMEDF,PHA.DOSE6,PHA.SIG6'^/MAP[6], 'PHA.HOMEDG,PHA.DOSE7,PHA.SIG7'^/MAP[7], 'PHA.HOMEDH,PHA.DOSE8,PHA.SIG8'^/MAP[8], 'PHA.HOMEDI,PHA.DOSE9,PHA.SIG9'^/MAP[9], 'PHA.HOMEDJ,PHA.DOSE10,PHA.SIG10'^/MAP[10], 'PHA.HOMEDK,PHA.DOSE11,PHA.SIG11'^/MAP[11], 'PHA.HOMEDL,PHA.DOSE12,PHA.SIG12'^/MAP[12] Where PHAHOMEDA is a query that can be answered from a group response called PHA.DRUGS or it can be answered as FREE TEXT. PHA.DOSE1,2,3 etc. are free text answers. PHA.SIG1,2,3 etc are like PHA.HOMEDA,B,C etc in that the answer can come from a group response called PHA.SIG or it can be free texted in. I set up a foot note for AL START setmap but I don't know how to pull these lines onto the report as single lines. And when I try to do anything, that particular report just crashes. Anyway, the report I am trying to fix and an example of how it is being printed is attached. Any help would be truly appreciated. Cindy(See attached file: QUERYREPONSESKEEPREPEATING.doc) This e-mail message, including its attachments, is for the sole use of the intended recipient(s) and may contain confidential or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender of this communication immediately. =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit MTUsers.COM. To check the status of the meditech-l, visit MTUsers.NET. For help, email [EMAIL PROTECTED] ______________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
