CalgaryCR9
Technical User
I'm using Crystal Reports 9.
What I want to do is basically an if statement, but am having problems with syntax.
if {SERVICE_CALL_EVENT.SVC_CALL_EVENT_TYPE}="ESCALATE_VEND"
then {SERVICE_CALL_EVENT.ACTION_DT}
else "No Escalation"
When I do the above, I get error "A date-time is required here". I understand the error, but would still like to print my string.
SERVICE_CALL_EVENT = table
SERVICE_CALL_EVENT.SVC_CALL_EVENT_TYPE = data field
SERVICE_CALL_EVENT.ACTION_DT = data field
"ESCALATE_VEND" = one potential table entry
What I want to do is basically an if statement, but am having problems with syntax.
if {SERVICE_CALL_EVENT.SVC_CALL_EVENT_TYPE}="ESCALATE_VEND"
then {SERVICE_CALL_EVENT.ACTION_DT}
else "No Escalation"
When I do the above, I get error "A date-time is required here". I understand the error, but would still like to print my string.
SERVICE_CALL_EVENT = table
SERVICE_CALL_EVENT.SVC_CALL_EVENT_TYPE = data field
SERVICE_CALL_EVENT.ACTION_DT = data field
"ESCALATE_VEND" = one potential table entry