What is the syntax for a CASE statement in Crystal XI
I'm having difficulty locating documentation for the use of CASE statements in Crystal syntax. My database administrator does not allow me to write SQL expressions so I need to covert the SQL below to Crystal Syntax. Can anyone help me? Thank you very much!!
WHEN projects.ProjType like 'S%' then 'Shopping Center'
WHEN projects.ProjType like 'I%' then 'Industrial'
WHEN projects.ProjType like 'O%' then 'Office Building'
Here is the syntax:
case is like 'S%' : "'Shopping Center"
case is like 'I%' : "Industrial"
case is like 'O%' : "Office Building"
default : "Other"