Pie or Doughnut chart when the result set contails all 0's

[sadakar]

Hi Forum,

Result set is like below

A   B

a   0

b   0

c   0

When there is values 0 then the chart is not coming up ... but the title is coming for the chart (static text on title band)....

Added NO data section and added the same title and message in this .. so when there is 0 values I want to display this NO Data section message ..

 

How it is possible ?

Did any one faced same issue ?

 

Thanks in Advance.

Sadakar

 

[kcollins]

Hello Sadakar,

To display the No Data section, select the report element in the report inspector on the left.  In the reports properties, there is a property called 'When No Data'.  Here you can select 'No Data Section'.

-Kris

[sadakar]

Hi Kris

Thank you.

I've already tried that.

 

What I need is when the result set contains all 0's the pie/doughnut chart not displaying any thing ?

 

For eg : if the result set is

1

0

0

then 1 is coming up on pie along with 0's.

 

[kcollins]

I'm not sure I understand your example. Your example is not all zeros; there is a 1 in the dataset. That being said I'm not sure if what you are trying to do is possible. You could try with an expression like this:

 

$P{myfield} == 0 ? NULL : $P{myfield}

 

With this expression, if there is a 0 in the data, it will set the value to NULL instead. However, I think the chart (or parts of it) will still show.