I am trying to do a nested if statement in Crystal Reports.
I have 3 company names based on a company id, so if id=1 then "company A" if id=2 then "company B" else "company C" but I can't get it to work, I get an error when saving the formula that "The remaining text does not appear to be part of the formula" and it highlights everything after my first variable. Can anyone show me the proper syntax for this formula. I am completely new to sql
LVL 102

Expert Comment

by:Mike McCracken
You should really ask this as a question

If  test then result
ELSE if test then result
Else result

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month