Database Reference
In-Depth Information
Figure 3.10
Initial list report design
5.
Double-click the filter for
Month
to open the Detail Filter Expression dialog box.
6.
Replace
'April'
with
?Selected Month?
. The expression should look like this:
[Employee recruitment (query)].[Time].[Month] = ?Selected Month?
7.
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.
This time you were not prompted for a month, since this filter was an optional one.
8.
Double-click the filter for
Organization name
.
9.
Replace
'Finance'
with
?Selected Organization?
. The expression should look like the
following:
[Organization name] = ?Selected Organization?
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 the
Report Pages
folder.
12.
In the
Report Pages
pane of the work area, click
Page1
to select it.