Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
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!
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!
Asked:
2 Solutions
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
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
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
If {table.customer}="XXX" and {table.keyword} like "*SP*" then false else true