Filtering some entries in crystal report

SFtoto
SFtoto used Ask the Experts™
on
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!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I'm not sure I really understand this..."keyword field includes any word SP"- maybe this is what you want in the record selection rule..

If {table.customer}="XXX" and {table.keyword} like "*SP*" then false else true
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
That should work.  It this is part of a larger formula either make that the last part or put ( )

Your current formula
AND
If {table.customer}="XXX" and {table.keyword} like "*SP*" then false else true

the other way is

(If {table.customer}="XXX" and {table.keyword} like "*SP*" then false else true )
AND
Your current formula

The ( ) around it ensure it is interpreted as 1 piece

If you use
it like

If {table.customer}="XXX" and {table.keyword} like "*SP*" then false else true
AND
Your current formula

The True AND Your current formula is interpreted as 1 part and the false is interpreted by itself.

mlmcc

Author

Commented:
Thank you both. It worked!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial