Pivot Grid Control

Description

Allows you to create a pivot table for multi-dimensional analysis of large amounts of data.

The image below is an example of a Pivot Grid at runtime.

  1. Data Field: A field or fields that have been added to the Data Header Area (2)
  2. Data Header Area: Contains any Data Fields
  3. Data Area: Displays data cells, total cells and grand total cells.
  4. Column Field Header: Displays the caption from the field or fields added to the Column Field Header.
  5. Column Field Values: Displays values from the field as column headers.
  6. Column Grand Total: Column that displays summary totals calculated against all columns.
  7. Row Field Header: Displays the caption from the field or fields added to the Row Field Header.
  8. Row Field Values: Displays values from the field as row headers.
  9. Row Grand Total: Row that displays summary totals calculated against all rows.

Properties Common to Most Controls

For more information about the properties listed below, see Properties Common to Most Controls.

For more information regarding each of the property groups, see the Control Reference.

Actions

Actions

Align to Grid  Snaps the upper left corner of the control to the grid.

Size to Grid Resizes the control so all four corners are snapped to the grid.

Center Horizontally Centers the control within the width of the parent container.

Center Vertically Centers the control within the height of the parent container.

Bring to Front Positions the control in front of any overlapping controls.

Send to Back Positions the control behind any overlapping controls.

Fit Bounds to Container Resizes the control to occupy the entire parent container, excluding the borders.

    A container includes a band or a panel.

    This property is only enabled if the control is the only item in the container.

Insert Field in the Data Area Inserts a field into the Data Header Area.

Insert Field in the Column Area Inserts a field into the Column Field Header.

Insert Field in the Row Area Inserts a field into the Row Field Header.

Data Source

Type: Object

Sets the control's data source. If left empty, the report's data source is used.

Data Member

Type: String

Specifies the data source table, which supplies data to the control.

Behavior

Anchor Vertically

Sets the location of the control in relation to the parent container. When the parent container changes size, the control may move or resize to maintain its position.

The options for vertically anchoring include:

  • None: The control's size and location are not affected when the container size changes.
  • Top: The distance between the top of the control and the top of the container remains fixed when the container size changes.
  • Bottom: The distance between the bottom of the control and the bottom of the container remains fixed when the container size changes.
  • Both: The distance from the top and bottom of the control from the top and bottom of the container remains fixed when the container size changes. This means that control is resized to maintain these fixed distances.

Anchor Horizontally

Sets the location of the control in relation to the parent container. When the parent container changes size, the control may move or resize to maintain its position.

The options for horizontally anchoring include:

  • None: When the parent container changes size, the control's size and location are not affected when the container size changes.
  • Left: The distance between the left edge of the control and the left side of the container remains fixed when the container size changes.
  • Right: The distance between the right edge of the control and the right side of the container remains fixed when the container size changes.
  • Both: The distance from the left and right edges of the control from the left and right sides of the container remains fixed when the container size changes. This means that control is resized to maintain these fixed distances.

Data

Data Source

Type: Object

Sets the control's data source. If left empty, the report's data source is used.

Data Member

Type: String

Specifies the data source table, which supplies data to the control.

Prefilter

The Prefilter property contains the following options:

Criteria: Sets a filter criteria applied to data displayed in the Pivot Grid.

Enabled: Sets whether to apply a filter criteria specified using the Criteria property.

Fields

Related Tutorials

Refer to the following resources for additional help on implementing this control: