Need help with creating a chart

[swilms]

Hi,

I am new to iReports (and JasperReports) and need some help with creating a chart.

My report ist fed by data records containing time intervals. I have got 24
variables for each hour of the day. For each data record I check for all hours of the day,
if the time interval intersects with that hour. In that case, the respective variable is
incremented by 1.

As a result I get a list of values assigned to each hour of the day in the summary band:

Hour (Static Text)       Value (int)
00:00                           $V{sum0}
01:00                           $V{sum1}
02:00                           $V{sum2}
.....

Is it possible to get this data displayed in a chart (x-axis: hour of day, y-axis: value of variable)?

Thanks for your help,
Stefanie
 

[linvicch]

Yes,

You can either do some trial and error to determine which of the boxes correlate to which axis or feel free to look at the sample reports in Jasperserver :)

 

[swilms]

I'm still struggling with the basics. Up to now I worked with SQL queries using a JDBC connection to create some simple reports, including charts that use the same datasource.

This time (as described) I don't have an SQL query that provides the data for the chart but a list of calculated values. I guess I need to define a subdataset to get the set of records I need as an input for the chart but I don't know how (i.e. datasource, query ...)

Could you give me some advice?

linvicch: Where exactly do I find the sample reports?