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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi thanks for still posting that comment as I didnt know that fact.
Thank you
Thank you
That is why I posted, to explain the issue behind the error message
mlmcc
mlmcc
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