I use this blog to record programming notes from both work and personal projects. I don't put everything I do on here but when I write a handy script or figure something out that I don't want to forget for next time, I add it to this blog. Feel free to use this blog in your own projects.
Test Menu
- Commentary
- Deals
- Coupons
Dec 14, 2011
Crystal Reports - Text or Text Number With Three Decimal Places
This is a Crystal Report formula field. The requirement is to display the string 'No Data' when the value is null and if it isn't null show the number with three decimal places.To display 'No Data' both parts of the if must be converted to text.
If NumericText ({SupplierStatistic.pHMin}) Then
ToText(ToNumber({SupplierStatistic.pHMin}),3)
Else
'No Data'
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment