Link to home
Start Free TrialLog in
Avatar of Sandston04
Sandston04

asked on

Crystal Reports HELP

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.
ASKER CERTIFIED SOLUTION
Avatar of Sandston04
Sandston04

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mike McCracken
Mike McCracken

Issue - A formula can only return 1 type of value. (string, number, etc)

Apparently some of the fields you return are strings and others are non-strings (dates, numbers, etc.)
Crystal looks at the first value you return and all the rest must match it.

mlmcc
Avatar of Sandston04

ASKER

Hi thanks for still posting that comment as I didnt know that fact.

Thank you
That is why I posted, to explain the issue behind the error message

mlmcc