Marc, In that case, I would work out of the mis.doctor segment (the main one), and set up a macro to review all the pins for each doctor via a DO loop, looking for the one you want.
It would be something like this: xx.select DAT=PINT LEN=1 VAL=%MIS.DOC.DICT.zcus.name.of.report.M.select(mnemonic) The macro "select" would be something like: A^mnemonic, 1^SEL, [EMAIL PROTECTED](ins.pin),[EMAIL PROTECTED]"NPI" ""^SEL}}, SEL; Then, put the xx.select on page 2 as a select variable: xx.select EQ 1 I've not done DO loops for a while, so there are probably one or more syntactic errors there, but you get the idea... Douglas B. McGaw Newman Regional Health 1201 W. 12th Ave. Emporia, KS 66801 [EMAIL PROTECTED] 620-343-6800 x 1130 fax: 620-340-6799 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Benoy, Marc Sent: Friday, February 09, 2007 7:19 AM To: Joe Cocuzzo; Cliff Vaux; Kathy Armstrong; Frazier, Angie; [email protected] Subject: RE:NPR - How to find Data in a Dictionary that Does NOT Exist Hello all, Thanks for all your replies; however I am looking for those physicians that do "not" have a certain NPI pin. Therefore on page two I have to have a select where I enter the INS pin that I am looking for and loop this through all the possible pins a provider may have. The providers that do not have this INS pin, these are the ones I am looking for. Example: Doctor A MC-UPIN 123 MDC-UPIN 456 NPI 789 Doctor B MC-UPIN 111 MDC-UPIN 222 If I am looking for those physicians with no "NPI", then Doctor B should be returned. Thanks for your time, Marc Marc Benoy RN, MS, MBA Clinical IT Project Manager 301.552.8876 (Phone) 301.552.8181 (Fax) [EMAIL PROTECTED] Doctors Community Hospital 8118 Good Luck Road Lanham, MD 20706 Magic LIVE 5.4 and TEST 5.4 & 5.61 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. -----Original Message----- From: Joe Cocuzzo [mailto:[EMAIL PROTECTED] Sent: Friday, February 09, 2007 8:07 AM To: Benoy, Marc; [email protected] Subject: RE: NPR - How to find Data in a Dictionary that Does NOT Exist Not clear whether you want to write a report that picks the doctors that do not have a particular insurance pin, or do not have any of several selected insurance pins. The general solution is to write the report in the main segment, and have a computed select field that tests for the existance of the data in the child segment, and returns a true if there is no data in the child segment. In the simpler case where you want to see if MC-UPIN is filled in for a doctor: Set up computed select field on page 2 xx.ck EQ 1 Set up that field as follows xx.ck DAT=INT LEN=1 [EMAIL PROTECTED]"MC-UPIN"] "";1} If you wanted to make the report flexible, so that the user could enter the pin mnemonic to check: Have an IG select on Page 2 to collect the desired pin to check: MIS.INS.PIN.mnemonic IG PIN TO CHECK xx.ck EQ 1 DAT=INT LEN=1 [EMAIL PROTECTED] "";1} Joe Cocuzzo Vice President NPR Services Iatric Systems, Inc. Phone/Fax: (978) 805-4115 Email: [EMAIL PROTECTED] Web: www.iatric.com -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Benoy, Marc Sent: Friday, February 02, 2007 1:10 PM To: [email protected] Subject: NPR - How to find Data in a Dictionary that Does NOT Exist Hi, I am having a problem with returning data from a dictionary when that incidence does not exist. Can you help? More specifically, I have been asked to write a report that gives me those physicians that do not have a certain insurance pin and number. I am able to return physicians that do have a certain pin but not those that do not. Mistakenly, I wrote first the report with a select operator of NE but this simply leads to the report not to print the PIN and number for those physicians that do have it. Example: Our INS contains three choices: MC-UPIN, MCD-UPIN, and NPI. In the MIS Provider dictionary a provider may be assigned any of the above (multiple group response). How do I retrieve those providers that "do" not have one or many of these, e.g. which provider does not have the NPI pin. Thanks, Marc Marc Benoy RN, MS, MBA Clinical IT Project Manager 301.552.8876 (Phone) 301.552.8181 (Fax) [EMAIL PROTECTED] Doctors Community Hospital 8118 Good Luck Road Lanham, MD 20706 Magic LIVE 5.4 and TEST 5.4 & 5.61 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 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
