iReport Charts

Hi! ... it seems like ireports line charts (timeseries chart, XY chart ...) doesnt work like it should.

For example, when you try to put in a chart values that share same times on the X axis, ireports doesnt show anything, or, in some cases just the last entrys readed from the database...

if you change some hours in the database so you can make not all values share same times... it just show like doted lines (or no-continuous functions)... im using "filters" to show different series in the chart like:

( $F{template_id}.equals( new Long(1) ) ? $F{value} : null )

cause i have a table in my database (where i get all my data for the report) like this:

+----+---------------------+-----------+-------------+--------+

| id | datatime | value | template_id | prueba |

+----+---------------------+-----------+-------------+--------+

| 1 | 2008-05-09 09:01:00 | 0.3 | 3 | 0 |

| 2 | 2008-05-09 09:08:00 | 1 | 3 | 1 |

| 3 | 2008-05-09 09:15:00 | 1.7 | 3 | 2 |

| 4 | 2008-05-09 09:22:00 | 2.4 | 3 | 3 |

| 5 | 2008-05-09 09:29:00 | 3.1 | 3 | 4 |

| 6 | 2008-05-09 09:01:00 | 0 | 2 | 0 |

| 7 | 2008-05-09 09:08:00 | 1 | 2 | 1 |

| 8 | 2008-05-09 09:15:00 | 2 | 2 | 2 |

| 9 | 2008-05-09 09:22:00 | 3 | 2 | 3 |

| 10 | 2008-05-09 09:29:00 | 4 | 2 | 4 |

| 11 | 2008-05-09 09:01:00 | 0.2 | 1 | 0 |

| 12 | 2008-05-09 09:08:00 | 0.7 | 1 | 1 |

| 13 | 2008-05-09 09:15:00 | 1.2 | 1 | 2 |

| 14 | 2008-05-09 09:22:00 | 1.7 | 1 | 3 |

| 15 | 2008-05-09 09:29:00 | 2.2 | 1 | 4 |

+----+---------------------+-----------+-------------+--------+

... then i tried to make my charts directly with jfreechart and it works just right... i think maybe is the way that ireports inserts new series to the dataset... (apparently ireports uses .add method instead .addOrUpdate).

i did a huge research on the web and i didnt find anything about this trouble... and theres no bug reported either...

that's all... thank you for your attention!!!

Valentina.

ps: i attached some screenshots:

- how ireports fills my chart when all values share same times.

- how ireports fills my chart when the values share SOME times

- how jfreechart fills my chart

- my .sql (if you to create my database with my table filled),

- my .jrxml