The final step is to establish the relationship among the master chart, the parameter, and the detail chart.
- Open the Property sheet by double clicking on the set of pie slices. These are the chart elements that will initiate the drill-down.
- Specify the parameter to set. This is the parameter used in the detail query's SQL SELECT statement.
- Specify the column on which the master-detail relationship is based.
- Specify the name of the query on which the detail chart is based.
|
|
|
|