Charting data that have widely differing values can be difficult using a single data axis. By using two or more axes, the data can be more easily understood. iReport includes built-in support for multi-axis charts through the use of the JFreeChart package.
iReport Professional 3.5.0 was used to create this tutorial.nIt should work identically in later versions of iReport Professional and iReport Community Edition. The concepts apply to older versions of iReport, but the user interface differs.
This guide will enable you to:
Familiarity with iReport is helpful.
To create a new report, set these report properties:
A new empty report with sample SQL query to get started is available here.
Note: The SQL query in the sample report returns some hard-coded sample data; it does not refer to any tables in the database. This way it can be used with any valid SQL datasource. It has been tested with MySQL and PostgreSQL, but it should also work with most other database technologies.
Follow these steps to create a simple line chart.
|1||Drag the Chart tool into the report.
|3||Right-click the chart and select Chart Data|
|4||Add 3 Series: Sales, Issues, and Bugs
|5||The definition of each series should follow this model:
In preview mode the report now looks like this:
Note: Line charts do have limitations:
The problem is that the number of bugs filed is roughly 1000 times smaller. This discrepancy in scale makes the chart less useful.
Follow these steps to create a multi-axis chart.
To avoid having to re-type the series information, open the Chart Data dialog again and copy all three series
|4||In the Report Inspector panel find the Multi Axis chart and set the Chart Data for the child Line Chart
|5||On the Details tab paste in the series that were previously copied|
|6||If you run the report now it should look exactly as before|
Remove the Issues and Bugs series
The use of two different axes makes it easier to see the trends. However, the lines have a tendency to overlap since both charts will rise to the same height. Combining a bar chart with a line chart is a good solution to this issue.
|1||Edit the chart data in the first line chart. Copy the Sales series|
|2||Delete the first line chart|
|3||Right-click the Multi Axis chart and add a new Bar chart|
|4||Edit the bar chart data and paste the series|
|5||The combined use of bar and line charts makes the data easier to understand quickly|
These sample charts may be improved in many ways:
The report can now be deployed to JasperServer for use in a dashboard or to be scheduled for regular delivery.
This tutorial was written by Matthew Dahlman, Engineer, June 2009