C# (CSharp) DevExpress.Web.ASPxPivotGrid PivotCustomFieldValueCellsEventArgs Examples

Example #1

File: Default.aspx.cs Project: DevExpress-Examples/how-to-hide-an-empty-grand-total-column-e3957

    protected void ASPxPivotGrid1_CustomFieldValueCells(object sender, DevExpress.Web.ASPxPivotGrid.PivotCustomFieldValueCellsEventArgs e)
    {
        bool isColumn = true;

        for (int i = e.GetCellCount(isColumn) - 1; i >= 0; i--)
        {
            FieldValueCell cell = e.GetCell(isColumn, i);
            if (cell != null)
            {
                e.Remove(cell);
            }
        }
    }

Example #2

File: Default.aspx.cs Project: DevExpress-Examples/how-to-hide-specific-total-rows-and-columns-field-values-e2752

    protected void ASPxPivotGrid1_CustomFieldValueCells(object sender, DevExpress.Web.ASPxPivotGrid.PivotCustomFieldValueCellsEventArgs e)
    {
        PivotGridField fieldYear = ASPxPivotGrid1.Fields["fieldOrderYear"];

        if (fieldYear.Area == PivotArea.ColumnArea || fieldYear.Area == PivotArea.RowArea)
        {
            bool isColumn = fieldYear.Area == PivotArea.ColumnArea;
            for (int i = e.GetCellCount(isColumn) - 1; i >= 0; i--)
            {
                FieldValueCell cell = e.GetCell(isColumn, i);
                if (unnecessaryYearTotals.Contains(cell.Value) && cell.ValueType == PivotGridValueType.Total)
                {
                    e.Remove(cell);
                }
            }
        }
    }