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.
 
Search WWH ::




Custom Search