http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5017 WebApr 25, 2014 · Sastry Duvvuri. Apr 28, 2014 at 11:25 AM. Hi. May be the string which you are trying to disply is a numeric along with spaces. I removed spaces using Trim () and converted to number. -Sastry. Like 1. Alert Moderator. Add a Comment.
The string is non-numeric error message SAP Community
WebIn Crystal Reports designer, go to the design tab of the report, and edit the formula field that convert the text to number. In the Formula Editor, use the function IsNumeric, as … WebFeb 4, 2010 · So you might have to do some formatting or the text before you check if it is numeric. To be safe maybe try StringVar myNumericString myNumericString := Replace( {table.field}," ",""); myNumericString := Trim(myNumericString); // Above will do this but just for fun If NumericText(myNumericString) then ToNumber(myNumericString); Else 0; list of sag award winners
How to fix the error "The string is non -numeric" in crystal …
WebOct 19, 2011 · Sometimes Crystal tells you the record in error in the Formula Editor when the report is ran (in CR10) - you could use this to confirm. In short, I believe Crystal is telling you the data found cannot be converted to a number as no number exists in the field for that record. Hope this helps. Cheers! Mike WebApr 26, 2001 · If your formula hits the second date it attempts to convert '1/' to a number and you get the infamous "The string in non-numeric" error message. Try converting your Date Time values into String within your Report Options Form (File Report Options). WebAug 14, 2012 · It looks overly-complex, but it actually simplifies reports that require numerous fixed-length fields. As I develop the report, I can copy-paste this code to a new formula, change the number of spaces to match the … im lakhop 16 porta westfalica