Suppressing item with "-" 1

[lbizzell]

Hello again,

I'm running Crystal 9 with SQL. I am pulling data from {itemwhse.item}. The subassembly part has an "-" some where in the item and the item can be various lengths. How do I supress the subassembly parts with "-"?

Example:
L7050089
24005389-002
1930015
5011
C1550341-002

Results:
L7050089
1930015
5011

Thanks!
Laurie

 

[synapsevampire]

You don't need to suppress them, you can eliminate them from the recordset returned by using:

Report->Selection Formulas->Record:

not({table.field} like "*-*")

-k

 

[kskid]

You can add the following to your record selection criteria

instr({table.field},"-") = 0

-LW

 

[lbizzell]

synapsevampire & kskid,

Thanks so much for your quick response. The formula worked great and I appreciate all the help. Crystal is starting to make more sense now, so I shouldn’t have to ask as many questions. Thanks again.

Thanks-
Laurie

 

[synapsevampire]

The instr method won't pass the SQL to the database, use the LIKE method for better performance.

-k

 

[kskid]

You are right! Forgot to double check that.

A Star performance

-LW