Database Reference
In-Depth Information
6.
Replace
'May'
with
?Selected Month?
The expression should look like this:
[Month (ship date)] = ?Selected Month?
7.
Click
OK
to close the Detail Filter Expression dialog box.
8.
Double-click the filter for
Branch
.
9.
Replace
'Bilbao'
with
?Selected Branch?
. The expression should look like this:
[Branch] = ?Selected Branch?
10.
Click
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.
11.
In the
Explorer Bar
, mouse over the
Page Explorer
tab and select
Page1
.
12.
Double-click the text item in the page header to change the title to the following:
Expected Volume vs. Actual Quantity Shipped for
13.
From the
To o l b o x
tab of 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.
14.
In the Report Expression dialog box, type the following:
if( ParamDisplayValue('Selected Branch') <> '' )
then ( ParamDisplayValue('Selected Branch') )
else ( 'All Branches' )
NOTE
Be sure to place two single quotes without a space in the opening condition. This
will check to see whether an optional branch was selected by the user.
15.
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. If prompted, select
April
for the
Month
and
2005
for the
Ye a r
.
16.
With the title text highlighted, click the
Pick up Style
button in the toolbar.
17.
Click the
Layout Calculation
object next to the text in the title area.
18.
From the toolbar, click the
Apply Style
button.
19.
To add the parameter values for the date, drag a
Block
from the
To o l b o x
tab to the right
of the
Layout Calculation
in the title area.
20.
Drag a
Layout Calculation
object from the toolbox and drop it in the newly added block.
21.
In the Report Expression dialog box, type the following:
'For ' + ParamDisplayValue('Selected Month') +
' ' + ParamDisplayValue('Selected Year')