Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
A little rebellion now and again is a good thing
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!!!!


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


Name *

Email Address *

Comment *

To prove you are human what is:

20 + 53 =