Skip to main content
BuyLog In
.NET Reporting Tools
Search in…
Docs > Create End-User Reporting Applications > Web Reporting > ASP.NET WebForms Reporting > End-User Report Designer > GUI > Interface Elements > Master-Detail Relation Editor
A newer version of this page is available. .
All docs
V19.1
Reporting
Product Information
Get Started with DevExpress Reporting
Create Popular Reports
Detailed Guide to DevExpress Reporting
Visual Studio Report Designer
Create End-User Reporting Applications
Cross-Platform Reporting
WinForms Reporting
WPF Reporting
Web Reporting
General Information
ASP.NET WebForms Reporting
Print and Export
Document Viewer
End-User Report Designer
Quick Start
GUI
Interface Elements
Design Surface
Field List
Main Menu
Main Toolbar
Properties Panel
Query Builder
Report Explorer
Toolbox
Custom SQL Editor
Expression Editor
Filter Editor
Format String Editor
Master-Detail Relation Editor
Script Editor
Chart Designer
Document Preview
Wizards
API and Customization
Localization
Application Deployment
ASP.NET MVC Reporting
ASP.NET Core Reporting
JavaScript Reporting
Application Security
End-User Documentation
WCF Report Service
Discontinued Platforms
Localization
Redistribution and Deployment
Reporting in .NET Core 3 (CTP)
API Reference
ASP.NET Core API Reference
Client API Reference
Client API Reference (WebForms & MVC)
Download CHM

Master-Detail Relation Editor

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

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

Using this editor, you can define master-detail relationships between queries by specifying their 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).