SAP Knowledge Base Article - Public

1381766 - How to show 0 values in Bar graph

Symptom

Unable to see 0 values in series of a Bar graph based on Cross Tab.

Reproducing the Issue

  1. Logon to crystal Designer
  2. Create a Cross Tab with few 0 values in the summarized field
  3. and insert a Bar graph using cross tab.

Cause

Graph will not show numeric value zero (0) in series as values.

Resolution

  1. Right click on summarized fields go in Format Fields—Common Tab—Display String Formula editor and change the data type to string.
  2. ToText(CurrentfieldVaule,"####")

  3. Now Bar graph will show 0 values in series.

Keywords

Zero Values in bar graph, 0 value in graph , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V0