BIRT – Generate a separate chart for each group value
January 16, 2012
In BIRT it is possible to create a table grouping and have a chart generated for each group value. In this blog I explain how it can be done using the sample database.
The Query
Create a dataset dsOrders on the ORDERS table from the sample database with this query:
select year(orderdate) order_year,
month(orderdate) order_month,
status
from orders
The Report Table and the Chart
Drag a table element (1 row, 1 column) to the report design section and bind it to your data set dsOrders. Insert a group into the table where you Group On order_year. In the group header appears a datafield order_year.
Now add a second group header row underneath the first one and drag a chart item in it. Select Stacked Bar Chart as the chart subtype. On the Select Data tab, make sure to choose “use Data from dsOrders”, instead of the default selection which is “Inherit data from container”. Enter the dialog like this:
The number of orders will be counted grouped by month and status.
To make sure that every chart shows data from the corresponding year only, select the chart and add this filter:
The row.outer[“ORDER_YEAR”] part can be constructed through the expression.
Results
So if we run the report, a chart will be shown for each year:
