I am working on a report using a DB with a fields that I cannot change.
I am querying a Oracle DB field that when filled by the program places characters in the fields that cause crystal report to stop reading (whatI call invalid). The field is some type of extended memo that has a max of 1300 characters (or lot anyways)
When I try to display this field currently in my report the data gets cut off at the first of these invalid characters
(I am sure that that all the data available is not displayed)
I am looking for a procedure in the report to allow me while reading the field replace any non A-Z,a-Z,0-9 characters with a space and allow the entire data string to be displayed.
Any ideas?
I am querying a Oracle DB field that when filled by the program places characters in the fields that cause crystal report to stop reading (whatI call invalid). The field is some type of extended memo that has a max of 1300 characters (or lot anyways)
When I try to display this field currently in my report the data gets cut off at the first of these invalid characters
(I am sure that that all the data available is not displayed)
I am looking for a procedure in the report to allow me while reading the field replace any non A-Z,a-Z,0-9 characters with a space and allow the entire data string to be displayed.
Any ideas?