ContextQMD
Back to Devexpress

Create a Cross-Tab Report

xtrareports-4226-create-popular-reports-create-a-cross-tab-report.md

latest6.2 KB
Original Source

Create a Cross-Tab Report

  • Dec 23, 2019
  • 4 minutes to read

This tutorial describes how to use the XRCrossTab control to create a report similar to the Sales Summary Report demo in Visual Studio at design time.

Cross-Tab Report - Page 1

Cross-Tab Report - Page 2

Cross-Tab Report - Page 3

Tip

This tutorial demonstrates how to use the Cross-Tab Report Wizard. See Create a Balance Sheet for information on how to configure the Cross Tab control on the Design Surface.

Add a Cross-Tab Report

  1. Invoke the Report Wizard.

  2. Select Cross-Tab Report and click Next.

  3. (3.1-3.4) Bind a report to a sample Northwind database. You can use the nwind.mdb file from the XtraReports installation (the default path is C:\Users\Public\Public Documents\DevExpress Demos 20.1\Components\Data\nwind.mdb).

  4. Select the SalesPerson view and click Next.

  5. Drop data fields onto cross-tab areas:

  6. Change the report page layout to landscape to ensure the cross-tab content fits the report well. Click Next.

  7. Set the report’s color scheme and click Next.

  8. Specify the report’s title and click Finish.

The generated report contains the XRCrossTab control that is configured based on the specified settings. The XRCrossTab control calculates automatic totals and grand totals across row and column fields.

Tip

Ensure that a report’s DataSource property is not set because the Cross Tab control is located in the Detail band. Otherwise, the Cross Tab data is printed as many times as there are rows in the report data source.

Switch to the Preview tab to see an intermediate result.

As you can see in the image above, the Cross Tab displays data for individual days.

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 the original data by quarters.

Format Data

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

  2. Select the cell bound to the OrderDate field and click its smart tag. Set the Format String option to Quarter {0}.

Customize Appearance

  1. Select the Cross Tab, switch to the Properties window and expand the CrossTabStyles property. Expand the GeneralStyle property and set the BorderColor to 160, 160, 160. This value applies to all Cross Tab cells.

  2. Expand the HeaderAreaStyle property and set the following properties:

  3. Expand the TotalAreaStyle property and set the Font to Calibri, 9pt, style=Bold.

  4. Expand the DataAreaStyle property and set the Font to Calibri, 9pt.

  5. Hold down SHIFT or CTRL, and select the cells that display the grand total values. Go to the Properties window and set the BackColor to 160, 160, 160. This value applies to the selected cells only and overrides the value specified at the area level.

  6. Select the cell bound to the OrderDate field and set the TextAlignment to TopLeft.

Adjust the Content Size

  1. Use a cell’s ColumnAutoWidthMode property to specify whether and how to calculate the cell width. The Report Wizard sets this property to ShrinkAndGrow for row headers and to None for other cells.

  2. Drag the Cross Tab’s handlers to change its size. You can also adjust the size of individual rows and columns.

  3. Move the report title to the Top Margin band to repeat the title on each page and make the Cross Tab occupy the entire page area.

Cross-Tab Report - Page 1

Cross-Tab Report - Page 2

Cross-Tab Report - Page 3