Crystal V8.5

[Gagsy]

I am tryig to use the Not Like statement but receive the error "The remianing text does not apear partof the formula".

I need to be able to hide a field if the value is not like"1-1-82*"

Would appreciatre any help on this

 

[GJParker]

use this in the suppression formula

Left({MyTable.StringField},6) <> "1-1-82"

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[midearth]

Posting your entire formula would help. However, right click on the field in your report; select format field; in the common tab, click on x+2 beside suppression and try entering the formula:

not({yourfield} startswith "1-1-82")

That should do the trick.

 

[Gagsy]

Thanks for the samples.

The Not(X Startswith Y) worked great.

I had earlier ttried the "Not Startswith" syntax.

Thanks again - I can go home now.

Cheers
Gagsy