1. On the upper toolbar, click on Report > Selection Formulas > Record
  2. Enter the formula: inStr({CnPrProp_1_Proposal_Name}, "XYZ") = 0
  3. Click Save and Close
  4. Refresh (F5)  the report
Note: The InStr function returns the position of the first occurrence of one string within another. If it finds the text, it returns the position of the first occurrence. If the text does not exist in the field, it will return 0. In this Select Expert formula example, we want the inStr() function to return 0 because that would imply that the text value does not exist in the Proposal Name field.