Joined: 22 Mar 2007
Location: United States
Online Status: Offline
Posts: 30
Topic: Rounding Posted: 05 Dec 2007 at 1:23pm
Hi all... i'm having a problem with incorrect rounding of numbers... I have sql command that i use to pull the data. Whenever i view the data on SQL Server the amounts shows up correctly. But when i browse the data using CR XI the data are rounded up. And incorrectly being rounded.. Can someone help me with this...
Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Posted: 07 Dec 2007 at 6:24am
Does this happen when you actually view the data in the report, or just when browsing? If it happens on the report itself, check the format of the number field. Make sure it has enough decimal places.
But, it's also very likely that the culprit is field clipping. This is where Crystal just snips off the last bit of the number. Go into File > Options, and go to the Fields tab. Select Number. Click on the Number tab, then on Customize. Make sure Allow Field Clipping is not selected. You may need to repeat this in the Report Options screen, if you already have some formatting on the report that might override the default format.
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
IP Logged
