void InitPivotLayoutSampleOlapDB(AsyncOperationResult result) { PivotGrid.RetrieveFields(FieldArea.FilterArea, false); if (PivotGrid.Fields.Count == 0) { InitializationCompletedCallback.Invoke(null); return; } PivotGrid.BeginUpdate(); PivotGridField fieldProduct = PivotGrid.Fields[CategoryFieldName], fieldYear = PivotGrid.Fields[YearFieldName], fieldTotalCost = PivotGrid.Fields[TotalCostFieldName], fieldFreightCost = PivotGrid.Fields[FreightFieldName], fieldOrderQuantity = PivotGrid.Fields[QuantityOrderFieldName]; PivotGrid.Groups[1].Caption = "Calendar"; PivotGrid.Groups[2].Caption = "Products"; fieldProduct.Area = FieldArea.RowArea; fieldYear.Area = FieldArea.ColumnArea; fieldYear.SortOrder = FieldSortOrder.Descending; fieldTotalCost.Width = DefaultFieldWidth; fieldTotalCost.CellFormat = "c2"; fieldFreightCost.Width = DefaultFieldWidth; fieldFreightCost.CellFormat = "c2"; fieldOrderQuantity.Width = DefaultFieldWidth; fieldProduct.Visible = true; fieldYear.Visible = true; fieldTotalCost.Visible = true; fieldFreightCost.Visible = true; fieldOrderQuantity.Visible = true; PivotGrid.EndUpdateAsync(ExpandAll); }
protected override void Initialize() { try { PivotGrid.SetOlapConnectionStringAsync(OLAPSampleConnectionString, InitPivotLayoutSampleOlapDB); } catch (OLAPConnectionException) { PivotGrid.OlapConnectionString = null; PivotGrid.IsEnabled = false; InitializationCompletedCallback.Invoke(null); } }
void SetDataSourceGeneratedDatabase(DataSet dataSet) { if (dataSet == null) { PivotGrid.IsEnabled = false; InitializationCompletedCallback.Invoke(null); return; } PivotGrid.SetDataSourceAsync(dataSet.Tables[0], InitPivotLayoutGeneratedDB); }