Creating Stages BIRT Reports: A Basic Example
This section explains how to create a basic BIRT report that extracts information from Stages.
Create a Report
- The BIRT RCP Designer is started by executing the birt.exe
- Select File –> New –> New Report from the drop-down menu
- Type the name for the report
- Select the path where the report file will be stored, and click Next
- Select Blank report, and click Finish
The new blank report will be opened on the right side.
Create a Stages Data Source
- Navigate to the Outline View on the lower left side and right-click on the Data Source entry and select New Data Source.
- Select Stages Data Source. Enter a name for the data source.
- Click Next.
- If you do not use the metrics.xml you need to specify the Stages server URL and enter a Stages username and password and click Finish.
- If you use the metrics.xml, it is necessary to insert a script for your Data Source. You will see the created Data Source in your BIRT Report Designer, click on Data Source and choose the “script tab” and the condition “beforeOpen”
- Insert the linked script and save it.
Create a Data Set
- Navigate to the Outline View on the lower left side and right-click on Data Set and select New Data Set.
- Select a name for the Data Set, and click Next.
- Enter the column names and data types
- Documentnamewith type string
- Statewith type String
- Click Next.
- Click Edit Script
- Enter the following script into the editor
var artifacts =
pkit.getCurrentProject().getEntities("containsProcess@SYSTEM")
[0].getEntities("containsArtifact@SYSTEM");
for (i = 0; i <artifacts.length; i++) {
var artifacts_instances =
artifacts[i].getEntities("containsInstance@SYSTEM");
for (j = 0; j <artifacts_instances.length; j++) {
var artifacts_revisions =
artifacts_instances[j].getEntities("containsRevision@SYSTEM");
if (artifacts_revisions.length == 0) {
dataset.setColumnValue("State", "no version");
} else {
dataset.setColumnValue("State",
artifacts_revisions[0].getProperty("state"));
}
dataset.setColumnValue("DocumentName",
artifacts_instances[j].getProperty("LogicalName"));
dataset.storeResultRow();
}
}
To finish the editing of the script, click OK.
Enter a Workspace Path in the text input field. The Workspace Path is the pipe separated path of workspace names in Stages. A report to be executed in the workspace Company –> Projects and Products –> System A –> Software Project A would need the Workspace Path to be set to Company|Projects and Products|System A|Software Project A.
- Note: The Workspace Path value is needed for the preview, if the script contains the statement pkit.getCurrentProject()…
- Click Finish to continue the data set configuration and click Preview Results to show a preview of the results.