XRPivotGridField.FieldName Property

Gets or sets the name of the database field that is assigned to the current Pivot Grid field.

Namespace: DevExpress.XtraReports.UI.PivotGrid

Assembly: DevExpress.XtraReports.v18.2.dll

Declaration

C#

[SRCategory(ReportStringId.CatData)]
public override string FieldName { get; set; }

VB.NET

<SRCategory(ReportStringId.CatData)>
Public Overrides Property FieldName As String

Property Value

Type	Description
String	A String value which is the name of the data field.

Remarks

Use this property to change the data field that is assigned to the current XRPivotGridField object. To specify the text displayed within the field’s header, use the PivotGridFieldBase.Caption property.

In OLAP binding mode, the FieldName property must specify the full name of the bound measure or dimension.

For dimensions, the full name is composed of a dimension’s name, followed by a hierachy’s name, followed by the name of a level(s). All names should be wrapped within square brackets and separated from one another using the dot symbol. Example: “[Customer].[Customer Geography].[Country]”.

For measures, the full name is composed of the “[Measures].” string followed by the measure’s name. Example: “[Measures].[Sales Amount]”.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the FieldName property.

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#

Reporting_how-to-create-custom-total-columns-in-xrpivotgrid-at-runtime-e1064/CS/PivotWithCustomColumnsAtRuntime/Form1.cs#L52

{
    if (e.DataField.FieldName != "TotalPrice")
        return;

VB.NET

Reporting_how-to-create-custom-total-columns-in-xrpivotgrid-at-runtime-e1064/VB/PivotWithCustomColumnsAtRuntime/Form1.vb#L37

fieldTotalPrice.Area = PivotArea.DataArea
fieldTotalPrice.FieldName = "TotalPrice"
pivot.OptionsView.ShowColumnGrandTotals = False