Numeric strings and toNumber function

[Former Member]

Hello,

I'm having problems with Crystal Reports for Eclipse when using some reports.

The problem comes with reports that contain toNumeric function with a data that is get from the database, it gives an error that says the string is non-numeric even if it is a numeric string. The formula in the reports looks like this:

...
numberVar cantidad_dias := ToNumber({MYVIEW.NumericText});
...

I know that using isNumeric condition it works well, but it works well too when using Crystal Reports 2008 without any condition, so I think it should work for Crystal Reports for Eclipse and return error only in the case that the string isn't numeric. Is it a bug?

Thanks

[Former Member]

In my previous post I said that the error happens at assignation time, now, I have noticed that isn't true, the error appears if in the formula is an assignation, but the error happens at ToNumber function.

For example, as I have said, the following formula is correct:

ToNumber({MYVIEW.NumericText});

but the following formulas return error:

stringVar str := "123";
ToNumber({MYVIEW.NumericText});

or

ToNumber({MYVIEW.NumericText});
stringVar str := "123";

returning {MYVIEW.NumericText} is non-numeric string in both cases.