This post is in response to recent query – how many else if statements can crystal report have?

We are re-referencing our previous post as follows;

This example is based on customer table in Northwind database
The “if then else works well when condition leads to one of two settings”. Although it can handle multiple potential settings through nested “if statements”, creating this type of complicated formula can be avoided by using Select Case Statement
———————

if {Customers.Country} in
["germany","france" ,"Finland","denmark","Austria","belgium",
"Italy","Poland","Norway","spain","Portugal","Sweden","Switzerland",
"UK"] then “Europe”
Else if {Customers.Country} in
["Argentina","Brazil" ,"Mexico","Venezuela" ] then “South America”
Else if {Customers.Country} in
["USA","Canada" ] then “North America”