magritton
6/11/2014 - 6:18 PM

Pivot grid cell style based both on value of the cell and value to the column area item

Pivot grid cell style based both on value of the cell and value to the column area item

DE Pivot Grid Cell Style
content_copyfile_download
protected void pvGrid_CustomCellStyle(object sender, DevExpress.Web.ASPxPivotGrid.PivotCustomCellStyleEventArgs e)
        {
            if (e.ColumnValueType != DevExpress.XtraPivotGrid.PivotGridValueType.Value ||
        e.RowValueType != DevExpress.XtraPivotGrid.PivotGridValueType.Value) return;
            if (e.ColumnField.FieldName == "[Current Backlog].[Effective Month].[Effective Month]" && e.GetFieldValue(e.ColumnField).ToString() == "Past Due")
            {
                if (e.Value != null)
                    e.CellStyle.BackColor = Color.Red;
                //int intV = Convert.ToInt32(e.Value);
                //Console.WriteLine(e.GetFieldValue(e.ColumnField).ToString());
                //string test = e.GetFieldValue(e.ColumnField).ToString(); 
            }
     
        }