At this
stage, we need to add the data fields Report Type and Path (the
file system location for the report file) to the DataSet. To do so, we
will modify the DataSet on the Data tab.
21.
Click the Data tab.
22.
Click the Graphical Query Designer
button, as necessary, to shift to the graphic designer, which consists of a
toolbar and four panes, as shown in Illustration 27.
23.
Right-click in
the white space to the right of the tables, within the Diagram pane.
24.
Select Add
Table ... from the context menu that appears, as depicted in Illustration 28.
Illustration 28: Select
Add Table ...
The Add
Table dialog appears, defaulted to the Tables tab.
25.
Select Report
Types from the tables listed in the dialog, as shown in Illustration 29.
Illustration 29: Select
the Report Types Table ...
26.
Click Add.
27.
Click Close,
to dismiss the Add Table dialog.
The Report
Types table appears, along with the other tables, in the Diagram pane.
28.
In the Report
Types table, click the checkbox to the immediate left of Name, to
select the field into the existing query.
29.
In the Grid
pane (the pane containing rows and columns, just below the Diagram pane),
type the following into the Alias column of the grid for the Name
row (likely the bottom row in the Grid pane), to replace the default
entry "Expr1:"
Type
30.
In the Reports
table, click the checkbox to the immediate left of Path, to select
the field into the existing query.
The Diagram and Grid panes appear,
with our selections / additions, as depicted
in Illustration 30.
Illustration 30: Our
Selections and Additions in the Diagram and Grid Panes (Circled)
Now, let's go to the Layout
tab and make the additions to the report layout.
31.
Click the Layout
tab.
32.
Click the box
containing the words "Total Executions."
The
gray column and row headers for the table data region appear.
33.
Right-click
the column header above the box containing the words "Total Executions."
34.
Select Insert
Column to the Right from the context menu that appears, as shown in Illustration
31.
Illustration 31:
Inserting a Column into the Table Data Region
The
new column appears.
35.
Type the
following into the top text box of the new column:
Type
36.
Click the Type
field in the Fields List of the Fields window.
37.
Drag the field
to the bottom row of the new column we created, and labeled Type above.
38.
Drop the field
into the textbox.
The
field appears in the bottom textbox of the new Type column, as depicted
in Illustration 32.
Illustration 32: The
Type Field Appears in the New Type Column
NOTE: If the Fields window is not initially visible in the
Report Designer, select View --> Fields from the main menu to resurrect it.
39.
Right-click
the column header for the column we just added above, now labeled Type.
(Click anywhere in the column to make the header reappear, if necessary).
40.
Select Insert
Column to the Right from the context menu that appears, once again.
The
new column appears.
41.
Type the
following into the top text box of the new column:
Location
42.
Click the Path
field in the Fields List of the Fields window.
43.
Drag the field
to the bottom row of the new column we created, and labeled Location
above.
44.
Drop the field
into the textbox.
The
field appears in the bottom textbox of the new Location column as shown
in Illustration 33.
Illustration 33: The
Path Field Appears in the New Location Column
» 
Comment and Contribute