Database Reference
In-Depth Information
15.
Drag the selected list into the top header of the master list.
16.
Click an item in the inner list to allow us to create a master-detail relationship between
the lists.
17.
From the
Data
menu, select
Master-Detail Relationships
to open the dialog box.
18.
Click the
New Link
button.
19.
In the
Master
pane, click
Branch
.
20.
In the
Detail
pane, click
Branch
.
The inner report will now be filtered by the branch of the outer report. The filtering
should happen for the month and year also.
21.
Click
New Link
again and match
Month (ship date)
to
Month
.
22.
Click
New Link
again to match
Ye a r ( s h i p d a t e )
to
Ye a r
.
23.
Click
OK
to close the dialog box.
24.
From the toolbar, click
Lock (currently unlocked)
.
The report layout should look like Figure 2.32.
Figure 2.32
All_Products query results
Step 7: Add Prompts and Titles to the Report
1.
In the
Explorer Bar
, mouse over the
Query Explorer
tab and select
Actual_Shipped_
by_Branch
.
2.
In the
Detail Filters
pane of the work area, double-click the filter for
Ye a r ( s h i p d a t e )
.
3.
Replace 2007 with
?Selected Year?
. The expression should look like the following:
[Year (ship date)] = ?Selected Year?
4.
Click
OK
to close the Detail Filter Expression dialog box.
5.
Double-click the filter for
Month (ship date)
.