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!
Do more with
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
If {table.customer}="XXX" and {table.keyword} like "*SP*" then false else true
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
Premium Content
You need an Expert Office subscription to comment.Start Free Trial