SAP Knowledge Base Article - Public

1532424 - Bars in single dimensional chart should start from co-ordinate(0,0) in Crystal Reports

Symptom

  • Bars in single dimensional chart leave blank space on x-axis from co-ordinate(0,0) .
  • Bars of single dimensional bar chart should appear from extreme left.

Environment

  • Crystal Reports XI R2
  • Crystal Reports 2008

Reproducing the Issue

1) Create a sample Crystal Report on the Xtreme Sample Database.

2) Create a blank formula(e.g: Formula1).

3) Insert a "Side by side bar chart".

4) In the chart expert> "data" > select the blank formula (Formula1) under "on change of" section.

5) Select more than one fields under "Show Value(s)".

6) Click on "OK".

7) Bars in chart leave some blank space on x-axis from co-ordinate(0,0).

Cause

This is by design and chart's bars try to accumulate the centre position of the chart ( leaving equal blank spaces from the left as well as the right side).

Resolution

To workaround this,follow the below steps:

  1. Right click on chart.
  2. Go to Chart options > "appearance" .
  3. Under "overlap" drag the slider to the maximum value.
  4. click on "OK". 
  5. Bars will start from extreme left (0,0) position of the chart.

Keywords

single dimensional chart, bars, blank space, extreme left, co-ordinate(0,0) , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports all versions