Hi

I have a report, which contains a crosstab report. From the crosstab I created a chart using line chart with markers. I then hid the lines so the markers are visible.

The X axis contains no's 1 to 25. Each X axis value contains multiple plotted values on each Y axis according to its value. Because the data is retrieved via a crosstab when ever the value is 0 it still plots it on the chart.

I have added a suppress formula on the crosstab to suppress 0 values. This works fine but does not stop the chart from plotting the 0 values. I have also tried changing the report options.

I see under workshop formula there is an option to suppress format. But I cannot find any examples of how to do this.

Formating Formulas>Report Header>Graph1>Suppress>

Does anybody know how to do this.