Joined: 18 Aug 2021
Online Status: Offline
Posts: 12
Topic: How to stop default rounding of numbers Posted: 14 Sep 2022 at 12:43am
I have number fields having decimal values (can be of any length). I have chosen the default format of number in crystal report format field. the value of that filed is rounding to off automatically in output. Is there any way to stop rounding of the values and display the database value of type number as it is in report ?
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 14 Sep 2022 at 11:57am
Are you setting the number of decimals to the max number of decimals available in the database? If so, there should be no rounding. One way around it (if it works for you), you can convert the number to a string and thus it will not round at all. If you are exporting to Excel that could be an issue.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum