SAP Knowledge Base Article - Public

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


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


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


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


  • 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


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


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