Startswith record selection formula

[paulosinuk]

Hi,

I need to use a 'startswith' formula to exclude some dead records. I have a record selection formula as follows:

not({PRODUCTS.ProductName}) startswith "z"

which I need to alter to exclude the following exceptions
Zeppelin
Zallverlin
Zenskin

Any ideas on how to achieve this in a record selection formula.

Ta

Paulos

 

[dgillz]

You already have the formula perfectly stated in the proper syntax. This works in Crystal V7, 8 and 8.5, I do not know about older versions.

If you are getting an error message with this formula, please cut and paste the exact message to the forum. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[paulosinuk]

Sorry I think the phrasing of the questions was a little out.

I am excluding thousands of records that start with 'Z' however it is also excluding three products that need to be in the report as well.

These records are being excluded and shouldn't be.
Zeppelin
Zallverlin
Zenskin

I need a formula that says 'exclude all records starting with 'z' unless the product is Zeppelin, Zallverlin or Zenskin.

 

[dgillz]

My fault, I misread the post.

change you formula to:

If ({PRODUCTS.ProductName}) in ["Zepplin","Zalverllin","Zenskin"] then TRUE else not({PRODUCTS.ProductName}) startswith "z"
Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com