I am quite a newbie to Crystal Reports so bear with me if I do not provide all the relevant information first off.

Below is my formula:

if {?ARR_DEP} = "A" then
{FLIGHTD_ALL.ACTUAL}
else
if {FLIGHTD_ALL.CANCEL_CODE} = "C" then
""
else
{FLIGHTD_ALL.OFFCHOCKS}

when I attempt to validate the formula advises me that a sring is required.

Any advice or guidance would be much appreciated.



Edited by sandston - 29 Aug 2012 at 11:08pm

If you pass a null it would be a problem, but I bet if you just use totext({Field}) you will be fine.

I would look at database and see if the field is varchar.