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]

I get the same error declaring, assigning and returning everything all in once, or doing it in three steps. I also have tried with uppercase and lower case and once again the same error appears when doing the exportation.

I think that it happens at the time of assignation, because only appears when using the assignation.

I have tried to do the assignation to a string with CStr(ToNumber({MYVIEW.NumericText})), based on Ted's previous advice, always the same error.

And also with:

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

Thanks