void InitializePivot(int pivotIndex, string expression, string name) { PivotGridControl pivot = pivotGridControls[pivotIndex]; pivot.BeginUpdate(); pivot.Fields.Clear(); pivot.Fields.Add(GetField("Name", "fieldName", PivotArea.RowArea)); pivot.Fields.Add(GetField("Field1", Field1Name, PivotArea.DataArea)); pivot.Fields.Add(GetField("Field2", Field2Name, PivotArea.DataArea)); pivot.Fields.Add(GetField("Date", "fieldDate", PivotArea.ColumnArea)); pivot.DataSource = GetDataView(); pivot.OptionsData.DataFieldUnboundExpressionMode = DataFieldUnboundExpressionMode.UseSummaryValues; pivot.EndUpdate(); if (string.IsNullOrEmpty(name)) { SetCondition(pivot, expression, null); name = "all fields"; } else { SetCondition(pivot, expression, pivot.Fields[name]); } this.labels[pivotIndex].Text = expression + " => '" + name + "' cells"; }
public void TearDown(object uiControl) { pivot.BeginUpdate(); pivot.Fields["ID"].Area = PivotArea.FilterArea; pivot.ActiveFilterCriteria = null; pivot.EndUpdate(); pivot = null; }
public void TearDown(object uiControl) { pivot.BeginUpdate(); pivot.Fields["Amount"].Area = PivotArea.FilterArea; pivot.Fields["ID"].Area = PivotArea.FilterArea; pivot.Fields["Name"].Area = PivotArea.FilterArea; pivot.EndUpdate(); pivot = null; }
public void SetUp(object uiControl) { Row.EnsureListSource(ref dataSource, Configuration.Current.Rows); pivot = ((PivotGridControl)uiControl); pivot.BeginUpdate(); pivot.DataSource = dataSource; pivot.RetrieveFields(PivotArea.FilterArea, true); pivot.Fields["ID"].Area = PivotArea.RowArea; pivot.ActiveFilterCriteria = null; pivot.EndUpdate(); }
private static void ResetTopFiveValues(PivotGridControl pivotGrid) { pivotGrid.BeginUpdate(); var fields = pivotGrid.GetFieldsByArea(FieldArea.ColumnArea).Union(pivotGrid.GetFieldsByArea(FieldArea.RowArea)); foreach (var f in fields) { f.SortByField = null; f.SortByConditions.Clear(); f.TopValueCount = 0; f.TopValueShowOthers = false; } pivotGrid.EndUpdate(); }
private void pivotGridControl1_FieldFilterChanged(object sender, PivotFieldEventArgs e) { PivotGridControl pivot = sender as PivotGridControl; pivot.BeginUpdate(); foreach (PivotGridField field in pivot.Fields) { if (field.Visible == false || field.Area == FieldArea.DataArea || field.Area == FieldArea.FilterArea) { continue; } CollapseAllNewValues(visibleValues[field], field.GetVisibleValues(), field); } pivot.EndUpdate(); }
private void SetPivotGridData(DataTable dt, PivotGridControl pivotGrid) { XtraPivotGridHelper.DataViewTable dataTable = new XtraPivotGridHelper.DataViewTable(); foreach (DataColumn info in dt.Columns) { dataTable.AddColumn(info.ColumnName, info.ColumnName, info.DataType, PivotArea.RowArea, null, null); } pivotGrid.BeginUpdate(); pivotGrid.ClearPivotGridFields(); pivotGrid.CreatePivotGridFields(dataTable); pivotGrid.DataSource = dt; pivotGrid.EndUpdate(); if (dt.Rows.Count < 10000) { pivotGrid.BestFit(); } }
private void BindBegin(PivotGridControl pivotGrid) { pivotGrid.BeginUpdate(); pivotGrid.OptionsSelection.MultiSelect = true; }