Database Reference
In-Depth Information
6.
With the
Branch
list column header selected, click the
Select Ancestor
button in the
Properties
pane.
Notice that the section created a nested list within a list.
7.
From the
Select Ancestor
list, click the
List
object closest to the
Properties
pane.
The work area should show the inner list highlighted.
8.
In the
Properties
pane, double-click the
Size & Overflow
property to open the dialog box.
9.
Change the
Width
to
700 px
.
This is an alternative to setting the size of each column.
10.
Click
OK
to close the dialog box.
11.
Select the
List Column Body
for
Days to fill
.
12.
From the toolbar, select
Summarize
to display the list of aggregate options, and select
Automatic Summary
.
Since the aggregation in the model is set to Average, the summary footer will inherit the
function and generate an average of all details.
COGNOS 8 NOTE
The
Summarize
toolbar button is the
Aggregate
button and the
Automatic Summary
option is also
Aggregate
in IBM Cognos 8 Report Studio.
13.
From the
Run
menu, select
Run Report - HTML
to test your report. The report output
should have numbers similar to those shown in Figure 3.10.
14.
Close
IBM Cognos Viewer
to return to your report design.
Step 5: Add Prompts and Titles to the Report
In this final step, the query filters will become parameter-based. Since this report will be inte-
grated with others in this chapter, care should be given to ensure that the parameter names are
consistent through the later reports.
The final tasks in this step override one of the layout component references to provide filter
details in the subtitle of the report. The report title will continue to be the actual name of the page.
1.
In the
Explorer Bar
, mouse over the
Query Explorer
tab and select the
Recruitment_by_Organization
query.
2.
In the
Detail Filters
pane of the work area, double-click the filter for
Ye a r
.
3.
Replace
2007
with
?Selected Year?
. The expression should look like this:
[Employee recruitment (query)].[Time].[Year] = ?Selected Year?
4.
Va l i d a t e t h e e x p r e s s i o n a n d c l i c k
OK
to close the Detail Filter Expression dialog box.
When prompted, type
2007
for the year.