Bar chart

In the earlier section, we saw some of the power that charting can have with reports, by adding both the graphical representation of data and the interactivity for users to see the details of that data in a separate report. We also saw how to pass data through to the target report by using the expression. In this report, the hyperlink will take us to an internal bookmark, which means it will jump us to a location inside the same report containing the details for our report. We will also look at aggregating values inside the chart so that we can provide a simple query that just retrieves the necessary details and lets BIRT handle the tricky stuff for us.

1. 1. Create a new report called EmployeeSalesPerformanceReport.rptDesign.

2. 2. Use the dsClassicCars data source in the library.

3. 3. Create a new dataset called employeeSales, using the following query:

   select
   CLASSICMODELS.EMPLOYEES.EMPLOYEENUMBER,
   CLASSICMODELS.EMPLOYEES.LASTNAME || ', ' || CLASSICMODELS.EMPLOYEES.FIRSTNAME name,
   CLASSICMODELS...