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]

It tells that {MYVIEW.NumericText} isn't a numeric string, but I know it is numeric string.

I've tried what too you said about ToNumber(CStr(ToNumber({MYVIEW.NumericText}))) and it returns the same error again in the cases that ToNumber({MYVIEW.NumericText}) returned error.

Thanks

[ted_ueda]

I really want to know specifically what string is causing that error...

How about Log4J? Does that tell you anything?

Sincerely,

Ted Ueda