void pivotGrid_CustomGroupInterval(object sender, PivotCustomGroupIntervalEventArgs e)
{
switch (SelectedDemo)
{
case 0:
if (!object.ReferenceEquals(e.Field, pivotGrid.Fields[0]))
{
return;
}
if (Convert.ToChar(e.Value.ToString()[0]) < 'F')
{
e.GroupValue = "A-E";
return;
}
if (Convert.ToChar(e.Value.ToString()[0]) > 'E' && Convert.ToChar(e.Value.ToString()[0]) < 'T')
{
e.GroupValue = "F-S";
return;
}
if (Convert.ToChar(e.Value.ToString()[0]) > 'S')
{
e.GroupValue = "T-Z";
}
break;
case 1:
if (!object.ReferenceEquals(e.Field, pivotGrid.Fields[3]))
{
return;
}
e.GroupValue = ((DateTime)e.Value).Year + " - " + ((((DateTime)e.Value).Month - 1) / 3 + 1).ToString();
break;
}
}
protected void ASPxPivotGrid2_CustomGroupInterval(object sender, PivotCustomGroupIntervalEventArgs e)
{
if (e.Field.UnboundFieldName != "fieldCompanyGroup")
{
return;
}
if (Convert.ToChar(e.Value.ToString()[0]) < 'F')
{
e.GroupValue = "A-E";
return;
}
if (Convert.ToChar(e.Value.ToString()[0]) > 'E' && Convert.ToChar(e.Value.ToString()[0]) < 'P')
{
e.GroupValue = "F-O";
return;
}
if (Convert.ToChar(e.Value.ToString()[0]) > 'O' && Convert.ToChar(e.Value.ToString()[0]) < 'T')
{
e.GroupValue = "P-S";
return;
}
if (Convert.ToChar(e.Value.ToString()[0]) > 'S')
{
e.GroupValue = "T-Z";
}
}
/// <summary>
/// Calculate group value from incoming data value
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Grid_CustomGroupInterval(object sender, PivotCustomGroupIntervalEventArgs e)
{
PivotGridFieldContext fc = GetPivotGridFieldContext(e.Field);
PivotGridFieldMx f = fc.F;
AggregationDef ad = f.Aggregation;
if (e.Field.Area != PivotArea.ColumnArea && e.Field.Area != PivotArea.RowArea)
{
return; // not sure why this is happening but ignore if so
}
if (!ad.IsGroupingType) // must check this since when moving a field to a grouping area in the PivotGridDialog, this event fires before the FieldAreaChanged event (true?)
{
return; // throw new Exception("Expected Group Role");
}
AggregationTypeDetail td = ad.TypeDetail;
if (td.GroupingMethod == null)
{
return;
}
QueryColumn qc = fc.Qc;
object vo = e.Value; // value to apply group function to
object groupValue = td.GroupingMethod(qc, ad, vo);
e.GroupValue = groupValue;
}
void PivotGridControlOnCustomGroupInterval(object sender, PivotCustomGroupIntervalEventArgs e)
{
var groupIntervalRules = _ruleCollector.GroupIntervalRules(e.Field, Frame);
foreach (var intervalRule in groupIntervalRules)
{
intervalRule.Calculate(e);
}
}
private void pivotGridControl1_CustomGroupInterval(object sender,
PivotCustomGroupIntervalEventArgs e)
{
if (!object.ReferenceEquals(e.Field, fieldCustomerGroup))
{
return;
}
string customerName = Convert.ToString(e.Value);
if (customerName[0] < 'F')
{
e.GroupValue = "A-E";
}
else if (customerName[0] > 'E' && customerName[0] < 'T')
{
e.GroupValue = "F-S";
}
else if (customerName[0] > 'S')
{
e.GroupValue = "T-Z";
}
}
public void Calculate(PivotCustomGroupIntervalEventArgs e)
{
var dateTime = ((DateTime)e.Value);
e.GroupValue = new DateTime(dateTime.Year, dateTime.Month, 1);
}
void IPivotGroupIntervalEvent.Calculate(PivotCustomGroupIntervalEventArgs e)
{
var valueAsDate = (DateTime)e.Value;
e.GroupValue = valueAsDate >= _currentPeriodDate ? CurrentPeriod : ComparePeriod;
}
void pivotGrid_CustomGroupInterval(object sender, PivotCustomGroupIntervalEventArgs e)
{
DateTime date = (DateTime)e.Value;
e.GroupValue = CalculateMoonPhase(date.Year, date.Month, date.Day);
}
