Link to home
Start Free TrialLog in
Avatar of SFtoto
SFtoto

asked on

Filtering some entries in crystal report

Hi,

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?

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SFtoto
SFtoto

ASKER

Thank you both. It worked!