Master detail relationships link information between two data containers (such as list crosstab or chart) within a report: a master data container and a detail data container.
Using a master detail relationship you can use a single report to display information that would normally take two reports.
Master detail relationship can be created for any data container within Report Studio.
1. Create or open a report to use that has one data
container (i.e. a crosstab report)
2. From the Toolbox tab drag a container object next to the container in the work area (i.e. a chart- drag items from the insertable objects pane)
3. Select the second container and drag it into the first container where you want to place it.
4. Click the embedded object to select it.
5. From the Data Menu click Master Detail Relationships to create the master detail links.
6. Click New Link and select the data items from each query that you want to link to the master detail relationship.
