SAP Knowledge Base Article - Preview

3082571 - How To: Crystal Reports - format a Currency field with multiple decimal places in the same column without trailing zero's


We have a report that can show multiple currencies in the same column, some may have use 2 decimals and some may use 3 decimals.

We want to be able to show them in the same column.



  • Crystal Reports - all versions
  • Crystal Reports for Visual Studio .NET all versions
  • Crystal Reports Java SDK - all versions 


SAP Crystal Reports 2016 ; SAP Crystal Reports 2020 ; SAP Crystal Reports, developer version for Microsoft Visual Studio ; SAP Crystal Reports, version for Eclipse all versions


 CR, Formatting, dynamic decimal places , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.