ContextQMD
Back to Devexpress

Cross-Tab Reports

eud-eud-for-devexpress-reports-reporting-for-web-report-designer-create-reports-cross-tab-reports.md

latest4.2 KB
Original Source

Cross-Tab Reports

  • Feb 09, 2026
  • 3 minutes to read

A cross-tab report displays complex multi-dimensional data, such as summary statistics, surveys, and market research information. This report uses a Cross Tab control that calculates automatic summaries and grand totals across grouped rows and columns.

Add a Cross Tab Control and Bind to Data

  1. Create a new report or open an existing one.

  2. Drop the Cross Tab control from the Toolbox onto the Detail band.

  3. Invoke the designer menu and click Add Data Source….

  4. Select the entire Cross Tab control. For this, click the designer surface outside the control and drag the mouse to the control until the entire control is selected.

  5. Bind the Cross Tab control to the data source. In the Properties Panel expand the CROSS TAB TASKS section and specify the Data Source and Data Member properties.

Define Cross Tab Fields

  1. In the Properties Panel , expand the DATA section and click plus in the ROW FIELDS section to add a Row Field. Select the field name from the drop-down list:

  2. In the Properties Panel , expand the DATA section and click plus in the COLUMN FIELDS section to add a Column Field. Select the field from the drop-down list:

  3. In the Properties Panel , expand the DATA section and click plus in the DATA FIELDS section to add a Data Field. Select the field from the drop-down list:

The resulting cross-tab control looks as follows:

Specify Group Settings

Select the Cross Tab cell bound to the OrderDate field and click its smart tag. Set the GroupInterval property to DateQuarter to group data by quarters.

Switch to the Report Viewer to preview the result:

Format Data

  1. Format the currency data. Hold down CTRL, and select the following cells:

  2. Select the cell bound to the OrderDate field:

Switch to the Report Viewer to observe the result:

Customize Appearance

  1. Select the entire Cross Tab control, switch to the Properties window, and expand the STYLES section. Expand the GENERAL STYLE section and set the Border Color to 160, 160, 160. This value applies to all Cross Tab cells.

  2. Expand sections for the HEADER AREA , DATA AREA and TOTAL AREA styles and adjust the appearance as your needs dictate.

Adjust the Content Size

Select the column bound to the FullName field and set the ColumnAutoWidthMode property to ShrinkAndGrow. The column width varies depending on the content.

Adjust the Report Layout

Specify the Landscape page orientation and set the Vertical Content Splitting option to Smart to prevent content from being split across pages.

Observe the Result

Switch to the Report Viewer. The resulting report is shown below: