Thank you, this report did work but if you are Client Server it will
crash using the $RN in the macro, instead you have to replace that with
%Z.random.number and it works great.
Brandon Gauntt
Director - Information Services
Hopkins County Memorial Hospital
903-439-4054 Office
903-348-2112 Cell
________________________________
From: McGaw, Douglas [mailto:[EMAIL PROTECTED]
Sent: Monday, April 09, 2007 8:17 AM
To: Gauntt, Brandon K.; meditech-l@MTUsers.com; [EMAIL PROTECTED]
Subject: RE: [MEDITECH-L] random SSN report for random drug screen
Brandon - try this report. I recently had a similar request and this
was the response. The macro contains the randomization logic:
Douglas B. McGaw
Newman Regional Health
1201 W. 12th Ave.
Emporia, KS 66801
[EMAIL PROTECTED]
620-343-6800 x 1130
fax: 620-340-6799
________________________________
From: meditech-l@MTUsers.com [mailto:[EMAIL PROTECTED] On Behalf
Of Gauntt, Brandon K.
Sent: Friday, April 06, 2007 7:56 AM
To: meditech-l@MTUsers.com; [EMAIL PROTECTED]
Subject: [MEDITECH-L] random SSN report for random drug screen
I have a request to create a report that will randomly select x number
of employee social security numbers for random drug screening. I
actually do not have the slightest idea as to how to write anything in
NPR that would randomly pick a field every time it is ran. Does anyone
out there have any type of report that would do something like this they
would be willing to share? I would appreciate any help with this.
Brandon Gauntt
Director - Information Services
Hopkins County Memorial Hospital
903-439-4054 Office
903-348-2112 Cell
This e-mail, facsimile, or letter and any files or attachments
transmitted with it contains information that is confidential and
privileged. This information is intended only for the use of the
individual(s) and entity(ies) to whom it is addressed. If you are the
intended recipient, further disclosures are prohibited without proper
authorization. If you are not the intended recipient, any disclosure,
copying, printing, or use of this information is strictly prohibited and
possibly a violation of federal or state law and regulations. If you
have received this information in error, please notify Baylor Health
Care System immediately at 1-866-402-1661 or via e-mail at
[EMAIL PROTECTED] Baylor Health Care System, its subsidiaries,
and affiliates hereby claim all applicable privileges related to this
information.
This e-mail, facsimile, or letter and any files or attachments transmitted with
it contains information that is confidential and privileged. This information
is intended only for the use of the individual(s) and entity(ies) to whom it is
addressed. If you are the intended recipient, further disclosures are
prohibited without proper authorization. If you are not the intended recipient,
any disclosure, copying, printing, or use of this information is strictly
prohibited and possibly a violation of federal or state law and regulations. If
you have received this information in error, please notify Baylor Health Care
System immediately at 1-866-402-1661 or via e-mail at [EMAIL PROTECTED] Baylor
Health Care System, its subsidiaries, and affiliates hereby claim all
applicable privileges related to this information.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
To subscribe or unsubscribe to the meditech-l, visit MTUsers.NET.
To check the status of the meditech-l, visit MTUsers.NET.
For help, email [EMAIL PROTECTED]
Visit the MTUsers WikiPedia at MTUsers.NET/mwiki
______________________________________
meditech-l mailing list
meditech-l@MTUsers.com
http://mtusers.com/mailman/listinfo/meditech-l
