Move the data fields to look like the
following figure:
6. In the Outline, select the Root element. Apply the bugZillaTheme.
7. In the Group Header Row with the [name] field, apply the , apply the
DetailTableHeader Style.
8. In the Detail Row, apply the DetailTableRow Style.
9. In the Header Row, select all the cells and Merge.
Practical Example??”Building Reports for Bugzilla
[ 282 ]
10. In the new merged cell, insert a Chart.
11. Select a Bar Chart, and change the Output Format to PNG.
12. Open the Select Data tab.
13. Drag the bug_status field to the Optional Y Series Grouping slot.
14. Drag the [name] field to the Category (X) Series slot.
Chapter 12
[ 283 ]
15. Click on the Edit group and sorting button.
16. In the Group and sorting Dialog, check the Enabled check box. Change the
Type to Text, Interval to 0, and Aggregate Expression to Count.
17. For the Value (Y) Series, enter Series 1.
18. Under the Aggregate function, select Count.
19. Under the Format Chart tab, go to Chart Area|Title and enter Bug Status
Report as Chart Title.
20. Select Axis|X-Axis, and check the Stagger check box.
21. Resize the Chart to fit the number of categories.
22. The last thing we need is to add the Drill-Through from the descriptions to
the bug detail. Select the short_desc data item in the Report Designer.
Pages:
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227