Null label in chart legend

[Jen123]

Hi

I'm using Crystal Report Prof XI.

I use a formula in a pie chart which sets a load of data to null if it doesn't meet certain critieria. The trouble is, although the null values aren't charted (which is what I want), there is still an annoying '0' without a label in the chart legend. Does anyone know of a way to get rid of it?

Basically the pie chart is driven by 2 formulas. Formula 1 is used in the 'On change of' and says:

if {dbfield} = 'TestData' then {null} else {dbField}

the second formula says if {dbfield} = 'TestData' then {null} else {FieldToCount}

Cheers

 

[lbass]

I think you will have to use record selection to eliminate the unwanted records. If you cannot do that because you need those records for other parts of the report, insert a subreport just for the chart where you can eliminate the records.

-LB