Crystal Reports for Eclipse Designer Guide

Formula2

  1. Create a new formula called Formula2.
  2. Select the Formula tab in the Crystal Reports Designer and type the following formula:
    If ToText({customer,CUSTOMER ID}) [1] = "6" Then
         "TRUE"
    Else
         "FALSE"
    
    There is an X in the margin. When you move the pointer over the X, you will see the following error message:
    This field name is not known.
    
  3. Correct the formula by replacing the comma (,) in the field name with a period (.).
    When the formula is correct, the X will no longer be displayed.
  4. Place the formula beside the @Formula1 field.
  5. Click the Preview tab.
  6. Check the values in the report and compare the fields to see if the field values returned by @Formula2 are correct.
    You should see "TRUE" next to all customer numbers that begin with 6 and "FALSE" next to all customer numbers that do not begin with 6.



SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
Support services
http://service.sap.com/bosap-support/
Product Documentation on the Web
http://help.sap.com/