How to remove decimal place in crystal report

I want to return text or a number based on the value of a field in a crystal report

local numberVar i; i:=Roundup(({@a}/{@b})*100,0); if{@a}=0 then ToText('N/A') else ToText(i); 

the result is always in the crystal report

  • test_colum
    • N / a
    • n / a
    • 2.00
    • 3.00

since the integer value is converted to text using ToText (), integer results are added using .00

+4
source share
1 answer

ToText (x, y), where y is an integer indicating the number of decimal places to transfer the value from x to.

http://publib.boulder.ibm.com/infocenter/radhelp/v7r5/index.jsp?topic=%2Fcom.businessobjects.integration.eclipse.designer.doc% 2Fhtml% 2Ftopic629.html

+7
source

Source: https://habr.com/ru/post/1382853/


All Articles