Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Every now and then, bite off more than you can chew
 
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

13
March

A Question of Rounding

The issue:

A Crystal Reports client contacted me, as they were having a rounding issue with there report.

They wanted to display the figure 13.589 from the database, but the report was displaying 14.

They had gone into the Crystal Reports settings, and used the customised option to try to show the actual figure on the report, and this still did not work.


The Solution:

To resolve this rounding issue, Format the field

Menu - Format -> Field -> Customise

Set Decimals:- 1.000

Set Rounding: - 0.001


If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us

MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

26 + 3 =