So, we have created the header for the report. Now, we want to see the details of this
bug. The details are basically the bug history about who changed the fields, added
fields, changed the bug's status, and the resolution.
1. Create a new Data Set called getBugHistory.
2. Use the following query:
select
bugs_activity.bug_when,
bugs_activity.added,
bugs_activity.removed,
profiles.realname,
fielddefs.name
Practical Example??”Building Reports for Bugzilla
[ 278 ]
from
bugs_activity,
profiles,
fielddefs
where
bugs_activity.who = profiles.useridand bugs_activity.fieldid =
fielddefs.fieldid and bug_id = ?
3. Add in a new parameter and bind it to the Report Parameter bugID.
4. Drag the new Data Set over to the Report Designer.
5. Update the header Labels as illustrated in the following figure. In this
figure, I also moved the column containing the Field Updated field to the
second column.
Chapter 12
[ 279 ]
6. Now, we need to create Styles for the Detail Row. We want to create these
in the Library also so that they are reusable in our other reports. Open the
BugzillaReportsLibrary.rptlibrary.
7. Create a new Custom Style called DetailTableHeader.
8. Use the following settings for the Style:
For Font:
Weight: Bold
For Background:
Background color: RGB(128,128,255)
9. Create a second Custom Style called DetailTableRow, and use the
following settings:
For Highlights:
Expression: row.
Pages:
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225