String Length less than 0 or not an integer

[glasper]

I'm using Crystal Reports 8.5 to remove the trim data that looks like:

MicroSwitch (oc:Stephen M. Johnson)

The formula that I'm using is:

Trim (left({CONTHIST.REF}, Instr({CONTHIST.REF},"(")-1))

The problem is that when I run the report, I get the error String Length less than 0 or not an integer. What am I doing wrong?

 

[dgillz]

You have a null field, and then you are subtracting 1 from it. So test for nulls first:

if isnull({CONTHIST.REF}) then "" else
Trim (left({CONTHIST.REF}, Instr({CONTHIST.REF},"(")-1))


Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[PatriciaObreja]

There might be records that do not contain "(":

If Instr({Customer.Customer Name}, "(") > 1 Then
    Trim (left({Customer.Customer Name}, Instr({Customer.Customer Name}, "(") - 1))
else
    Trim ({Customer.Customer Name})

-------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium