BIRT variables can be used to resolve a lot of issues. We will use it to point to the JIRA server URL and display JIRA icons on BIRT reports.
Issue 1: The JIRA Base URL
We want to display JIRA icons for the issue type instead of their urls. The SQL for JIRA Driver returns relative URLs to the JIRA Base URL for issue type icons.
...
Please use your own JIRA Base URL value including the double quotes:. It must match the same URL used in the JIRA Data Source. For instance, if you used the 127.0.0.1 IP and now the localhost domin name, the tutorial will not work as expected.
A new variable is added to the BIRT report:
Issue 2: Replace the Issue Type URL
...
by their icons
Select the cell in the Table Detail for the Type Url column and remove its conent:
...
At the moment, we have made no progress as we have simply replaced a binded label with by a binded dynamic text. However, we are now able to wrtie HTML code to create the image on the report.
...
<img src='http://localhost:2990//secure/viewavatar?size=xsmall&avatarId=10318&avatarType=issuetype' title='Task'/>
Issue 3: Colum Order
Rearrange the column order: Select the Table item on the Outline view, then the Issue column on the Layout and right click on the Column Table Header to Insert > Column to the Left:
...
and remove the older TypeUrl column and the Type columns:
Run the BIRT report and check that the status icons are displayed. If something is wrong you can inspect the BIRT report HTML code from your browser's debugger:
