SAP Knowledge Base Article - Public

1381766 - How to show 0 values in Bar graph


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.


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


  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.


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


Crystal Reports 2008 V0