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]

All the returned values are true, so I think that there's no problem with the database values.

It's strange, because there's no problem if the formula finishes like this:

toNumber({MYVIEW.NumericText})

but the error appears if the formula contains something like this:

numberVar myNum := ToNumber({MYVIEW.NumericText})

Thanks

[ted_ueda]

That's a very interesting issue.

If you enable Log4J logging, does that tell anything as to what's causing the issue?

What happens if you do something really strange to combat the strangeness, like ToNumber(CStr(ToNumber({MYVIEW.NumericText}))), i.e., force Crystal Reports Java to format what it converted to a number to a string to a number?

Sincerely,

Ted Ueda