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/Vol...
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/Vol...
2 Answers:
Posted on September 27, 2006 at 3:26pm
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
If you want only want chart, you should place the chart on the summary band.
HTH,
Lucian
