SAP Knowledge Base Article - Public

1234072 - Duplicate scale values are displaying on the y-axis of a chart in Crystal Reports

Symptom

  • The auto-range option in chart expert does not work as expected
  • Values on the y-axis are duplicated

Reproducing the Issue

Use a chart which displays 1 decimal place on the y-axis.

  1. Create a new report with Xtreme Sample Database;
  2. Add 2 tables "Orders" and "Orders_Detail";
  3. Create a Formula called "test": {Orders_Detail.Quantity}/10;
  4. Use Select Expert to create a filter on Orders.Customer ID, "is less than 3";
  5. Create a Bar chart (insert it in the Report Header), use all default settings, with "On change of" set to "Orders.Customer ID" and "Show value" set to "@test".
  6. Check the box "don’t summarize" and click OK 

 Crystal Reports XI Release 2 Service Pack 4 (CR XIR2 SP4)

Cause

This has been identified as a bug with reference ADAPT01103237

Resolution

  •   Install the Service Pack 5 (SP5)

Workaround:

  1. From 'Chart Expert'>'Axes' tab, uncheck the 'auto-range' option;
  2. Select OK and preview the report;
  3. From 'Chart Expert'>'Axes' tab, check the 'auto-range' option again;

Keywords

KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

Product

SAP Crystal Reports XI R2