We already have the query to retrieve
information about bugs from the Template we will use, so we will need to modify it
in two ways. First, we need to parameterize it so that we only return the bug we are
looking for. Second, we will also need to store the bug history. These are both very
simple modifications; so let's take a look:
1. Open BugzillaReportsTemplate.rpttemplate.
2. Save this report as BugzillaDetailReport.rptdesign.
3. Edit the getAllBugs Data Set.
4. Edit the query to read like the following example:
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
and bugs.bug_id = ?
Chapter 12
[ 275 ]
5. Create a new Data-Set Parameter, call it bugID, and link it to a Report
Parameter.
6. Save the changes to the Data Set. From the Outline, right-click on it and
choose Rename. Rename the Data Set as getBugByID.
7. Now, we want to create a Table element in the report that displays the Bug
information vertically instead of horizontally. To start, drag getBugsByID to
the Report Designer.
8. Delete the Header and Footer Row.
9. Insert four rows into the Detail section.
Pages:
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223