SAP Knowledge Base Article - Preview

1213922 - How to convert a string to a number in Crystal Reports?

Symptom

  • How to convert a text to a number? 
  • How to convert a string field to a numeric field in Crystal Reports?   
  • A database field is defined as string data type, contains numeric characters. To perform calculations or summaries such as a sum or an average, the field must be defined as a number data type. How to convert a string field containing numeric characters to a number field in Crystal Reports?


Read more...

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
        
  • SAP Crystal Reports for Enterprise 4.1
  • SAP Crystal Reports for Enterprise 4.2
  • SAP Crystal Reports for Enterprise 4.3

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020

Keywords

NUMBER TEXT ALPHANUMERIC NON NUMERIC CONVERT CHANGE ADD DATA TOTAL VAL TONUMBER Crystal Reports Format numeric text Err Msg: "Non-Numeric Value" Err Msg: "The string is non-numeric." , c2010092 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.