Crystal Report Formula Error

[Meg09]

Hi,

I am trying to write an if/then statement in crystal reports, however I keep receiving an error message stating that a boolean is required. Here is my formula:

if {time_project_tasks.task_code} in ["WORK"] then ("003652252-070196") Or
if {time_project_tasks.task_code} in ["MGTGS"] then ("003652252-11111")
else ("0")

The error message appears right before the string of numbers. Any help would be appreciated.

 

[lbass]

if {time_project_tasks.task_code} = "WORK" then
"003652252-070196" else
if {time_project_tasks.task_code} = "MGTGS"
then "003652252-11111"
else "0"

Use an "else" and eliminate unnecessary parens and brackets. However, it sounds like you might be creating this in the wrong place. You should be creating a formula like this in the field explorer->formulas->new.

-LB

 

[Meg09]

I had the formula written in the right spot, just not the correct format! Thank you for your help