SAP Knowledge Base Article - Public

2054293 - Different users see different decimal places using the same report

Symptom

  • Most users of a report see two decimal places from a particular database field.
  • Some users see only one decimal place.

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013

Cause

  • Decimal place display depends in part on the Language and Regional Settings.

Resolution

  • Ensure that the setting under Language and Regional Settings are consistent.
  • To display two decimal places consistently without modifying Language and Regional Settings, use the following formula:

 

Totext(round({table.fieldName},1),"####.00")  // Note that it will not be possible to perform any calculations on this formula

Keywords

CR truncate rounding , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013