Formula that used to work in CR 8.5 1

[EdRev]

I have this formula that used works with CR 8.5, now that I upgraded to 10.0, it does not work anymore.

Down2Mem = "S1234 Count"

if right(left({Down2Mem},instr({Down2Mem}," ") - 1),1) = "S" or {Down2Mem} startswith "M" then
"Enter"

Now, I am getting this error:

Crystal Reports ActiveX Designer (0x8004749E) Before Export. String length is less than 0 or not an integer.

I know th problem is in this section of the code:

instr({Down2Mem}," ") - 2),1)

Any help will be greatly appreciated.

 

[Madawc]

What I'd do is break up the formula into several separate formulas. That way, if you get "String length is less than 0" then you can set it to zero and use that value in the main formula.

I'd assume that this was always happening but that Crystal 8.5 tolerated it. I'm on 8.5 myself, but I've found similar problems with other software upgrades.

Madawc Williams (East Anglia, UK)