[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Collapse]Reporting
 [Expand]Product Information
 [Expand]Getting Started with DevExpress Reporting
 [Expand]Creating Popular Reports
 [Collapse]Detailed Guide to DevExpress Reporting
   Introduction to Banded Reports
  [Expand]Providing Data to Reports
  [Expand]Using Report Controls
  [Expand]Shaping Report Data
   Laying out Dynamic Report Contents
  [Expand]Customizing Appearance
  [Expand]Adding Navigation
  [Collapse]Providing Interactivity
    Creating Drill-Down Reports
    Sorting a Report in Print Preview
    Content Editing in Print Preview
    Print Preview Mouse Events
    Creating Drill-Through Reports
    Obtaining a Label's Text in Print Preview
  [Expand]Adding Customary Information
  [Expand]Merging Reports
  [Expand]Using Expressions
  [Expand]Storing and Distributing Reports
  [Expand]Reporting API
 [Expand]Visual Studio Report Designer
 [Expand]Creating End-User Reporting Applications
 [Expand]API Reference
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
This documentation page describes implementations made in our v17.2 release cycle. To learn about functionality shipping with v18.1, navigate to our updated help file experience at docs.devexpress.com. Learn More

Creating Drill-Down Reports

This tutorial describes how to create a drill-down report. Clicking a link in such a report displays the previously hidden detailed information in the same report:

Tip

The created report is platform-agnostic and its interactive features are supported by the Print Preview available for all application platforms.

Do the following to create a drill-down report:

  1. Create a master-detail report using Detail Report bands.

  2. Drop a label onto the report's detail band. Clicking this label should expand or collapse the hidden report details.

  3. Select the detail report band by clicking its header and expand the drop-down menu for the band's DetailReportBand.DrillDownControl property in the Properties window.

    This menu displays all report controls available on the report band that is one level above the current band in the report bands' hierarchy. Select the corresponding label in the menu to make the label expand or collapse the detail report's band when clicked in the Print Preview.

    You can also specify the band's DetailReportBand.DrillDownExpanded property to define whether or not the band is initially expanded. This property is set to true by default.

  4. Click this label's smart tag and select the Expression property.

    This invokes the Expression Editor where you can make the label display different text based on the detail report's DrillDownExpanded property value.

Is this topic helpful?​​​​​​​