Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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!!

Select

CASE

WHEN projects.ProjType like 'S%' then 'Shopping Center'

WHEN projects.ProjType like 'I%' then 'Industrial'

WHEN projects.ProjType like 'O%' then 'Office Building'

ELSE 'Other'

END

from projects

Former Member
Former Member replied

Here is the syntax:

select {projects.ProjType}

case is like 'S%' : "'Shopping Center"

case is like 'I%' : "Industrial"

case is like 'O%' : "Office Building"

default : "Other"

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question