problem with formula

[jschill2628]

I have a problem with the following formula

if {IRSCLAIMSA1.SA204} = "Y" then "Env issue Corrected, " else
if {IRSCLAIMSA1.SA205} = "Y" then "Replaced Exit Alarm, " else
if {IRSCLAIMSA1.SA206} = "Y" then "Fall Assessment tbc, " else
if {IRSCLAIMSA1.SA207} = "Y" then "Fall Plan Revised, " else
if {IRSCLAIMSA1.SA208} = "Y" then "Equipment replaced, " else
if {IRSCLAIMSA1.SA209} = "Y" then "Medication review, " else
if {IRSCLAIMSA1.SA210} = "Y" then "PT Assessment, " else
if {IRSCLAIMSA1.SA211} = "Y" then "Reinforce education, " else
if {IRSCLAIMSA1.SA212} = "Y" then "Schd toileting plan, " else
if {IRSCLAIMSA1.SA213} = "Y" then "Exit alrm activated, " else
if {IRSCLAIMSA1.SA214} = "Y" then "Increased Rounding, "


When I put this formula into the details section of my crystal report (Crystal XI) I only get the first description to show up, if I change the else' at the end of each line to an or, then I get an error message saying that a Boolean is required


can someone please help me. The fields are yes no fields.

Thanks!!

 

[IanWaterman]

An If Then else will stop running as soon as it encounters a true.

You will need to build a formula for each condition

eg
//@Env issue
if {IRSCLAIMSA1.SA204} = "Y" then "Env issue Corrected, " else
"Env issue NOT Corrected, "

You can change your else condition to suit.

Ian

 

[jschill2628]

Perfect, so simple, thank you!!