Since you have an error in the expression shown here ("...iff(alltrim..."), can you cut/paste the ACTUAL expression here for us. Things like misplaced commas or parens can matter.


>I'm running a report in 2.6 and I would like one field to print "RETURNED" in the field = 'REFUND' and print "HARVESTED" if the field = 'HARVEST' otherwise, just print the field. Here's my code:
>
>Under Report Expression:
>iif(alltrim(tag1_st) = 'REFUND','RETURNED',iff(alltrim(tag1_st) = 'HARVEST','HARVESTED',tag1_st))
>
>The second part works and prints HARVESTED, where as the first part still prints REFUND.
>
>Any suggestions?
>
>Thanks,
>Sunshine