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);
}
