how to remove Zero values in crystal report

Question

Hello friends, do you have any idea how can i remove zero values if its coming with value like 5.1 then its showing me 5.10 . i want to remove zero if its coming.. thanks in Advance

Neha Sharma · Answer

I am giving you here a two step guidance,follow the steps. Please find the attachment you ll solve your problem. let me know the problem solved or not. Thanks.

Naeem Khan · Answer

i m not getting sir even i have tried your way but its not working told you is there any formula for it.. i thing i should be use formula for it..

Neha Sharma · Answer

Hello Naeem, It's very simple just go to the field which you want to come without .00,click on format fields and select which kind of format you want. Looking froward to know have you done this or not??. Thanks.

Naeem Khan · Answer

its not working sir...please give me other idea..

Sivaraman Dhamodaran · Answer

Writing a formula required x'tal report. I don't have that at present. Right click the filed, Select format field. (Previously I told property). From the displayed dialog move to all the tab. One tab will have different formats of decimal, chose the one (With No zero)

Naeem Khan · Answer

thanks for reply but you will you please tell me what kind of formula .. and there is no option in properties.

Sivaraman Dhamodaran · Answer

1) Right click the filed and go to property. There you can adjust it using the format. Or 2) Write a formula, that will do the truncation when it finds a zero.

how to remove Zero values in crystal report

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (7)