duplication of chart bar in ireport

[highjo]

Hello good people!
I've tried to use chart in ireport 3.7.0 for the first time.I've used a bar chart and anytime i preview the chart i see plenty of them, i think about 6.I only need a single one is there anything that i didn't do?
i have a query like this :

SELECT COUNT(*) AS total_message ,`status` , DATE_FORMAT(date_created,'%M') AS `month` FROM message WHERE YEAR(date_created)=$P{year} GROUP BY `status` , MONTH(date_created) ORDER BY `status` DESC
[/code]

and i have a result like

|total message | status | month       |
|1             | FAILED | January     |
|10            | SENT   | Febuary     |
|11            | SENT   | March       |
|123           | SENT   | April       |
|156           | FAILED | May         |
 ..........
[/code]

up to december. my serie expression is set to ${Status}
categorie expression is ${month}
value expression is ${total_message}

can somebody help me ? thanks for reading this!

Post Edited by highjo at 01/12/2010 18:56

[highjo]

can anyone shed some light please! this has become a bit urgent.thank you

[ckampshoff]

Hi highjo,

where have you put your chart? Try the summary band, then it should appear only once.

HTH

Christina.

[highjo]

Hello Christina!

I used to put the chart in the detail band.Pheww! thanks for your help.I must admit you have being for a lot of advancement in my learning on ireport.I'll also say that it's a bit rare to find updated documentation online unless i'm not looking at the right place.I need to find a reference or something(apart from ultimate guide to ireport) to have some level of understanding on ireport.thanks

by the way when you are displaying a report containing a lot of rows from the database.how do you reduce the space( i mean the height) between each row thank you

[ckampshoff]

Hi highjo,

I'm glad to help you.

Try play around with the band height or the height of the fields in your band. You can also make the font smaller and so aou can reduce the height of the field and reduce the heightof the band.

HTH

Christina.