Search code examples
crystal-reportsdata-conversion

Number to String in a formula field

I am using a formula field to concatonate 2 decimal values separated by a dash. However, I want the result to trim all unneccesary trailing zeros and decimal points for both values.

For example, I want values 10 and 8.5 to be "10 - 8.5". Now it shows "10.00 - 8.50".

The formula I am using is CSTR({field1}) + " - " + CSTR({field2}).

Solution

  • I believe this is what you're looking for:

    Convert Decimal Numbers to Text showing only the non-zero decimals

    Especially this line might be helpful:

    StringVar text     :=  Totext ( {Your.NumberField} , 6 , ""  )  ;

    The first parameter is the decimal to be converted, the second parameter is the number of decimal places and the third parameter is the separator for thousands/millions etc.