Visual Basic Crystal Reports

Author

formula editor

buzzandbeyond

2007-02-13, 8:15 am

hi

I currently have a formula with works well
(IF {F_TASKS.TA_FINISH_DATE} > {F_TASKS.TA_EST_DATE} THEN "LATE" ELSE
"On Time" )

I am looking to add the following to this
(IF {F_TASKS.TA_LOC} > "*" then "Reason")

at present I am only able to return either one or the other, not both
results. Is it possible to show all three?

cheers

Briscobar

2007-02-13, 7:14 pm

"buzzandbeyond" <david.nixon@ubs.com> wrote in message
news:1171367021.108897.51460@h3g2000cwc.googlegroups.com...
> hi
>
> I currently have a formula with works well
> (IF {F_TASKS.TA_FINISH_DATE} > {F_TASKS.TA_EST_DATE} THEN "LATE" ELSE
> "On Time" )
>
> I am looking to add the following to this
> (IF {F_TASKS.TA_LOC} > "*" then "Reason")
>
> at present I am only able to return either one or the other, not both
> results. Is it possible to show all three?
>
> cheers
>

IF {F_TASKS.TA_FINISH_DATE} > {F_TASKS.TA_EST_DATE} THEN "LATE" ELSE
IF {F_TASKS.TA_LOC} > "*" THEN "Reason" ELSE
"On Time"

Sponsored Links