[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
  [Expand]Provide Interactivity
  [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)

Introduction to Banded Reports

A report layout consists of bands that contain report controls and define their location on document pages.

Expanded Report Bands

A blank report contains the following bands:

  • The Detail band is printed for every record in a data source unless you filtered the data.

    Every report should have the Detail band, and you cannot delete it.

  • The Top Margin and Bottom Margin bands. These bands are repeated once on every document page.

You can also add the following bands:

  • Report Header and Report Footer

    The Report Header is the report's first band (margins are "out-of-page" zones). Use this band to display the report's name, company logo, date of creation, username, etc.

    The Report Footer is placed before the Page Footer and Bottom Margin on the report's last page. You can use the Report Footer band for report summaries or conclusions.

  • Page Header and Page Footer

    These bands are at the top and bottom of every page in a report. They display information that should be printed on every page.

  • Group Header and Group Footer

    These bands are above and below each group. The Group and Sort Panel (see GroupAndSortDockPanel) create these bands automatically.

Tip

Only the detail and group bands can be used to display dynamic data source contents. Other bands display titles, summaries, and extra information.

The following image illustrates a sample report layout and the Report Explorer that reflects the report's structure:

Expanded Add a Detail Band to a Master-Detail Report

Use the Detail Report band to create hierarchical master-detail reports. Detail report bands provide detailed information about each record in the master report's Detail band (for example, orders shipped to each customer). You can create such reports when master-detail relationships are defined between data source tables:

The Detail Report band is a separate report (subreport) with its own data source and different bands. A report can have any number of detail reports that can also be nested.

The following image illustrates a master-detail report and the Report Explorer that reflects the report's structure:

Expanded Vertical Bands

You can replace the Detail band with the Vertical Header, Vertical Detail and Vertical Total bands to display record fields vertically and print data records horizontally - from left to right (and vise versa if the report's RTL mode is enabled).

To add vertical bands to your report, right-click the report in the Report Designer and choose Insert Vertical Band in the invoked context menu.

Note

If your report's Detail band contains report controls, this band and all these controls are lost when you add a vertical band (the same behavior takes place in the opposite situation).

The following vertical bands are available:

  • Vertical Header
    Contains headers of the report's data fields. These headers are arranged vertically.
  • Vertical Details
    This band is printed for every record in a data source unless you filtered the data. The records are displayed one after another in a horizontal direction.
  • Vertical Total
    This band is placed at the rightmost position (leftmost when RTL is enabled). You can use the Vertical Total band for report summaries or conclusions.

You can use the Report Wizard to create a report with vertical bands. Refer to the Create a Vertical Report topic for instructions on how to create a report based on the Profit and Loss product demo.

Expanded Create Band Copies

You can create band copies, for example, to display different contents based on a specific condition. To do this, add sub-bands to bands.

Tip

See Lay out Dynamic Report Contents for details on how to specify the location of bands' content on document pages.

Expanded Manage Report Bands

Hide Bands in the Report Designer

Click the arrow button on the band's title to collapse or expand the band.

Hide Bands in the Report Document

You can avoid printing a band's content in a document. To do this, set the band's Height property to a zero or its Visible property to false. Select the band and set these properties in the Properties window.

Remove Bands

Select a band on the report design surface and press DELETE. This removes the band and all its content.

Add Bands

To add a band, right-click a report's design surface and choose Insert Band in the invoked context menu.

You can insert the Detail Report band if the report's data source has master-detail relations.

Access the Bands Collection

Click the Edit and Reorder Bands context link in a report's smart tag to access the report's bands collection.

This command is also available in a band's context and smart tag menus.

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