PivotGridControl.RetrieveFields() Method

Creates PivotGridField objects for all the fields in the bound data source.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v19.1.dll

Declaration

C#

public void RetrieveFields()

VB.NET

Public Sub RetrieveFields

Remarks

This method clears the field collection and adds new PivotGridField objects to the collection for all the fields in the control’s bound data source. The PivotGridFieldBase.FieldName property of each field is set to the respective bound field’s name. The created fields are made visible and displayed within the Filter Header Area.

Use the PivotGridControl.Fields property to access the field collection. It allows fields to be added and removed. For instance, you can add an unbound field to the collection that will represent arbitrary data within the PivotGridControl. For more information on unbound fields, refer to the PivotGridFieldBase.UnboundType topic.

To create fields asynchronously, use the PivotGridControl.RetrieveFieldsAsync method.

To learn more about fields, see Pivot Grid Fields.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the RetrieveFields() method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-prevent-pivotgrid-from-getting-properties-values-e945/CS/Form1.cs#L18

pivotGridControl1.DataSource = new DataSourceWrapper(ReportType.Report1, fakeDataSource);
pivotGridControl1.RetrieveFields();
pivotGridControl2.DataSource = new DataSourceWrapper(ReportType.Report2, fakeDataSource);

how-to-prevent-pivotgridfieldoptions-property-from-being-serialized-e2230/CS/DxSample/Form1.cs#L20

pivotGrid1.DataSource = CreateTable(10);
pivotGrid1.RetrieveFields();
for(int i = 0; i < pivotGrid1.Fields.Count; i++) {

how-to-replace-the-default-filter-popup-with-a-custom-one-e4897/CS/E4669CS/Form1.cs#L38

pivotGridControl1.DataSource = this.customerReportsBindingSource;
pivotGridControl1.RetrieveFields();
pivotGridControl1.Fields["CompanyName"].Area = PivotArea.RowArea;

how-to-use-an-external-filtercontrol-to-filter-a-pivotgridcontrol-e2170/CS/WinFormsExample/Form1.cs#L13

myPivotGridControl1.DataSource = CreateDataSource();
myPivotGridControl1.RetrieveFields();
myPivotGridControl1.Fields["RowField1"].Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;

winforms-pivot-grid-draw-a-custom-element-on-mouse-hover/CS/WindowsApplication73/Form1.cs#L23

pivotGridControl1.DataSource = CreateTable(500);
pivotGridControl1.RetrieveFields();
pivotGridControl1.Fields["Order"].Area = PivotArea.RowArea;

VB.NET

how-to-prevent-pivotgrid-from-getting-properties-values-e945/VB/Form1.vb#L20

pivotGridControl1.DataSource = New DataSourceWrapper(ReportType.Report1, fakeDataSource)
pivotGridControl1.RetrieveFields()
pivotGridControl2.DataSource = New DataSourceWrapper(ReportType.Report2, fakeDataSource)

how-to-prevent-pivotgridfieldoptions-property-from-being-serialized-e2230/VB/DxSample/Form1.vb#L22

pivotGrid1.DataSource = CreateTable(10)
pivotGrid1.RetrieveFields()
For i As Integer = 0 To pivotGrid1.Fields.Count - 1

how-to-replace-the-default-filter-popup-with-a-custom-one-e4897/VB/Form1.vb#L37

pivotGridControl1.DataSource = Me.customerReportsBindingSource
pivotGridControl1.RetrieveFields()
pivotGridControl1.Fields("CompanyName").Area = PivotArea.RowArea

how-to-use-an-external-filtercontrol-to-filter-a-pivotgridcontrol-e2170/VB/WinFormsExample/Form1.vb#L15

myPivotGridControl1.DataSource = CreateDataSource()
myPivotGridControl1.RetrieveFields()
myPivotGridControl1.Fields("RowField1").Area = DevExpress.XtraPivotGrid.PivotArea.RowArea

winforms-pivot-grid-draw-a-custom-element-on-mouse-hover/VB/WindowsApplication73/Form1.vb#L20

pivotGridControl1.DataSource = CreateTable(500)
pivotGridControl1.RetrieveFields()
pivotGridControl1.Fields("Order").Area = PivotArea.RowArea