Database Reference
In-Depth Information
Figure 3.18
Completed employee expense report
3.
Select the
Existing...
report template and click
OK
.
An Open dialog box is displayed.
4.
Select
HR List Template
and click
Open
.
Now the template opens, but the report name in the title bar is set to New and there is a
package in the Insertable Objects pane.
We will be using the
Employee expense (query)
and
Employee training (query)
namespaces inside the
HR (query)
folder.
Step 2: Set Up the Training by Manager Query
Even though the query items are coming from different namespaces, the data modeler added rela-
tionships so that the report writer can still take advantage of relationships that may not be directly
shown in the package.
1.
In the
Explorer Bar
, mouse over the
Query Explorer
tab and select the
Queries
folder.
2.
In the work area, click
Query1
to select it.
3.
In the
Properties
pane, rename
Query1
to
Training_by_Manager
.
4.
Double-click on the query to open the query definition.