23. Under the Property Editor, select the Hyperlink tab. Click on the Link To
button. From the Hyperlink Dialog, select the Drill-through as type.
24. Select BugzillaDetailReport.rptdesign as the Target report. Set up the target
report parameter bugID to be linked to row["bug_id"].
Practical Example??”Building Reports for Bugzilla
[ 284 ]
25. Click OK, Save, and Preview the report.
Developer Issues Reports
The next report is a combination of the last two reports in our list. Given a developer
ID, this report will accomplish two things: it will show us a Pie Chart of Bugs (fixed
versus non-fixed bugs), and give us a list of bugs in an open status assigned to
that developer.
1. Open BugzillaReportsTemplate.rpttemplate and Save as
DeveloperPerformanceReport.rptdesign.
2. Modify the getAllBugs query as:
SELECT
bugs.bug_id,
bugs.bug_severity,
bugs.bug_status,
bugs.short_desc,
profiles.userid,
profiles.login_name,
profiles.realname,
Chapter 12
[ 285 ]
components.id,
components.name,
components.description
FROM
bugs,
profiles,
components
WHERE
bugs.component_id = components.id
AND bugs.assigned_to = profiles.userid
and profiles.userid = ?
3. Bind the Data-Set Parameter to a Report Parameter called developerID.
4. We want to use a drop-down list for the developerID parameter. Create a
new Data Set to display the unique developer IDs using the following query,
and call it developerIDList.
Pages:
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228