CRxi - Pie Chart problem 1

[campia]

Hi,

In my report (pie chart) i see the label and the values. However the first line of the legend doesn't have a label and the value is 0....this is because in my database i have a blank line.

example:

0
solved 65
in progress 14
closed 78

How can i avoid this first line?

thanks

 

[lbass]

Use a record selection formula that eliminates it. Let's say that the field that results in "solved", "inprogress", etc. is called {table.status}. Then in your record selection formula use a formula like this:

not isnull({table.status}) and
trim({table.status}) <> ""

-LB