troycsl
asked on
Selection Formulas and Wild Cards
Hey Everyone,
I'm working in Crystal Reports 10, and I'm having some trouble with a selection formula using a wild card. I've tried a number of variations on the same formula, but can't get it to sort out the information properly...
{CI_Item.ItemCodeDesc} <> "Disco*"
The intent being to sort OUT any item with a description "Discontinued".
Is there a way to use wildcards in selection formulas like I'm aiming for above?
I'm working in Crystal Reports 10, and I'm having some trouble with a selection formula using a wild card. I've tried a number of variations on the same formula, but can't get it to sort out the information properly...
{CI_Item.ItemCodeDesc} <> "Disco*"
The intent being to sort OUT any item with a description "Discontinued".
Is there a way to use wildcards in selection formulas like I'm aiming for above?
{CI_Item.ItemCodeDesc} not like "Disco*"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Worked like a charm! I also might add in that it's case sensitive! xD