Crystal Reports for Eclipse Designer Guide

Formula1+2

  1. Create a new formula called Formula1+2.
  2. Select the Formula tab in the Crystal Reports Designer and type the following formula:
    If {CUSTOMER.CUSTOMER_NAME} [1 to 2] = "Bi" and
    ToText({CUSTOMER.CUSTOMER ID}) [1] = "6" Then
         "TRUE"
    Else
         "FALSE"
    
  3. Place the formula to the right of the @Formula4 field.
  4. Click the Preview tab.
  5. Check the values in the report and compare the fields to see if the field values returned by @Formula1+2 are correct.
    You should see "TRUE" next to each customer whose name begins with Bi and Id begins with 6, and "FALSE" next to all Customer IDs that do not meet this criteria.
If this formula is working correctly, you can create one last formula adding the code from @Formula3 and @Formula4.



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