Jump to content
Changes to the Jaspersoft community edition download ×

Pi Chart creation using IReport


meetjeetendra

Recommended Posts

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.

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...