I have a query which returns a value the value is always either 1 or 2. If its 1 for reporting purposes I want it to appear as "New" if its 2 I want it to appear as "Recon". I think it would be best if it was converted in the sql statement but if crystal could handle it that would also be ok. Any Ideas pls.
