HI, I wish to report from 2 fields in my database
Q1. Was there a delay to starting Y/N.
Q2. Is a multi value field 1-5 for different delay reasons.(String).
In my report I need
if Delay = Y and Reason is “3” then 1
if Delay = Y and Reason is not “3” then 2
if Delay = N then leave blank
I tried:
if {delaystart} = "Y" and { delayreas} like "*2*" then 1
else
if {ech_0023.delaystart} = "Y" and not({ech_0023.delayreas} like "*2*") then 2
else
Numbervar Target; if {ech_0023.delaystart} = "N" then ""
All my answers are coming up blank even when it should be one or 2