Database Reference
In-Depth Information
17.
From the
Data Items
pane in the work area, drag
Organization name
into the
Detail
Filters
pane.
18.
In the
Expression Definition
pane, add
= 'Finance'
after the data item.
The Expression should be as follows:
[Organization name] = 'Finance'
19.
Click
Va l i d a t e
and then
OK
if there are no errors.
20.
With the
Organization name
filter selected, change the
Usage
property to
Optional
in
the
Properties
pane.
21.
From the
Run
menu, select
View Tabular Data
to test your query. The query results
should match what's shown in Figure 3.19.
Figure 3.19
Tr a i n i n g _ b y _ M a n a g e r query results
22.
Close
IBM Cognos Viewer
to return to your report design.
Step 3: Change the Page Name and Report ID
Since the template has details about how to build the title and ReportID, we will now make those
changes.
1.
In the
Explorer Bar
, mouse over the
Page Explorer
and select the
Report Pages
folder. The report page still shows “Change the Page Name to Add the Report Title.”
2.
In the work area, click the page to select it.