Page Comparison

...

select 
  i.key as"Issue",
  i.summary as "Summary",
  t.name as "Type", t.url as "TypeUrl",
  s.name as "Status",
  c.colorname as "Status Color"
from 
  ISSUES i 
    join
  ISSUETYPEDEFINITIONS t on t.id = i.typeid
    join
  ISSUESTATUSDEFINITIONS s on s.id = i.statusid
    join
  ISSUESTATUSCATEGORYDEFINITIONS c on c.id = s.categoryid
where 
  i.jql = 'reporter = currentUser()'

and paste it in the BIRT report:

Image Added

Click on the Finish button and explore more data set options:

Output Colums: It shows the colum Names, thier Type and the Display Name among other data.  Tip: you might want to use aliases for columns in your SQL for JIRA query as it simplifies the Name and Display Name later configuration.

Image Added

JIRA data can also be explored at real time in the Preview Results:

Image Added

Finally click on the OK button to create the Data Set on the BIRT report:

Image Added