Database Reference
In-Depth Information
13.
In the
Expression Definition
pane, add
= 2007
after the data item.
The Expression should be as follows:
[Employee recruitment (query)].[Time].[Year] = 2007
14.
Click
Va l i d a t e
and then
OK
if there are no errors.
15.
From the
Source
tab of the
Insertable Objects
pane, drag
Month
from the
Time
query
subject into the
Detail Filters
pane of the work area.
16.
In the Expression Definition pane, add
= 'April'
after the data item.
The Expression should be this:
[Employee recruitment (query)].[Time].[Month] = 'April'
17.
Click
Va l i d a t e
and then
OK
if there are no errors.
18.
With the month filter selected, change the
Usage
property to
Optional
in the
Properties
pane.
19.
From the
Data Items
pane in the work area, drag
Organization name
into the
Detail
Filters
pane.
20.
In the
Expression Definition
pane, add
= 'Finance'
after the data item.
The Expression should be as follows:
[Organization name] = 'Finance'
21.
Click
Va l i d a t e
and then
OK
if there are no errors.
22.
With the
Organization
name filter selected, change the
Usage
property to
Optional
in
the
Properties
pane.
23.
From the
Run
menu, select
View Tabular Data
to test your query. The query results
should match what's shown in Figure 3.8.
Figure 3.8
Recruitment_by_Organization query results
24.
Close
IBM Cognos Viewer
to return to your report design.
Step 3: Add the Standard Header and Footer
Before adding any data containers, we will add the header and footer from the layout library and
create the ReportID parameter.