Database Reference
In-Depth Information
13.
In the
Properties
pane, change the
Name
property to
Recruitment by Organization
.
When you change the page name, the layout header will automatically display this prop-
erty as the title of the report.
Now we will change the subtitle of the report to display the selected prompts for the report.
14.
In the
Report Pages
pane, double-click the
Recruitment by Organization
page to dis-
play it.
15.
Click the
Page Header
to select it.
Since it is a layout component reference, you cannot change anything until you override
specific parts.
16.
In the
Properties
pane, double-click the
Overrides
property to display the dialog box.
17.
Click the check box next to
SubTitle
to select it.
18.
Click
OK
to close the dialog box.
Now the work area changes to say
Drop item to override component child
.
19.
From the
To o l b o x
tab in the
Insertable Objects
pane, drag a
Layout Calculation
object into the override component box below the main report title.
The Report Expression dialog box is displayed.
20.
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') )
NOTE
Remember that parameters are case-sensitive, so you should be sure to verify
that the parameter names match exactly those that you added to the filters.
21.
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.
22.
From the
Run
menu, select
Run Report - HTML
to test your report.
When prompted, select
April
,
Finance
, and
2007
. The report output should have
numbers similar to those shown in Figure 3.11.
23.
Close
IBM Cognos Viewer
to return to your report design.