private void pivotGridControl1_CustomCellValue(object sender, PivotCellValueEventArgs e)
{
if (e.DataField == fieldProductAmount1 && e.Value != null)
{
List <object> rowValues = new List <object>();
foreach (PivotGridField field in e.GetRowFields())
{
rowValues.Add(UpdateValue(field, e.RowIndex, e));
}
List <object> columnValues = new List <object>();
foreach (PivotGridField field in e.GetColumnFields())
{
columnValues.Add(UpdateValue(field, e.ColumnIndex, e));
}
decimal previousValue = Convert.ToDecimal(e.GetCellValue(columnValues.ToArray(), rowValues.ToArray(), fieldProductAmount));
decimal value = Convert.ToDecimal(e.GetCellValue(fieldProductAmount));
if (previousValue == 0m || e.Value == null)
{
e.Value = null;
}
else
{
e.Value = ((decimal)e.Value / previousValue - 1);
}
}
}
private void pivotGridControl1_CustomCellValue(object sender, PivotCellValueEventArgs e)
{
if (e.DataField == fieldQuantityPercent)
{
e.Value = Convert.ToDecimal(e.Value) * 100;
}
}
void pivotGridControl_CustomCellValue(object sender, PivotCellValueEventArgs e)
{
if (e.Value != null && (decimal)e.Value < 2000)
{
e.Value = "Too low to show";
}
}
private void PivotGridControl1_CustomCellValue(object sender, PivotCellValueEventArgs e)
{
if (e.DataField == fieldDiscount && e.RowValueType == FieldValueType.GrandTotal)
{
e.Value = String.Empty;
}
}
// some custom logic to demonstrate the approach in action
private void OnPivotCustomCellValue(object sender, PivotCellValueEventArgs e)
{
if (e.DataField == fieldExtendedPriceUnbound)
{
PivotDrillDownDataSource ds = e.CreateDrillDownDataSource();
decimal value = 0;
Dictionary <PivotGridField, object> columnFieldValues = new Dictionary <PivotGridField, object>();
PivotGridField[] columnFields = e.GetColumnFields();
foreach (PivotGridField field in columnFields)
{
columnFieldValues[field] = e.GetFieldValue(field);
}
for (int i = 0; i < ds.RowCount; i++)
{
bool skip = false;
foreach (PivotGridField field in columnFields)
{
if (!Comparer.Equals(ds[i][field], columnFieldValues[field]))
{
skip = true;
break;
}
}
if (skip)
{
continue;
}
decimal v1 = Convert.ToDecimal(ds[i][e.DataField]);
value += v1;
}
e.Value = value;
}
}
private void pivotGridControl1_CustomCellValue(object sender, PivotCellValueEventArgs e)
{
// Calculates the 'Percent' field values.
if (e.DataField.Name == "PercentOfBeverages")
{
// Do not display grand total values.
if (e.RowValueType == PivotGridValueType.GrandTotal)
{
e.Value = null;
return;
}
var rowValues = e.GetRowFields().Select(f => f.FieldName == "CategoryName" ? "Beverages" : e.GetFieldValue(f)).ToArray();
var columnValues = e.GetColumnFields().Select(f => f.FieldName == "CategoryName" ? "Beverages" : e.GetFieldValue(f)).ToArray();
decimal beveragesValue = Convert.ToDecimal(e.GetCellValue(columnValues, rowValues, e.DataField));
if (beveragesValue == 0)
{
e.Value = null;
}
else
{
e.Value = Convert.ToDecimal(e.Value) / beveragesValue;
}
}
else
{
return;
}
}
/// <summary>
/// отобразим сумму ФОТ по проекту только в итоговой строке
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void PV_CustomCellValue(object sender, PivotCellValueEventArgs e)
{
if (e != null && e.DataField != null && e.DataField.FieldName == "SumFOT" && e.ColumnValueType != PivotGridValueType.Value && e.RowValueType == PivotGridValueType.Value)
{
e.Value = 0;
}
}
// Returns a list of summary values against which
// a Custom Total will be calculated.
private ArrayList GetSummaryValues(PivotCellValueEventArgs e)
{
ArrayList values = new ArrayList();
// Creates a summary data source.
PivotSummaryDataSource sds = e.CreateSummaryDataSource();
// Iterates through summary data source records
// and copies summary values to an array.
for (int i = 0; i < sds.RowCount; i++)
{
object value = sds.GetValue(i, e.DataField);
if (value == null)
{
continue;
}
values.Add(value);
}
// Sorts summary values.
values.Sort();
// Returns the summary values array.
return(values);
}
private void pivotGridControl1_CustomCellValue(object sender, PivotCellValueEventArgs e)
{
//if (fieldAMOUNT1.Equals(e.DataField))
//{
// if (e.ColumnCustomTotal == null && e.RowCustomTotal == null) return;
// // Obtains a list of summary values against which
// // the Custom Total will be calculated.
// ArrayList summaryValues = GetSummaryValues(e);
// // Obtains the name of the Custom Total that should be calculated.
// string customTotalName = GetCustomTotalName(e);
// // Calculates the Custom Total value and assigns it to the Value event parameter.
// e.Value = GetCustomTotalValue(summaryValues, customTotalName);
//PivotDrillDownDataSource ds = e.CreateDrillDownDataSource();
//decimal summary = 0;
//decimal dval = 0;
//decimal cval = 0;
//for (int i = 0; i < ds.RowCount; i++)
//{
// string name = Convert.ToString(ds[i][fieldCashName1]);
// decimal value = Convert.ToDecimal(ds[i][fieldAMOUNT1]);
// if (name.Substring(0, name.Length) == "1" || name.Substring(0, name.Length) == "2" || name.Substring(0, name.Length) == "3" || name.Substring(0, name.Length) == "5")
// dval += value;
// else
// cval += value;
//}
//if (cval == 0)
// e.Value = -1 * dval;
//}
}
private void pivotGridControl1_CustomCellValue(object sender, PivotCellValueEventArgs e)
{
if (e.DataField == fieldLowLevel)
{
PivotGridField lastLevelField = pivotGridControl1.GetFieldsByArea(PivotArea.RowArea).Last();
if (e.RowValueType == PivotGridValueType.Total ||
e.RowValueType == PivotGridValueType.GrandTotal ||
e.RowField != lastLevelField)
{
e.Value = null;
}
}
}
private void pvt_datos2_CustomCellValue(object sender, PivotCellValueEventArgs e)
{
if (e.RowValueType == PivotGridValueType.Total)
{
e.Value = null;
/* for (int index = e.RowIndex - 1; index >= 0 && e.Value == null; index--)
* {
* if (!Comparer.Equals(pvt_datos2.GetFieldValueType(false, index), PivotGridValueType.Value)) break;
* e.Value = e.GetCellValue(e.ColumnIndex, index);
* }
*/
}
}
// Handles the CustomCellValue event.
// Fires for each data cell. If the processed cell is a Custom Total,
// provides an appropriate Custom Total value.
private void pivotGridControl1_CustomCellValue(object sender, PivotCellValueEventArgs e)
{
// Exits if the processed cell does not belong to a Custom Total.
if (e.ColumnCustomTotal == null && e.RowCustomTotal == null)
{
return;
}
// Obtains a list of summary values against which
// the Custom Total will be calculated.
ArrayList summaryValues = GetSummaryValues(e);
// Obtains the name of the Custom Total that should be calculated.
string customTotalName = GetCustomTotalName(e);
// Calculates the Custom Total value and assigns it to the Value event parameter.
e.Value = GetCustomTotalValue(summaryValues, customTotalName);
}
object UpdateValue(PivotGridField field, int index, PivotCellValueEventArgs e)
{
object value = e.GetFieldValue(field, index);
if (field == fieldOrderDate)
{
int currentPosition = YearValues.IndexOf(value);
if (currentPosition > 0)
{
value = YearValues[currentPosition - 1];
}
else
{
value = "0000";
}
}
return(value);
}
// Returns the Custom Total name.
private string GetCustomTotalName(PivotCellValueEventArgs e)
{
return(e.ColumnCustomTotal != null?
e.ColumnCustomTotal.Tag.ToString() :
e.RowCustomTotal.Tag.ToString());
}
private void xrPivotGrid1_CustomCellValue(object sender, PivotCellValueEventArgs e)
{
}
private void gcDxTiempo_CustomCellValue(object sender, PivotCellValueEventArgs e)
{
}
private void pivotGridControlMain_CustomCellValue(object sender, PivotCellValueEventArgs e)
{
try
{
int CYear = 0;
if (bbiStartDate.EditValue != null)
CYear = ((DateTime)bbiStartDate.EditValue).Year;
if (e.DataField == calcCases)
{
if (e.GetFieldValue(fieldYearNo) == null)
return;
if ((int)e.GetFieldValue(fieldYearNo) == CYear - 1)
{
if (e.Value == null || e.GetCellValue(8, e.RowIndex) == null || e.Value == "0" || e.GetCellValue(8, e.RowIndex) == "0")
return;
e.Value = (decimal)e.GetCellValue(0, e.RowIndex) / (decimal)e.GetCellValue(8, e.RowIndex);
}
else if ((int)e.GetFieldValue(fieldYearNo) == CYear)
{
if (e.Value == null || e.GetCellValue(0, e.RowIndex) == null || e.Value == "0" || e.GetCellValue(0, e.RowIndex) == "0")
return;
e.Value = (decimal)e.GetCellValue(8, e.RowIndex) / (decimal)e.GetCellValue(0, e.RowIndex);
}
}
else if (e.DataField == calcNPS)
{
if (e.GetFieldValue(fieldYearNo) == null)
return;
if ((int)e.GetFieldValue(fieldYearNo) == CYear - 1)
{
if (e.Value == null || e.GetCellValue(10, e.RowIndex) == null || e.Value == "0" || e.GetCellValue(10, e.RowIndex) == "0")
return;
e.Value = (decimal)e.GetCellValue(2, e.RowIndex) / (decimal)e.GetCellValue(10, e.RowIndex);
}
else if ((int)e.GetFieldValue(fieldYearNo) == CYear)
{
if (e.Value == null || e.GetCellValue(2, e.RowIndex) == null || e.Value == "0" || e.GetCellValue(2, e.RowIndex) == "0")
return;
e.Value = (decimal)e.GetCellValue(10, e.RowIndex) / (decimal)e.GetCellValue(2, e.RowIndex);
}
}
else if (e.DataField == calcVolume)
{
if (e.GetFieldValue(fieldYearNo) == null)
return;
if ((int)e.GetFieldValue(fieldYearNo) == CYear - 1)
{
if (e.Value == null || e.GetCellValue(12, e.RowIndex) == null || e.Value == "0" || e.GetCellValue(12, e.RowIndex) == "0")
return;
e.Value = (decimal)e.GetCellValue(4, e.RowIndex) / (decimal)e.GetCellValue(12, e.RowIndex);
}
else if ((int)e.GetFieldValue(fieldYearNo) == CYear)
{
if (e.Value == null || e.GetCellValue(4, e.RowIndex) == null || e.Value == "0" || e.GetCellValue(4, e.RowIndex) == "0")
return;
e.Value = (decimal)e.GetCellValue(12, e.RowIndex) / (decimal)e.GetCellValue(4, e.RowIndex);
}
}
else if (e.DataField == calcPPL)
{
if (e.GetFieldValue(fieldYearNo) == null)
return;
if ((int)e.GetFieldValue(fieldYearNo) == CYear - 1)
{
if (e.Value == null || e.GetCellValue(14, e.RowIndex) == null || e.Value == "0" || e.GetCellValue(14, e.RowIndex) == "0")
return;
e.Value = (decimal)e.GetCellValue(6, e.RowIndex) / (decimal)e.GetCellValue(14, e.RowIndex);
}
else if ((int)e.GetFieldValue(fieldYearNo) == CYear)
{
if (e.Value == null || e.GetCellValue(6, e.RowIndex) == null || e.Value == "0" || e.GetCellValue(6, e.RowIndex) == "0")
return;
e.Value = (decimal)e.GetCellValue(14, e.RowIndex) / (decimal)e.GetCellValue(6, e.RowIndex);
}
}
}
catch (Exception ex)
{
Logger.Debug(ex.Message, ex);
}
}
private void pivotGridControl1_CustomCellValue(object sender, PivotCellValueEventArgs e)
{
try
{
// row wise GrandTotal only
if (e.DataField == pivotGridField4 && e.RowValueType == PivotGridValueType.GrandTotal && e.ColumnValueType == PivotGridValueType.Value)
{
decimal summaryValue1 = Convert.ToDecimal(e.GetFieldValue(pivotGridField2));
decimal summaryValue2 = Convert.ToDecimal(e.GetFieldValue(pivotGridField3));
//decimal value=summaryValue1 / summaryValue2;
if (summaryValue1 != 0)
{
if (summaryValue1 != 0 && summaryValue2 != 0)
{
decimal acc = summaryValue1 / summaryValue2;
e.Value = 100 * (1 - acc);
}
}
else
{
e.Value = 0;
}
}
// Column wise grand total
if (e.DataField == pivotGridField4 && e.RowValueType == PivotGridValueType.GrandTotal && e.ColumnValueType == PivotGridValueType.GrandTotal)
{
decimal summaryValue1 = Convert.ToDecimal(e.GetFieldValue(pivotGridField2));
decimal summaryValue2 = Convert.ToDecimal(e.GetFieldValue(pivotGridField3));
//decimal value=summaryValue1 / summaryValue2;
if (summaryValue1 != 0)
{
if (summaryValue1 != 0 && summaryValue2 != 0)
{
decimal acc = summaryValue1 / summaryValue2;
e.Value = 100 * (1 - acc);
}
}
else
{
e.Value = 0;
}
}
// row wise Total
if (e.DataField == pivotGridField4 && e.RowValueType == PivotGridValueType.Total && e.ColumnValueType == PivotGridValueType.GrandTotal)
{
decimal summaryValue1 = Convert.ToDecimal(e.GetFieldValue(pivotGridField2));
decimal summaryValue2 = Convert.ToDecimal(e.GetFieldValue(pivotGridField3));
if (summaryValue1 != 0)
{
if (summaryValue1 != 0 && summaryValue2 != 0)
{
decimal acc = summaryValue1 / summaryValue2;
e.Value = 100 * (1 - acc);
}
}
else
{
e.Value = 0;
}
}
// row wise Total and coulmn wise total
if (e.DataField == pivotGridField4 && e.RowValueType == PivotGridValueType.Total && e.ColumnValueType == PivotGridValueType.Value)
{
decimal summaryValue1 = Convert.ToDecimal(e.GetFieldValue(pivotGridField2));
decimal summaryValue2 = Convert.ToDecimal(e.GetFieldValue(pivotGridField3));
//decimal value=summaryValue1 / summaryValue2;
if (summaryValue1 != 0)
{
if (summaryValue1 != 0 && summaryValue2 != 0)
{
decimal acc = summaryValue1 / summaryValue2;
e.Value = 100 * (1 - acc);
}
}
else
{
e.Value = 0;
}
}
// row wise value and coulmn wise Grand Total
if (e.DataField == pivotGridField4 && e.RowValueType == PivotGridValueType.Value && e.ColumnValueType == PivotGridValueType.GrandTotal)
{
decimal summaryValue1 = Convert.ToDecimal(e.GetFieldValue(pivotGridField2));
decimal summaryValue2 = Convert.ToDecimal(e.GetFieldValue(pivotGridField3));
//decimal value=summaryValue1 / summaryValue2;
if (summaryValue1 != 0)
{
if (summaryValue1 != 0 && summaryValue2 != 0)
{
decimal acc = summaryValue1 / summaryValue2;
e.Value = 100 * (1 - acc);
}
}
else
{
e.Value = 0;
}
//
if (summaryValue1 == 0 && summaryValue1 != null)
{
if (summaryValue2 != 0)
{
e.Value = 100;
}
else if (summaryValue2 == 0)
{
e.Value = 0;
}
}
}
}
catch
{
MessageBox.Show("Problem With loading records Please check it");
}
finally
{
SplashScreenManager.CloseForm(false);
}
}