Crystal Reports for Eclipse Designer Guide

Formula3

  1. Create a new formula called Formula3.
  2. Select the Formula tab in the Crystal Reports Designer and type the following formula:
    If {CUSTOMER.CUSTOMER_NAME} [1 to 2] = 'Ro" 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:
    The matching ' for this string is missing.
    
  3. Correct the formula by changing the single quote (') before Ro to a double quote (").
    When the formula is correct, the X will no longer be displayed.
  4. Place the formula adjacent to the @Formula2 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 @Formula3 are correct.
    You should see "TRUE" next to all Customer names that begin with "Ro" and "FALSE" next to all Customer names that do not begin with "Ro".



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