Crystal Reports weird roundup

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions

Topic: weird roundup

Author	Message
ricky969 Groupie Joined: 03 Jul 2008 Location: United States Online Status: Offline Posts: 53	Topic: weird roundup Posted: 03 Jul 2008 at 3:19pm
	I created a report pulling data from a sql stored procedure. when I execute the stored procedure on sql server, one of the columns with the amount value shows 7.75 When I run crystal reports that same value becomes 8.00 on the sql table the datatype is set to "money". How is that possible that Crystal is rounding up to 8.00? Thanks for any suggestions. Rick
	IP Logged

rahulwalawalkar Senior Member Joined: 08 Jun 2007 Location: United Kingdom Online Status: Offline Posts: 731	Posted: 04 Jul 2008 at 5:06am
	Hi, It has to do with the rounding of the field,right click the field then select format field -->Select Number tab the click the Customize button then select the rounding to 0.01... Cheers Rahul
	IP Logged

ricky969 Groupie Joined: 03 Jul 2008 Location: United States Online Status: Offline Posts: 53	Posted: 04 Jul 2008 at 1:45pm
	I cannot try until Monday but I believe you are absolutely right. Never used that feature. I will test it Monday as soon as I get to work. Thanks so much. Rick
	IP Logged

ricky969 Groupie Joined: 03 Jul 2008 Location: United States Online Status: Offline Posts: 53	Posted: 07 Jul 2008 at 7:59am
	Actually the field had already been customized as: Decimal: 1.00 Rounding: 0.01 Negatives: -123 From the Database Tab I selected "Verify database" and by going thru this simple process I was able to get the correct results (At some point the database/proc had been changed but the report had never been updated). Rick Edited by ricky969 - 07 Jul 2008 at 8:58am
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

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

This page was generated in 0.047 seconds.