SAP Knowledge Base Article - Public

1329507 - How to display integer value of Data Labels in the Data (Y) Axis


How to display integer value of Data Lables in the Data (Y) Axis

Reproducing the Issue

  1. Create a new report using Xtreme Sample Database.
  2. Click Database > Database Expert.
  3. Click Create New Connection.
  4. Double-Click ODBC (RDO).
  5. Select "Xtreme Sample Database 2008" from Data Source Name and click Finish.
  6. Select "Orders Detail" table from Available Data Sources and click > to set it as Selected Tables.
  7. Click Insert > Chart.
  8. Drop the mouse into the Report Header.
  9. Select "Orders_Detail.Order ID" from Available fields and click > to set it as On change of.
  10. Select "Orders_Detail.Quantity" from Avaliable fields and click > to set it as Show values.
  11. Select "Orders_Detail.Quantity" in the Show values.
  12. Click Set Summary Operation.
  13. Select Count in the Calculate this summary and click OK.
  14. Click Refresh.
  15. You can see the decimal value (i.e. 0.4, 08, 1.2) of Data Labels in the Data (Y) axis. 
  • Crystal Reports XI Release 2
  • Crystal Reports 2008


  1. Select Chart on the report.
  2. Right-Click on the data labels of the Data (Y) Axis and click Data (Y) Axis Options
  3. Click Scales tab.
  4. Uncheck Minimum Value and set 0.
  5. Uncheck Major Interval and set 1.
  6. Click OK.


Data Axis, scale, min, max, count, sum, decimal , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To


SAP Crystal Reports XI R2