Report Builder

[Jenie888]

I use Report Builder for all our our reporting needs. I a decimal field that displays the quantity of bill units. Some bill units are whole numbers, some have 2 decimal places, some have 4 decimal places. THe peopblem is I only want to display the field to the amount of places the field accually has.

For example:
Bill units = 3
then it should only display 3
Bill units 4.56
then it should display 4.56

at the moment it is displaying:
Bill units = 3
then it should only display 3.0000
Bill units 4.56
then it should display 4.5600

does anyone know of a way to make this work?

Jenie

 

[mra]

Hello Jenie!

Try something like creating a calculated field containing string(FIELD, '>>>9.' + fill( '9',NUM-DEC-PLACES ) )
Then you can display this field instead of the original.

Hope it helps

Regards
Mike

 

[Jenie888]

Hey thanks for the suggestion. It didn't work too well, but I found the function "Right-Trim" It worked perfect. <-I don't know why I never notived it before.

Thanks!