Hi Karen,
Easiest way is through a macro: Create for the multiple group response query one computed field: xx.query Place these attributes on computed field (xx.query) DAT=FREE JFY=L LEN=50 [EMAIL PROTECTED]"GROUP_RESPONSE_NAME",@cdm.response ["QUERY_NAME",1]] Place this query on the picture twice, exactly lined up underneath with each other "GROUP_RESPONSE_NAME" -> your group response name "QUERY_NAME" -> your query name Place on the first line of xx.query this Line Check: MV=D Place in the Footnotes this direction: AL D detail.macro File and exit Return to the third page and take note on which line number this computed field has been placed Exit, enter macro, and create a macro Name this macro: detail.macro "GROUP_RESPONSE_NAME"^MIS.GROUP.RESP.mnemonic, "QUERY_NAME"^ADM.PAT.ccdqr.query, ""^ADM.PAT.ccdqr.mult.seq.no, [EMAIL PROTECTED](ADM.PAT.ccdqr.mult.seq.no)^AAA, AAA @ADM.PAT.ccdqr.mult.response^MIS.GROUP.RESP.element.mnemonic, @MIS.GROUP.RESP.element.response^/MV["D",ADM.PAT.ccdqr.mult.seq.no,FIELD _NO ]} File and exit "FIELD_NO" -> the field number as found on the sorted fields on page three Marc Marc Benoy RN, MS, MBA Clinical IT Project Manager 301.552.8876 (Phone) 301.552.8181 (Fax) [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Doctors Community Hospital 8118 Good Luck Road Lanham, MD 20706 Magic 5.61 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hicks, Karen Sent: Tuesday, August 07, 2007 1:44 PM To: meditech-l@mtusers.com Subject: [MEDITECH-L] Help with NPR I am trying to create a report out of NUR.PC.WORK. I am VERY new at NPR reports - but I am needing to pull in the answer for two queries that are both group response queries - how do I go about getting the group response answer to show on report - and it's also a multiple response query so I may have more than one answer that needs to be displayed. Also, I am looking for a NPR report writer class - does anyone have any good suggestions? Thanks! Karen Karen Hicks, RN BSN Nursing Informatic Coordinator Flaget Memorial Hospital 502-350-5903 [EMAIL PROTECTED] The information contained in this communication is confidential and private and intended only for the use of the addressee. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you received this communication in error, please inform us of the erroneous delivery by return e-mail. Thank you for your cooperation. CONFIDENTIALITY STATEMENT: This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure, use, copying, dissemination, distribution or taking of any action in reliance on the content of this information is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return email and delete this communication and destroy all copies. Thank you.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit http://mtusers.com/mailman/listinfo/meditech-l_mtusers.com To check the status of the meditech-l, visit MTUsers.NET For help, email [EMAIL PROTECTED] Please visit and add information to the MTUsers WikiPedia at MTUsers.NET/mwiki ______________________________________ meditech-l mailing list meditech-l@MTUsers.com http://mtusers.com/mailman/listinfo/meditech-l_mtusers.com