[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]Get Started with DevExpress Reporting
 [Expand]Create Popular Reports
 [Collapse]Detailed Guide to DevExpress Reporting
   Introduction to Banded Reports
  [Expand]Provide Data to Reports
  [Expand]Use Report Controls
  [Expand]Shape Report Data
   Lay out Dynamic Report Contents
  [Expand]Customize Appearance
  [Expand]Add Navigation
  [Collapse]Provide Interactivity
    Create Drill-Down Reports
    Sort a Report in Print Preview
    Content Editing in Print Preview
    Print Preview Mouse Events
    Create Drill-Through Reports
    Obtain a Label's Text in Print Preview
  [Expand]Add Extra Information
  [Expand]Merge Reports
  [Expand]Use Expressions
  [Expand]Store and Distribute Reports
  [Expand]Reporting API
 [Expand]Visual Studio Report Designer
 [Expand]Create End-User Reporting Applications
 [Expand]API Reference
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Create 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?​​​​​​​