### 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