All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ======================================
Hello Brian, That would hardcode the list into the selection. I don't believe that Kevin was asking for that. Original request: Hello L'ers, I am trying to write a report in PHA.RX to search through active orders and list those entered by a specific group of users (i.e. night pharmacists). I am sure it is possible to create a macro to search the data field enter.user for a group of 10 users, but I am not sure how to write it. I know I can simply put the names in the Selection criteria, but I am hoping a macro would speed up the compile time. Any assistance would be greatly appreciated. Thank you! Kevin (Knight) Having a list of names for selection lookup can only be done in MAGIC or C/S 5.5 or later, and is done via the Edit Picture routine. No idea on the specifics in this case, but that is where you can do custom lookups. This wouldn't decrease the runtime of the report however, which seems to be the whole point of Kevin (Knight)'s email here. What Kevin (from rphinformatics) proposes in the other reply is a good idea also, and would simplify the selection. It also wouldn't speed up the report though. As far as speeding up the report, the only way to do that is using the correct index. That is where I would concentrate efforts. This might not actually have anything to do with user selection. Thank you, Mitch Lawrence Senior Applications Analyst - Advanced Report Writer General Financials Support CHRISTUS Information Management Tel: 361.881.3408 Fax: 361.888.6117 Mob: 361.549.8456 AIM: a1d13 MSN: [EMAIL PROTECTED] [EMAIL PROTECTED] If someone has "Made your day", send them a Spirit Buck! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen, Brian Sent: Thursday, August 24, 2006 6:45 AM To: Kevin Knight; MEDITECH-L Subject: RE: [MEDITECH-L] NPR RW: Macro to Seach for User (KK) All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ====================================== Many ways to skin this cat... I usually setup a start macro to load the list and select from that list. To do it: Create a macro called "start" and enter the list of names in the following fashion: 1^/LIST["USERMNEMONIC1"], 1^/LIST["USERMNEMONIC2"], 1^/LIST["USERMNEMONIC3"], 1^/LIST["USERMNEMONIC4"], 1^/LIST["USERMNEMONIC5"], 1^/LIST["USERMNEMONIC6"], 1^/LIST["USERMNEMONIC7"], 1^/LIST["USERMNEMONIC8"], 1^/LIST["USERMNEMONIC9"], 1^/LIST["USERMNEMONIC10"] The add a selection on enter.user with an operant of LI (for List) and enter /LIST as the value/prompt. Then from the footnote section (on Page 3) enter AL START start And translate. Thanks, Brian -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Knight Sent: Tuesday, August 22, 2006 3:28 PM To: MEDITECH-L Subject: [MEDITECH-L] NPR RW: Macro to Seach for User (KK) All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ====================================== _______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l _______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
