Master-Detail Relation Editor

When a data source contains two or more queries, click the web-designer-field-list-data-source-edit-relationships button in the Field List to invoke the Master-Detail Relation Editor.

web-report-designer-field-list-edit-relations

The Master-Detail relationship editor allows you to define relationships between queries with the corresponding key fields.

web-report-designer-master-detail-relation-editor

This allows you to create hierarchical data sources that are used to create nested master-detail reports.

Note

Although it is also possible to join different tables within a single query, creating hierarchical data sources is preferred in most cases to provide better performance (in general, master-detail reports are generated faster than similar-looking reports created by grouping “flat” data sources).