SAP Knowledge Base Article - Preview

1212821 - How to conditionally set the number of decimal places to display for a number, in Crystal Reports?

Symptom

  • How to conditionally change the number of decimals?
       
  • In the Crystal Reports, a number field that returns decimal places is inserted into a report.
    When previewing the report, the decimal places in this number field contain unnecessary zeroes.
    How can you suppress the unnecessary zeroes in these fields and still leave up to two decimal places for fields that require them?
        
    For example:
      
    A number field is placed on a Crystal Report and is not formatted the way you want.
     
    The field displays: 
     
       1.25 
       2.50 
       8.00
     
    But you want the numeber to display like:
       
       1.25
       2.5
       8


Read more...

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020

Keywords

CR, CONTROL ZEROS ZEROES DECIMAL PLACE NUMBER DIGIT , 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.