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.
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 Size to Grid Center Horizontally Center Vertically Bring to Front Send to Back Fit Bounds to Container 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 Insert Field in the Column Area Insert Field in the Row Area |
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:
|
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:
|
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 Criteria: Sets a filter criteria applied to data displayed in the Pivot Grid. Enabled: Sets whether to apply a filter criteria specified using the |
Fields |
Related Tutorials
Refer to the following resources for additional help on implementing this control: