Regional Grouping in Report

[gc6294]

I'm looking for the best way to format a formula in Crystal.

Would like to say something like this

if @STATE_COUNTRY='France' or 'Germany' or 'Hungary' etc... Then 'Europe'
if @STATE_COUNTRY='JAPAN' or 'China' etc then 'Asia'

What's the best way to format a formula like this - I seem to get syntax errors....

 

[synapsevampire]

Try:

if @STATE_COUNTRY in ["France","Germany","Hungary"] then "Europe"
else
if @STATE_COUNTRY in ["Japan","China"] then
"Asia"
...etc...
else
"Unknown"

Use a final catch all as well as in my unknown example.

Also you are referencingna formula (@STATE_COUNTRY), we don't know what's in that formula, use the database field directly, or include what's in that formula field in your post.

If it still fails, post the formula you tried, and the exact error.

-k