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