Search code examples
crystal-reportsreport

Rounding numbers in Crystal report


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

  • 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)