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);
}
void InitPivotLayoutGeneratedDB(AsyncOperationResult result)
{
PivotGrid.BeginUpdate();
PivotGridField fieldSalesPerson = CreatePivotGridField("SalesPersonName", "Sales Person", FieldArea.RowArea);
PivotGridField fieldCustomer = CreatePivotGridField("CustomerName", "Customer", FieldArea.FilterArea);
PivotGridField fieldQuantity = CreatePivotGridField("Quantity", "Quantity", FieldArea.DataArea);
PivotGridField fieldUnitPrice = CreatePivotGridField("UnitPrice", "Unit Price", FieldArea.DataArea);
fieldUnitPrice.SummaryType = FieldSummaryType.Average;
fieldUnitPrice.ShowSummaryTypeName = true;
PivotGridField fieldOrderID = CreatePivotGridField("OrderID", "Order ID", FieldArea.FilterArea);
PivotGridField fieldCategory = CreatePivotGridField("CategoryName", "Category", FieldArea.RowArea);
PivotGridField fieldProduct = CreatePivotGridField("ProductName", "Product", FieldArea.RowArea);
PivotGridField fieldOrderDateYear = CreatePivotGridField("OrderDate", "Year", FieldArea.ColumnArea);
fieldOrderDateYear.GroupInterval = FieldGroupInterval.DateYear;
PivotGridField fieldOrderDateMonth = CreatePivotGridField("OrderDate", "Month", FieldArea.ColumnArea);
fieldOrderDateMonth.GroupInterval = FieldGroupInterval.DateMonth;
PivotGridField fieldPrice = new PivotGridField();
fieldPrice.Area = FieldArea.DataArea;
fieldPrice.Caption = "Price";
fieldPrice.UnboundType = FieldUnboundColumnType.Decimal;
fieldQuantity.Width = DefaultFieldWidth;
fieldUnitPrice.Width = DefaultFieldWidth;
fieldPrice.Width = DefaultFieldWidth;
PivotGrid.Fields.AddRange(new PivotGridField[] { fieldSalesPerson, fieldCustomer, fieldQuantity, fieldUnitPrice,
fieldOrderID, fieldCategory, fieldProduct, fieldOrderDateYear, fieldOrderDateMonth, fieldPrice });
PivotGrid.Groups.Add(fieldOrderDateYear, fieldOrderDateMonth);
fieldPrice.UnboundExpression = "[" + fieldQuantity.ExpressionFieldName + "] * [" + fieldUnitPrice.ExpressionFieldName + "]";
PivotGrid.EndUpdateAsync(InitializationCompletedCallback);
}
