Print Page | Close Window

How to stop default rounding of numbers

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23020
Printed Date: 28 Mar 2024 at 5:54am


Topic: How to stop default rounding of numbers
Posted By: DDSJ
Subject: How to stop default rounding of numbers
Date 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 ?

Please help

Thanks in Advance
DDSJ



Replies:
Posted By: kevlray
Date 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.



Print Page | Close Window