Database Reference
In-Depth Information
29.
From the
To o l b o x
tab in the
Insertable Objects
pane, drag a
Layout Calculation
object to the right of the text in the title. The Report Expression dialog box is displayed.
30.
In the Report Expression dialog box, type the following:
( if ( ParamDisplayValue('Selected Organization') is not null )
then
( 'For '+ParamDisplayValue('Selected Organization')+' in ' )
else
( 'For all organizations in ' ) )
+
if ( ParamDisplayValue('Selected Month') is not null ) then
( ParamDisplayValue('Selected Month') + ' ' +
ParamDisplayValue('Selected Year') )
else
( ParamDisplayValue('Selected Year') )
31.
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 dialog box.
32.
From the
Run
menu, select
Run Report - PDF
to test your report.
When prompted, select
April
,
Finance
, and
2007
. The report table of contents should
have numbers similar to those shown in Figure 3.32.
Figure 3.32
Completed HR briefing book report
33.
Close
IBM Cognos Viewer
to return to your report design.
34.
Save the report.