WebJan 5, 2011 · The formula didn't like when MLIDDT field contained a '0' instaed of a real date. I think this cuased the formula to attempt to pass an empty string as 'month' parameter for the DATE () function, which is when it was expecting a numeric value. if not ISNULL ( {command.MLIDDT}) and {COMMAND.mliddt} > 0 then. 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;
How do I convert a string to a number in Crystal Reports?
WebExpotential numbers displays in MS Excel. When exporting a report to CSV format from Crystal Reports, that contains a database field or formula field of data type string that contains a value like: 2E158, the string value is read as being a numeric field and returned as a exponential value like: 2.00E+158 in MS Excel. 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 alive now im dead
The string is non-numeric error message SAP Community
http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5017 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 WebTopic: 'The String is non-numeric' issue. Posted: 15 Dec 2008 at 2:55pm. Hi, I'm having an issue getting some very simple Crystal XI reports up and running on BOXI. The reports … im alive lyrics helloween