Pi Chart creation using IReport

[meetjeetendra]

I m creating a Pi-Chart using IReports using the following query.

Code:

select SUM(a."total_performance"«»),c."Team_Name"
from
 "Opex_Agent_Records_TX" a,
 "Opex_Team_B" c
where
 a."Team_ID"=c."Team_ID" and
 a."Team_ID" in(1,2,5)
group by c."Team_Name"
 order by c."Team_Name"

But as the query fetches 3 records(3 Teams), so i get 3 Pi-Charts rather than getting only one. And all the 3 charts show the same structure.

 

I want only 1 Pi chart to be displayed.

 

Please help me in this...

Thanks in advance..

Ji2.

[kchaudhry]

It seems like you have placed your pie chart in the details band. Try moving it to the "summary" band.