Fields Page

  • 2 minutes to read

The Fields page allows you to create or delete fields, and customize individual fields using the built-in property grid.

DesignerDialog

Field List

This list displays the available data source fields. The Field List can be hidden/shown by clicking the ShowFieldListButton button. The bold items indicate that the Pivot Grid Control has no field bound to this data source field. You can double click or drag items to the PivotGrid Fields to create fields bound to the data source field.

PivotGrid Fields

This list displays the Pivot Grid Control fields contained within the PivotGridControl.Fields collection. The settings of the currently selected field can be accessed and changed via the property grid. Note that you can customize the settings for multiple fields simultaneously. Hold down the SHIFT or CTRL key while clicking field names to select multiple fields.

Button Pane

This pane displays the buttons that are used to manage the fields collection.

Button

Description

ShowHideFieldList

The Show/Hide Field List button displays or hides the Field List containing the available data source fields.

SearchBoxes

The Search Boxes button displays or hides search panels in the Field List and PivotGrid Fields panes.

RetrieveFieldsButton

The Retrieve Fields button creates fields for all fields in the bound data source. Any existing fields are deleted first. New fields are created in the same order as the bound fields appear in the data source.

AddNewFieldButton

The Add Field button creates a new field and adds it to the collection.

InsertNewFieldButton

The Insert Field button creates a new field and adds it at the currently selected position.

RemoveFieldButton

The Remove Field button removes the selected field from the collection.

Hold down the SHIFT or CTRL key while clicking field names to select and remove multiple fields.

MoveUpButton

The Move Up button swaps the selected field with the previous item.

MoveDownButton

The Move Down button swaps the selected field with the next item.