Skip to main content
BuyLog In
.NET Reporting Tools
Search in…
Docs > Reporting for Web > End-User Report Designer for Web > Interface Elements > Master-Detail Relation Editor
All docs
V23.2
Reporting
Product Information
.NET / .NET Core Support
Get Started with DevExpress Reporting
Create Different Report Types (Walkthroughs)
Detailed Guide to DevExpress Reporting
Localize Reporting Applications
Security Considerations
Visual Studio Report Designer
VS Code Report Designer
Reporting for Desktop
Reporting for .NET MAUI
Reporting for Web
Common Features
Document Viewer for Web
End-User Report Designer for Web
Interface Elements
Design Surface
Field List
Parameter Editor
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
Localization Editor
Report Design Analyzer
Document Preview
Wizards
Web UI Development Bundles that Include Reports
Reporting for Blazor
Reporting for ASP.NET Core
Reporting for Angular
Reporting for Knockout-based Applications
Reporting for React
Reporting for Vue
Reporting for ASP.NET MVC
Reporting for ASP.NET Web Forms
Version Upgrade Guide
Troubleshooting
Cloud Integration
Cross-Platform .NET App UI
Backend Web API Service / REST API for Reporting
WCF Report Service
End-User Documentation
Redistribution and Deployment
API Reference
ASP.NET Core API Reference
Blazor API Reference
Client API Reference
Client API Reference (Web Forms & MVC)
Download CHM

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).