PivotGridFieldBase.Visible Property

Gets or sets whether the field is visible.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v24.1.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

Declaration

C#

[TypeConverter(typeof(BooleanTypeConverter))]
[XtraSerializableProperty(XtraSerializationFlags.DefaultValue, 1000)]
[XtraSerializablePropertyId(3)]
public virtual bool Visible { get; set; }

VB.NET

<XtraSerializableProperty(XtraSerializationFlags.DefaultValue, 1000)>
<XtraSerializablePropertyId(3)>
<TypeConverter(GetType(BooleanTypeConverter))>
Public Overridable Property Visible As Boolean

Property Value

Type	Description
Boolean	true if the field is visible; false otherwise.

Remarks

If a field is hidden it can still be accessed via the Customization form. To prevent a hidden field from being displayed within the Customization form set its PivotGridFieldOptions.ShowInCustomizationForm property to false.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Visible 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#

winforms-pivot-grid-connect-to-an-olap-datasource/CS/WinOlapRetrieveFieldsExample/Form1.cs#L33

pivotGridControl1.Fields["[Customer].[Country].[Country]"].Area = PivotArea.RowArea;
pivotGridControl1.Fields["[Customer].[Country].[Country]"].Visible = true;
pivotGridControl1.Fields["[Customer].[City].[City]"].Area = PivotArea.RowArea;

web-forms-pivot-grid-group-field-values-into-the-specified-intervals/CS/CustomGroupInterval/Default.aspx.cs#L37

case 0:
    ASPxPivotGrid1.Fields[0].Visible = true;
    ASPxPivotGrid1.Fields[0].Caption = "Product Group";

web-forms-pivot-grid-change-summary-display-mode/CS/SummaryDisplayMode/Default.aspx.cs#L44

if(SourceDataField != null)
    cbShowRawValues.Checked = SourceDataField.Visible;
ConfigureSummaryDisplayTypeComboBox(SelectedGroup);

winforms-pivot-create-user-folders-within-the-customization-form/CS/XtraPivotGrid_UserFolders/Form1.cs#L22

fieldSalesPerson1.DisplayFolder = "Employees";
fieldSalesPerson1.Visible = false;

winforms-pivot-totals-visibility/CS/Form1.cs#L30

for(int i = 0; i < pivotGridControl.Fields.Count; i++) {
    if(pivotGridControl.Fields[i].Visible && pivotGridControl.Fields[i].Area == field.Area
        && pivotGridControl.Fields[i].AreaIndex > field.AreaIndex)

VB.NET

winforms-pivot-grid-connect-to-an-olap-datasource/VB/WinOlapRetrieveFieldsExample/Form1.vb#L34

pivotGridControl1.Fields("[Customer].[Country].[Country]").Area = PivotArea.RowArea
pivotGridControl1.Fields("[Customer].[Country].[Country]").Visible = True
pivotGridControl1.Fields("[Customer].[City].[City]").Area = PivotArea.RowArea

web-forms-pivot-grid-group-field-values-into-the-specified-intervals/VB/CustomGroupInterval/Default.aspx.vb#L44

Case 0
    ASPxPivotGrid1.Fields(0).Visible = True
    ASPxPivotGrid1.Fields(0).Caption = "Product Group"

web-forms-pivot-grid-change-summary-display-mode/VB/SummaryDisplayMode/Default.aspx.vb#L67

cbAllowCrossGroupVariation.Visible = isVariation
If SourceDataField IsNot Nothing Then cbShowRawValues.Checked = SourceDataField.Visible
ConfigureSummaryDisplayTypeComboBox(SelectedGroup)

winforms-pivot-create-user-folders-within-the-customization-form/VB/XtraPivotGrid_UserFolders/Form1.vb#L24

fieldSalesPerson1.DisplayFolder = "Employees"
fieldSalesPerson1.Visible = False

winforms-pivot-totals-visibility/VB/Form1.vb#L34

For i As Integer = 0 To pivotGridControl.Fields.Count - 1
    If pivotGridControl.Fields(i).Visible AndAlso pivotGridControl.Fields(i).Area = field.Area AndAlso pivotGridControl.Fields(i).AreaIndex > field.AreaIndex Then
        Return False