Crystal Reports v9.0 has an interesting option for field formatting. You can change the way your report data are displayed in your report by using the “Display String” format property. 

You will find it at the bottom of the “Common” tab under format field.

The display string can be any calculation you like, but it must return a string or text value.

Use it for a weather report to say 
If CurrentFieldValue < 0 then “Freezing” else 
If CurrentFieldValue <10 then “Cold” else 
If CurrentFieldValue <25 then “Pleasant” else “Hot” 

(The above temperatures are in Celsius and refer to Auckland, NZ conditions. Use your own temperature scale and descriptions in your local report) We have an interesting application of this in a crosstab suggestion. 

This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.