1. Open the report in Crystal Reports
  2. Go to View > Field Explorer
  3. Right-click on Formula Fields and select New
  4. Enter a name for the formula and click OK
  5. Enter a formula similar to the one below:
    Mid({FieldName}, x)

    Where x is the starting position of the text that you want.
    For example: Mid({CnPrProp_1_Status}, 5)
    The Mid function will extract a portion of the field, starting at a specific character. This formula will return Approved for a - Approved because the A in Approved starts at position 5.

  • Click Save and Close
  • Insert the formula into the report