I would like to filter some of the data in cyrstal report if the data falls into specific condition. I tried to create formula to do this, however, no success so far. I appreciate if someone can help me on this.
I would like to exclude data if the following is true:
If the customer field is xxx and keyword field includes any word SP, then, I would like to exclude the data from crystal report.
How I can create formula and use it in Select Expert to filter out those data from the report?