SELECT distinct
profiles.userid,
profiles.realname
FROM
profiles
Practical Example??”Building Reports for Bugzilla
[ 286 ]
5. Open the developerID Report Parameter for editing. The Dialog should look
like the following:
6. Click on OK to save the Parameter Edit.
7. Drag getAllBugs Data Set over to the Report Designer.
8. Delete all columns except bug_id and short_desc.
9. Insert a new row in the header above the column Labels.
10. Merge all the cells in the new row.
11. Insert a Chart into the new large cell.
12. Select a Pie Chart, and set the Output Format to PNG.
Chapter 12
[ 287 ]
13. Select the Select Data tab. Under the Category Definition, use the
following expression:
if (row["bug_status"].toUpperCase() == "RESOLVED")
"Fixed";
else
"Open";
14. Click on the Edit Group and sorting button. Check the Grouping Enabled
check box. Set the Type to Text, Interval to 0, Aggregate Expression to
Count, and Hit OK.
15. Under the Slice Size Definition, enter 1 for the value, and change the
aggregate function to Count.
16. Under the Format Chart tab, go to Title. and use Open Issue Chart as the
Chart Title.
17. Resize the Chart. Change the Labels for Bug ID and Bug Short Description.
Practical Example??”Building Reports for Bugzilla
[ 288 ]
18. Select the Detail Row of the Chart.
19.
Pages:
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229