Report builder in BO - Removing trailling zeros

[Former Member]

I have a field that can have up to 5 deciaml value like 0.12345.. But if the amount is 0.12300 i want to remove the trailling zeros so i would get 0.123 on my report. I have a formula for crystal report but i cant put the 'if' condition in BO Report builder.

Help please

Thanks to all

[Former Member · Accepted solution]

> I have a field that can have up to 5 deciaml value

> like 0.12345.. But if the amount is 0.12300 i want

> to remove the trailling zeros so i would get 0.123 on

> my report. I have a formula for crystal report but i

> cant put the 'if' condition in BO Report builder.

Hi Alain,

In Print Layout Designer, the Round function allows you to round decimal values to a selected (fixed) amount of decimals. However, this is not exactly what you are looking for. As far as I know, there is no way you could do the removal of trailing zeros in PLD. A common workaround (although a really ugly one) to this problem as well as to many other PLD problems is to do the processing with formatted search in a UDF and just print whatever you have in the UDF.

IMHO, the Print Layout Designer is by far the most frustrating component of B1. I don't mind that it's got a clumsy user interface, but the limited availability of fields&functions is just outrageous. To make things worse, it seems there are practically no significant improvements in the PLD for B1 2006.

Henry

[Former Member · Accepted solution]

Thanks for the answer, but for some reason i cant give you points and i cant close this question... sorry

[Former Member · Accepted solution]

hello - rather than round, you can simply choose to suppress Zeros when using the PLD. You will find that option in the field properties/format tab