please help. i should get 1 chart, but get many

[jkoorts]

hi there,

 

I run this query (simplified for this question)

 

select month, count from pool

 

From this query i get 12 records. one for each month.

This displays fine in my barchart, but for some reason i get 12 charts for the same chart?

 

I dont use the grouping cause i dont need it, as the query is already aggregated in a 'group by' clause.

 

I just want to put the 12 records in 1 chart and thats the end of it.

 

Attached is my jrxml file.

 

thanks for any help [file name=VolumeReport.jrxml size=10653]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/VolumeReport.jrxml[/file]

[lucianc]

You've placed the chart on the detail band. Since your query returns 12 rows, the report will contain 12 detail bands. Hence, you'll get 12 charts. Everything works as expected.

 

If you want only want chart, you should place the chart on the summary band.

 

HTH,

Lucian

[jkoorts]

Thanks mate!

 

I checked the jasper report book again, and yes they did use the summary tag in their example, but no where does it say that you need to put charts in summary.

 

thanks a lot again.

 

jacques