SAP Knowledge Base Article - Public

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

Symptom

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

Resolution

  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.

Keywords

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

Product

SAP Crystal Reports XI R2