3.23.2. Writing your own BIRT reports
Prev | 3.23. Producing long-term reports of test runs with BIRT | Next

### 3.23.2. Writing your own BIRT reports

The BIRT reports are examples of how you could document your quality over time. You can also create other reports to generate depending on which details you want to see in the reports. To create reports, you will need to use the BIRT designer from Actuate. There is an open source version and a commerical version of the designer.

The following information describes what information from the database can be used to generate BIRT reports. For help using BIRT, please see the BIRT documentation.

There are four database tables that contain relevant data for test results:

testresult_summary

  This table contains one row per executed Test Suite and corresponds to the Test Result Summary View in the ITE.

testresult

  This table contains further information about each test run (each row in the testresult_summary table), including all executed nodes.

parameter_details

  This table contains the name, type and value for all parameters (data) in the executed test.

parameter_list

  This table gives a parent-child relation between the executed nodes from the testresult table and the parameters in the parameter_details table.

#### 3.23.2.1. Creating a BIRT report

Using the BIRT report designer, you can create your own reports which will display specific information from these tables.

In the installation directory, in:

plugins/com.bredexsw.guidancer.reporting.birt.viewer

there is the directory reports.

In this directory, the templates for the reports available in the ITE are stored. There is also a library which uses the database as a data source and contains data sets (SQL queries) to this database. The following information is contained in the library:

Datasets:

  there are views to show details from the four tables for reporting in the database.

Report parameters:

  These are parameters for the database queries that can be used to limit the scope of a report.

Report items:

  These are examples of pre-defined tables and graphs which can be used in other reports.

Master pages:

  These define the layout of the reports

Themes:

  The themes contain information about colors, fonts etc. The themes are in the ite.css file.

| Be careful when working with the reports and themes that you do not break the existing reports!