Database Reference
In-Depth Information
6.
In the top center of the dialog box, click the New Link button.
An arrow defining the link between the two queries is displayed.
7.
Ensure that Branch Region is selected in both Master and Detail panes.
8.
Click the New Link button again.
It will seem as though nothing happened; however, there are two links now, one on top
of the other.
9.
Click on the Ye a r in the Master pane and on the Ye a r in the Detail pane.
Yo u r first Master Detail Relationships window should look similar to what's shown in
Figure 6.32.
Figure 6.32
First Master Detail Relationships dialog box
10.
Click OK to close the dialog box.
Now we will build the pie chart.
11.
From the Data Items tab, drag Reason description from the Returns_by_Product_
Line query into the Series (pie slices) drop zone of the pie chart.
12.
Drag Return quantity into the Default measure drop zone of the pie chart.
Search WWH ::




Custom Search