Prev | Current Page 210 | Next

John Ward

"Practical Data Analysis and Reporting with BIRT"


13. In the Report Designer, right-click on the Grid, and select Style|Apply
Style|masterPageHeader.
Chapter 12
[ 273 ]
14. Create a new Data Set called getAllBugs. Use the following query:
SELECT
bugs.bug_id,
bugs.bug_severity,
bugs.bug_status,
bugs.short_desc,
profiles.userid,
profiles.login_name,
profiles.realname,
components.id,
components.name,
components.description
FROM
bugs,
profiles,
components
WHERE
bugs.component_id = components.id
AND bugs.assigned_to = profiles.userid
15. In the project, create a new Template called BugzillaReportsTemplate.
rpttemplate, and use Template for Bugzilla Report Project as the
Display Name.
16. In the newly created Template, open the Library Explorer tab and the
Outline (one above the other). "Drag and drop" the bugzillaDataSource,
getAllBugs, and BugzillaMasterPage components from the Library to
the Template.
First Report??”Bug Detail Report
Now that we have the groundwork laid for our project, we can start building the
actual reports. In a typical situation, you wouldn't know beforehand every possible
element to add to a report Library. So in the next example, we are going to build the
report, then go back in after the fact and add some formatting elements??”such as
Styles??”that will be used in the remainder of the reports.
Practical Example??”Building Reports for Bugzilla
[ 274 ]
The following report is fairly straightforward.


Pages:
198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222
Władysławowo noclegi pity pozycjonowanie bilety lotnicze świnoujście noclegi