Database Reference
In-Depth Information
23.
In the lower-left corner of the dialog box, click the
Add
button.
24.
In the Add dialog box, type the report ID of
HR567
.
25.
Click
OK
to close the dialog box.
26.
Click
OK
to close the Default Selections dialog box.
27.
From the
Run
menu, select
Run Report - HTML
to test your report.
The report output should have values similar to those shown in Figure 3.9.
Figure 3.9
Initial page design with a header and footer
28.
Close
IBM Cognos Viewer
to return to your report design.
To protect the report ID from being changed by report consumers, we will hide it.
29.
With the text prompt still selected, change the
Visible
property to
No
.
Step 4: Build the List Report
A list can be created directly by dragging the query from the
Insertable Objects
pane.
1.
From the
Data Items
tab of the
Insertable Objects
pane, drag the
Recruitment_by_
Organization
query into the
Page Body
in the work area.
2.
In the work area, click the
List Column Header
for
Organization name
to select it.
3.
From the toolbar, click the
Section
button.
4.
Click the
List Column Header
for
Branch
to select it.
5.
From the toolbar, click the
Group/Ungroup
button.
The list width will be different in each section based on the length of the data returned,
so we will set the width of the list to a fixed size.