Print Page | Close Window

Rounding Ahhh!

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=283
Printed Date: 04 May 2024 at 12:52pm


Topic: Rounding Ahhh!
Posted By: Mae Roberts
Subject: Rounding Ahhh!
Date Posted: 06 Mar 2007 at 10:54am

I am using Crystal v 8.5 and experiencing rounding on numeric fields populated and summarised in my report. How can I stop rounding of the data presented in the report?? I have tried formatting the field but this does not help. Is there a SQL command I need to include in a formula?


Replies:
Posted By: hilfy
Date Posted: 07 Mar 2007 at 5:20am
Right-click on the number field and select Format Field. Go to the Number tab and click on the Customize button.  There should be an option to set the rounding value.
 
If you want to change this for all new reports that you create in the future, you can go to the File menu and select Options.  Go to the Fields tab.  Click on the Number button and follow the instructions above.  This will change the rounding for all new fields/reports but not for existing fields on reports.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: Mae Roberts
Date Posted: 08 Mar 2007 at 12:38am
Yes thank you for the information I had already tried this route to format the number and rounding.
However, I discovered to day that the fault is with the data...not Crystal. Many Thanks

Posted By: BrianBischof
Date Posted: 08 Mar 2007 at 11:03am
Can you explain what was going on with the data in case someone here runs into a similar problem?

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>


Print Page | Close Window