private void DrawGrid(XtraPivotGridHelper.DataViewTable dt)
{
pivotGridControl1.BeginUpdate();
XtraPivotGridHelper.ClearPivotGridFields(pivotGridControl1);
XtraPivotGridHelper.CreatePivotGridFields(pivotGridControl1, dt);
pivotGridControl1.DataSource = dt.DataTable;
formatCells(pivotGridControl1);
pivotGridControl1.EndUpdate();
pivotGridControl1.OptionsView.HideAllTotals();
foreach (PivotGridField field in pivotGridControl1.Fields)
{
if (field.FieldName == ColName.TOTAL)
{
field.Appearance.Value.Options.UseTextOptions = true;
field.Appearance.Value.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
}
}
pivotGridControl1.BestFit();
}
