Database Reference
In-Depth Information
20.
Click
OK
.
21.
Drag another
Te x t I t e m
object from the
Insertable Objects
pane to the left of the
Quantity
data item in the table.
22.
Type
To t a l i t e m s s o l d :
and add a space after the colon.
23.
Click
OK
.
24.
Drag a third
Te x t I t e m
from the
Insertable Objects
pane to the left of the
Return/Ship
Ratio
data item in the table.
25.
Type
Return/Ship Ratio:
and add a space after the colon.
26.
Click
OK
.
27.
To format the table, click an item inside the table object to select it.
28.
In the
Properties
pane, click the
Select Ancestor
button.
29.
Click the
Ta b l e
object in the list.
30.
Double-click the
Margin
property.
The Margin dialog box is displayed.
31.
Set all margins to
25
pixels.
32.
Click
OK
to close the dialog box.
33.
Change the
Horizontal Alignment
property to
Center
.
34.
Double-click the
Ta b l e P ro p e r t i e s
property.
The Table Properties dialog box is displayed.
35.
Deselect the
Collapse Borders
check box.
The Cell Spacing options are now available.
36.
Set the
Cell Spacing
to
10
pixels.
This adds spacing between the cells within the table itself to make it look as though
there are three different singleton items.
37.
Click
OK
to close the dialog box.
38.
On the toolbar, click the
Bold
button to change all the text in the table to bold weight.
39.
From the
Run
menu, select
Run Report - HTML
to test your report. If prompted,
expand
Employee by region
and select
Americas
.
The completed report should look as shown in Figure 2.19.
40.
Close
IBM Cognos Viewer
to return to your report design.
41.
Save the report as
Return/Ship Ratio by Location
.