Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 421
  • Last Modified:

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?
0
troycsl
Asked:
troycsl
1 Solution
 
peter57rCommented:
{CI_Item.ItemCodeDesc} not like "Disco*"
0
 
mlmccCommented:
Actually it should be

not ({CI_Item.ItemCodeDesc} like "Disco*" )

mlmcc
0
 
troycslAuthor Commented:
Worked like a charm! I also might add in that it's case sensitive! xD
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now