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.
- Data Field: A field or fields that have been added to the Data Header Area (2)
- Data Header Area: Contains any Data Fields
- Data Area: Displays data cells, total cells and grand total cells.
- Column Field Header: Displays the caption from the field or fields added to the Column Field Header.
- Column Field Values: Displays values from the field as column headers.
- Column Grand Total: Column that displays summary totals calculated against all columns.
- Row Field Header: Displays the caption from the field or fields added to the Row Field Header.
- Row Field Values: Displays values from the field as row headers.
- 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.
- Actions: Align to Grid, Size to Grid, Center Horizontally, Center Vertically, Bring to Front, Send to Back, Fit Bounds to Container
- Styles: Even Style, Odd Style, Style
- Appearance: Background Color, Border Color, Border Dash Style, Border Width, Borders, Font Name, Font Size, Font Unit, Font Effects, Foreground Color, Padding
- Behavior: Can Publish, Keep Together, Visible
- Data: Tag
- Design: Name
- Layout: Location, Size
- Navigation: Bookmark, Parent Bookmark, Navigation URL
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:
|
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: