void pivot_FieldFilterChanging(object sender, PivotFieldFilterChangingEventArgs e)
{
if (Equals(e.Field, targetField))
{
this.ReplaceRangesByItems(e);
}
}
private void pivotGridControl1_FieldFilterChanging(object sender, PivotFieldFilterChangingEventArgs e)
{
PivotGridControl pivot = (PivotGridControl)sender;
foreach (PivotGridField field in pivot.Fields)
{
if (field.Visible == false || field.Area == FieldArea.DataArea || field.Area == FieldArea.FilterArea)
{
continue;
}
visibleValues[field] = new List <object>(field.GetVisibleValues());
}
}
void ReplaceRangesByItems(PivotFieldFilterChangingEventArgs e)
{
List <object> currentRanges = new List <object>(e.Values);
e.Values.Clear();
foreach (object value in e.Field.GetUniqueValues())
{
if (currentRanges.Contains(GetGroupByValue(value)))
{
e.Values.Add(value);
}
}
}
protected void ASPxPivotGrid1_FieldFilterChanging(object sender,
PivotFieldFilterChangingEventArgs e)
{
if (Equals(e.Field, fieldCategoryName))
{
if ((e.Field.FilterValues.FilterType == PivotFilterType.Excluded &&
e.Values.Contains("Beverages")) ||
(e.Field.FilterValues.FilterType == PivotFilterType.Included &&
!e.Values.Contains("Beverages")))
{
e.Cancel = true;
}
}
}
private void pivotGridControl1_FieldFilterChanging(object sender,
PivotFieldFilterChangingEventArgs e)
{
if (Equals(e.Field, fieldCategoryName))
{
if ((e.Field.FilterValues.FilterType == FieldFilterType.Excluded &&
e.Values.Contains("Beverages")) ||
(e.Field.FilterValues.FilterType == FieldFilterType.Included &&
!e.Values.Contains("Beverages")))
{
MessageBox.Show("You are not allowed to hide the 'Beverages' value.");
e.Cancel = true;
}
}
}