Database Reference
In-Depth Information
Step 6: Complete the Formatting
1.
In the work area, click the title text to select it.
2.
In the
Properties
pane, change the
Source Type
to
Report Expression
.
3.
Double-click the
Report Expression
property to open the dialog box.
4.
In the
Report Expression
pane, type the following function:
ParamDisplayValue('Selected Time') +
' Returns for Products Under ' +
ParamDisplayValue('Selected Product')
This function returns the first member of a set. Since
Time
is selected as a single item,
there will be only one item in the set.
5.
Click
Va l i d a t e
and
OK
if the validation returned no errors.
6.
In the work area, click
Time Group
and Ctrl-click
Time
to select both columns of the
crosstab.
7.
In the
Properties
pane, change the
Horizontal Alignment
to
Center
.
8.
Double-click the
Size & Overflow
property to open the dialog box.
9.
Change the
Width
to
70
pixels.
This will allow for more spacing on the screen and make the crosstab look less cluttered.
10.
Click
OK
to close the dialog box.
11.
In the work area, click in the center whitespace to select the
Page Body
.
12.
In the
Properties
pane, double-click the
Padding
property to open the dialog box.
13.
Type
40
pixels in the top padding field to ensure spacing between the title and the details.
14.
Click
OK
to close the dialog box.
15.
From the toolbar, click
Center
.
16.
From the
Run
menu, select
Run Report - HTML
to test your report. If prompted,
expand
Products
and select
Camping Equipment
. Also, expand
Time
and select
2005
.
The report output should have numbers similar to Figure 2.26.
17.
Close
IBM Cognos Viewer
to return to your report design.
18.
Save the report as
Product Returns by Time Period
.
Product Returns by Time Period provides an example of using dimensional query calculations to
create complex queries that take advantage of sets (edges) and tuples (intersections) to perform
complex behaviors when building queries.