private void HandleHeaderShowMenu(DevExpress.XtraPivotGrid.PopupMenuShowingEventArgs e)
{
if (!IsLastAreaField(pivotGridControl1, e.Field))
{
CreateToggleTotalsItem(e);
}
}
void pivotGridControl1_PopupMenuShowing(object sender, DevExpress.XtraPivotGrid.PopupMenuShowingEventArgs e)
{
if (e.MenuType == PivotGridMenuType.FieldValue)
{
e.Allow = false;
}
}
void PivotGridControl_PopupMenuShowing(object sender, DevExpress.XtraPivotGrid.PopupMenuShowingEventArgs e)
{
if (e.MenuType == PivotGridMenuType.FieldValue && e.HitInfo.ValueInfo != null)
{
e.Menu.Items.Add(CreateMenuItem(CreateCaptionForCondition(e.HitInfo.ValueInfo.DataField, true), "Simple"));
e.Menu.Items.Add(CreateMenuItem(CreateCaptionForCondition(e.HitInfo.ValueInfo.DataField, false), "Expression"));
field = e.HitInfo.ValueInfo.DataField;
}
}
private void onPopUpMenuShowing(PopupMenuShowingEventArgs e)
{
if (e.MenuType != PivotGridMenuType.FieldValue)
{
return;
}
var hi = e.HitInfo;
if (hi.HitTest != PivotGridHitTest.Value || hi.ValueInfo.Field != _pivotField)
{
e.Allow = false;
return;
}
var ds = hi.ValueInfo.CreateDrillDownDataSource();
CreateMenuUnits(ds.StringValue(_pivotField), e.Menu);
}
private void pivotGridControl1_PopupMenuShowing(object sender, DevExpress.XtraPivotGrid.PopupMenuShowingEventArgs e)
{
if (!Equals(e.MenuType, PivotGridMenuType.FieldValue))
{
return;
}
foreach (DXMenuItem item in e.Menu.Items)
{
PivotGridFieldPair pair = item.Tag as PivotGridFieldPair;
if (pair != null)
{
//this.Text = pair.FieldItem.FieldName + ": " + pair.DataFieldItem.FieldName;
item.Click += new EventHandler(item_Click);
item.Caption = "Custom " + item.Caption;
CustomSortBySummaryTag tag = new CustomSortBySummaryTag();
tag.Pair = pair;
tag.Condition = e.HitInfo.ValueInfo.Item.GetFieldSortConditions();
item.Tag = tag;
}
}
}
private void PivotGridControl_PopupMenuShowing(object sender, DevExpress.XtraPivotGrid.PopupMenuShowingEventArgs e)
{
try
{
e.Menu.Items.Add(new DXMenuItem("Select Range", (o1, e1) =>
{
Controls.Add(_RangeSelector);
_RangeSelector.BtnLoad.Click += new EventHandler(BtnLoad_Click);
_RangeSelector.BringToFront();
_RangeSelector.Location = new Point(e.Point.X + 20, e.Point.Y + 20);
_RangeSelector.Show();
_RangeSelector.DtFrom.Focus();
}));
e.Menu.Items.Add(new DXMenuItem("Print Report", (o1, e1) =>
{
var bp = new FormReports.BasePrint()
{
ReportName = GlobalVariables.ProgDesc
};
bp.PrintPivotToReport(PivotGridControl, ProjectFunctions.GetDataSet("select ProCaption from ProgramMaster Where ProgCode='" + GlobalVariables.ProgCode + "'").Tables[0].Rows[0]["ProCaption"].ToString() + " From " + _RangeSelector.StartDate.Date.ToString("dd-MM-yyyy") + " To " + _RangeSelector.EndDate.Date.ToString("dd-MM-yyyy"));
}));
e.Menu.Items.Add(new DXMenuItem("Disable Merging While Printing", (o1, e1) =>
{
PivotGridControl.OptionsPrint.MergeRowFieldValues = false;
PivotGridControl.OptionsPrint.MergeColumnFieldValues = false;
}));
e.Menu.Items.Add(new DXMenuItem("Enable Merging While Printing", (o1, e1) =>
{
PivotGridControl.OptionsPrint.MergeRowFieldValues = true;
PivotGridControl.OptionsPrint.MergeColumnFieldValues = true;
}));
e.Menu.Items.Add(new DXMenuItem("Save Report Layout", (o1, e1) =>
{
ProjectFunctions.ButtonVisualize(_RepLayout);
_RepLayout.PGC = PivotGridControl;
_RepLayout.BringToFront();
_RepLayout.Location = new Point(e.Point.X + 20, e.Point.Y + 20);
_RepLayout.Show();
}));
e.Menu.Items.Add(new DXMenuItem("Load Report Layout", (o1, e1) =>
{
ProjectFunctions.ButtonVisualize(_LoadLayout);
_LoadLayout.BringToFront();
_LoadLayout.PGC = PivotGridControl;
_LoadLayout.Location = new Point(e.Point.X + 20, e.Point.Y + 20);
_LoadLayout.Show();
}));
e.Menu.Items.Add(new DXMenuItem(PivotGridControl.OptionsView.ShowColumnGrandTotals ? "Hide Grand Totals" : "Show Grand Totals", (o1, e1) =>
{
PivotGridControl.OptionsView.ShowColumnGrandTotals = PivotGridControl.OptionsView.ShowColumnGrandTotals ? false : true;
PivotGridControl.OptionsView.ShowColumnGrandTotalHeader = PivotGridControl.OptionsView.ShowColumnGrandTotalHeader ? false : true;
}));
e.Menu.Items.Add(new DXMenuItem("Close", (o1, e1) =>
{
Close();
}));
}
catch (Exception ex)
{
ProjectFunctions.SpeakError(ex.Message);
}
}
