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