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
