Crystal Report issues

A Crystal formula with an if-then-else statement would work. My preference would be a case statement in the SQL command, however.

I have created a formula like this:
if ({Command_1.EMPLOYEE} in [{Command_1.SUPERVISOR.EMPLOYEE}]) then {Command.POSITION.SUPERVISOR-LNK}="Y"
else {Command.POSITION.SUPERVISOR-LNK}="N"

but  I am getting only "False" even if the employee is a manger. Please help

You are not using the correct syntax--are you trying to assign to a variable?

I have changed a formula like this:
if ({Command_1.EMPLOYEE} in [{Command_1.SUPERVISOR.EMPLOYEE}]) then "Y" else "N", however still I am getting the same eoor. N for all.

The report output will have a list of employee.employee (Unique Number), and that number may not be there in the listed supervisor.employee (The manger of the listed employee will be different employee). Suppose I have an employee 278 and he is a manager, then his employee number should be there in the supervisor.employee field. If the report shows only two records in that the employee 278 is listed and the supervisor for this employee is 416. The report shows the employee.employee(278) and his supervisor.employee(416). Here I need to know how can I check the listed employee(278) is in the supervisor.employee filed. Please advice.

How about this...

IF {Command_1.EMPLOYEE} = {Command_1.SUPERVISOR.EMPLOYEE}
THEN "Y"
ELSE "N"