SAP Knowledge Base Article - Public

1379673 - Error in formula CHECK_NUM:'toNumber({Command.CHECK_NUM})'. The string is non-numeric. Details:errorKind.

Symptom

  • When crystal report with formula ‘CHECK_NUM’ is exported to MS Excel(data only) from Crsytal Reports Designer. 
  • Also when same report is exported to MS Excel/Excel(data only) from Infoview.

Environment

  • BusinessObjects Enterprise XI 3.x
  • Crystal Reports 2008 SP x
  • MS Excel 2007

Cause

  • CHECK_NUM filed is defined as string at the database and in CR Designer it has been created as a formula on CHECK_NUM filed and it converts the field to NUMBER.

  • When we browse the data in CR Designer for the filed CHECK_NUM then we will find the numbers along with the strings.
    For example:
    777169
    782458
    .
    .
    .
    989346
    Pqr
    989732
    xyz
  • This is the reason when we export the report to excel then excel can not covert STRING to a NUMBER.

Resolution

  1. Replace the field [CHECK_NUM] with the formula ['toNumber ({Command.CHECK_NUM})] in the report.
  2. Then refresh the report.
  3. Report will export to excel successfully without any error.

Keywords

CHECK_NUM,crystal,errorkind , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V1