General information
Category:
Reports & Report designer
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only