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) .
 
Search WWH ::




Custom Search