Take a look at your Detail segment and Index combination. According to your sort fields, the last one is INSURANCE, meaning that a D line will repeat for every single insurance for each record; hence you are getting more than 1 record for patients with more than one insurance. Monica
Monica Summers System Education Consultant - NPR, OPS, Security IT&S Learning Solutions HCA Information Technology & Services 490 Metroplex Nashville TN 37211 t: 615-344-6962 f: 615-344-4144 e: [EMAIL PROTECTED] w: www.hcahealthcare.com ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Gauntt, Brandon K. Sent: Tuesday, March 20, 2007 3:49 PM To: [email protected]; [EMAIL PROTECTED] Subject: [MEDITECH-L] BAR report question I have a report that I wrote for a bad debt collection agency that should be straightforward to download weekly for one agency. The problem I have is that the same patient prints over and over again. I have attached the source code hoping that I am just missing something very simple. I am hoping that someone can help point out my mistake. Any help would be appreciated. Thanks, Brandon Gauntt Director - Information Services Hopkins County Memorial Hospital 903-439-4054 Office www.hcmh.com <http://www.hcmh.com/> 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.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
