Database Reference
In-Depth Information
6.
Double-click the filter for
Month
.
7.
Replace
'April'
with
?Selected Month?
. The expression should look like this:
[Employee recruitment (query)].[Time].[Month] = ?Selected Month?
8.
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 Detail Filter Expression dialog box.
9.
Double-click the filter for
Organization name
.
10.
Replace
'Finance'
with
?Selected Organization?
. The expression should look like the
following:
[Organization name] = ?Selected Organization?
11.
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 Detail Filter Expression dialog box.
Now that the prompting has been added, we can add a title that shows the selected values.
12.
In the
Explorer Bar
, mouse over the
Page Explorer
tab and select the
Report Pages
folder.
13.
In the
Report Pages
pane of the work area, click
Page1
to select it.
14.
In the
Properties
pane, change the
Name
property to
Expenses by Manager
.
Now we will change the subtitle of the report to display the selected prompts for the report.
15.
In the
Report Pages
pane, double-click the
Expenses by Manager
page to display it.
16.
Click the
Page Header
to select it.
Since it is a layout component reference, you cannot change anything until you override
specific parts.
17.
In the
Properties
pane, double-click the
Overrides
property to display the dialog box.
18.
Click the check box next to
SubTitle
to select it.
19.
Click
OK
to close the dialog box. Now the work area changes to say
Drop item to over-
ride component child
.
20.
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.
21.
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') + ' ' +