A couple notes that should help you out re Crystal formulas:
You can select from a list of items using the IN operator:
{Customer.Country} IN ["England", "USA", "Canada"];
And if you want to use wildcards, you can use IS LIKE:
{Person.LastName} IS LIKE '*Jones*';
I have the full Crystal syntax documented with syntax examples in my Encyclopedia book. You can find out more about my books at
Amazon.com
or reading the
Crystal
Reports eBooks online.