static void OnPivotFieldAreaChanging(object sender, PivotFieldAreaChangingEventArgs e) { PivotGridField field = e.Field; if (field == null || field.Parent as PivotGridControl == null || ((PivotGridControl)field.Parent).OlapConnectionString != null || field.UnboundType != FieldUnboundColumnType.Bound) { return; } if (field.Area == FieldArea.DataArea) { if (e.NewArea != FieldArea.DataArea) { e.Allow = false; } } else { if (e.NewArea == FieldArea.DataArea) { e.Allow = false; } } }
private static void PivotGridControlModifiedFieldAreaChanging(object sender, PivotFieldAreaChangingEventArgs e) { //if (e.Field.FieldName.Contains("SUPPLIER") || e.Field.FieldName.Contains("SOURCEMETHOD") || e.Field.FieldName.Contains("ORDERPLACE") || e.Field.FieldName.Contains("SOURCEWH")) if (e.Field.FieldName.Contains("NEW")) { if (e.NewArea == FieldArea.RowArea || e.NewArea == FieldArea.ColumnArea || e.NewArea == FieldArea.FilterArea) { e.Allow = false; } } else if (e.Field.FieldName.Contains("ITEMLOC")) { //if (e.NewArea == FieldArea.DataArea || e.NewArea == FieldArea.ColumnArea) //{ // e.Allow = false; //} } else if (e.Field.FieldName.Contains("ITEM")) { if (e.NewArea == FieldArea.DataArea || e.NewArea == FieldArea.ColumnArea) { e.Allow = false; } } else if (e.Field.FieldName.Contains("LOC")) { if (e.NewArea == FieldArea.DataArea || e.NewArea == FieldArea.ColumnArea) { e.Allow = false; } } else if (e.Field.FieldName.Contains("MEASURE")) { e.Allow = false; } }
private static void PivotGridControlModifiedFieldAreaChanging(object sender, PivotFieldAreaChangingEventArgs e) { //if (e.Field.FilterValues.ValuesExcluded.Count() != 0) //{ // e.Allow = e.NewArea == FieldArea.FilterArea; // //e.Field.AllowDrop = true; //} if (e.Field.FieldName.Contains("ITEMLOC")) { e.Allow = true; } else if (e.Field.FieldName.Contains("ITEM")) { if (e.NewArea == FieldArea.DataArea || e.NewArea == FieldArea.ColumnArea) { e.Allow = false; } } else if (e.Field.FieldName.Contains("LOC")) { if (e.NewArea == FieldArea.DataArea || e.NewArea == FieldArea.RowArea) { e.Allow = false; } } else if (e.Field.FieldName.Contains("MEASURE")) { if (e.NewArea == FieldArea.ColumnArea || e.NewArea == FieldArea.RowArea) { e.Allow = false; } } }