SAP Knowledge Base Article - Public

1283545 - How to suppress other values and show only the first value on a graph based on a formula?

Symptom

  • A graph based on data coming from a formula. 
  • To suppress other values and show only the first value returned by the formula on a graph.

Reproducing the Issue

  • Create a graph based on the data coming from a formula.
  • Show only the first value returned by the formula and suppress the rest.    

      Enviroment Details:

  • Crystal Reports XI R2.
  • Windows XP.

Resolution

  • Create the graph based on the value returned by a formula.
  • Choose the graph and right click on it.
  • Goto Format Chart option.
  • In the Format Editor window, goto Common tab.
  • Click on the formula field next to Suppress.
  • The Format Formula Editor-Suppress will appear.
  • Write the following formula:

                  If {@Devint}=”MS006932” & “-“ & “eth-s1/s1p2 Ethernet Layer Intel Gigabit Ethernet” then false else true;  

          Where Devint= the formula, "MS006932" and “eth-s1/s1p2 Ethernet Layer Intel Gigabit Ethernet”= First records returned by the formula.

  • Refresh the report.
  • Now the graph will show only the first value returned from the formula.

Keywords

KBA , BI , Business intelligence solutions , Problem

Product

SAP Crystal Reports XI R2