We will also
create the Style Sheets that we want to use to make things consistent throughout the
reports. Let's begin:
1. Create a new Reporting Project called Bugzilla Reports.
2. Create a new Library called bugzillaReportsLibrary.rptlibrary in the newly
created project.
3. Switch to the Outline view in bugzillaReportsLibrary.rptlibrary. Create a
new JDBC Data Source called bugzillaDataSource.
4. As I am using MySQL, I need to use the Manage Drivers Dialog under the
Data Source setup to install the MySQL JDBC driver. Following is the Dialog
screen where I edited the MySQL Connector-J driver to have a description
and Template JDBC URL
Practical Example??”Building Reports for Bugzilla
[ 272 ]
5. Input the correct JDBC URL and Driver for Bugzilla.
6. Select Themes under the Outline. Change the name of the Theme to
bugZillaTheme.
7. Create a new Custom Style called masterPageHeader.
8. Input the following parameters for the Style:
For Font:
Color: White
Weight: Bold
Font: Sans-Serif
For Background:
Background Color: RGB(64,0,128)
9. Select the MasterPages element under the Outline. Change the name of the
Master Page from Simple Master Page to BugzillaMasterPage.
10. Select the Master Page tab in the Report Designer.
11. Insert a Grid into the header with 1 column and 1 row.
12. Insert a Label component into the Grid cell, and enter the text as Bugzilla
Reports.
Pages:
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221