How do I stop these talk emails? ________________________________
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thom C.Blackwell Sent: Tuesday, February 20, 2007 4:50 PM To: [email protected] Subject: RE: [Talk] How can I append text to a report column? Greetings, You can "append" using. D("Error")=D("Error") & " " & "My New content" Regards, Thom Thom C. Blackwell Product Manager Boston Software Systems (866) 653-5105 ex 807 www.bossoft.com LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately, then delete this message and empty from your trash. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of pbrungar Sent: Tuesday, February 20, 2007 4:46 PM To: [email protected] Subject: [Talk] How can I append text to a report column? I'm writing a script and using the Report feature in BW to report back any errors. I went into the Configure Report routine and added all the fields I will be using in the script and also added two other fields called "Errors" and "Warnings". In my script, I am writing the warnings and errors I encounter back to these columns. Lets say my data looks something like this: PtName, ProcedureCode1, ProcedureCode2, ProcedureCode3, ProcedureCode4, ProcedureCode5, John Doe, 251000,251304,251567,251796,251506 Jane Doe, 251678,251345,251765,251667,251677 Okay...so I'm entering the first procedure code and I get this error: "Error - Procedure Code Not Defined" I want to write that error to my report and continue....so I use this command: D("Errors") = "Procedure Code 1 not defined." Then I continue on with the script and I get this error when I get to Procedure Code 4 I get this error: "Error - Procedure Code Not Defined" So I write the error to the report like this: D("Errors") = "Procedure Code 4 not defined." The problem with this is that the Procedure Code Error for Procedure Code 4 overwrites the Procedure Code Error for Procedure Code 1. Is there any way to just append these together? I know I could create multiple fields in report configuration tool to accommodate all the errors, but is just a simplified version of the script I'm doing, and being able to append the text would work much better for me. Any idea on how to do this? Thanks in advance! Paul Brungardt Clinical Analyst Hays Medical Center 785-623-2196
