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.
QUERYREPONSESKEEPREPEATING.doc
Description: MS-Word document
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= 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
