Print Page | Close Window

weird roundup

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3597
Printed Date: 02 May 2024 at 5:51am


Topic: weird roundup
Posted By: ricky969
Subject: weird roundup
Date 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


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

Posted By: ricky969
Date 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

Posted By: ricky969
Date 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
 
 


Print Page | Close Window