Rounding numbers in Crystal report

Question

I have database table which i want to generate a Crystal report for it just to show the numbers as it is e.g i have 11.7 i want it to remain like 11.7 while it round to 12. I don't want this rounding . please help!

Solution 1

It is very simple, just select the field to which you want to show two decimal places. Right click on the field go to format field-->go to number tab -->click on customize-->then in Decimal select "1.0".

http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=9338

Second option in formula , you can give format, so it will take 1 decimal.(check in above link)

Solution 2

If the formula doesn't work then simply do as follow

right click on that filed --> format field --> number --> choose the format you want --> click ok

Check the images for the same