private static SummaryFunc ConvertToSummaryFunc(DevExpress.Data.SummaryItemType t)
{
SummaryFunc s = SummaryFunc.Sum;
switch (t)
{
case DevExpress.Data.SummaryItemType.Average:
s = SummaryFunc.Avg;
break;
case DevExpress.Data.SummaryItemType.Count:
s = SummaryFunc.Count;
break;
case DevExpress.Data.SummaryItemType.Max:
s = SummaryFunc.Max;
break;
case DevExpress.Data.SummaryItemType.Min:
s = SummaryFunc.Min;
break;
case DevExpress.Data.SummaryItemType.Sum:
s = SummaryFunc.Sum;
break;
}
return(s);
}
private XRSummary CreateSummary(SummaryFunc summaryFunc,
string formatString = null)
{
var result = new XRSummary
{
Running = this.RunningBand,
Func = summaryFunc,
IgnoreNullValues = true,
};
if (!string.IsNullOrWhiteSpace(formatString))
{
result.FormatString = formatString;
}
return(result);
}
private void xrTranAccount_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
// Create a data binding object.
XRBinding binding = new XRBinding("Text", null, "ViewTransactionPostCollectionBank.Dr");
XRBinding bindings = new XRBinding("Text", null, "ViewTransactionPostCollectionBank.Cr");
XRBinding bindincol = new XRBinding("Text", null, "ViewTransactionPostCollectionBank.CloseBal");
XRBinding bindingAmt = new XRBinding("Text", null, "ViewTransactionPostCollectionBank.Amount");
XRBinding bindingopen = new XRBinding("Text", null, "ViewTransactionPostCollectionBank.OpenBal");
// Add the data binding to the label's collection of bindings.
xrSummaryDr.DataBindings.Add(binding);
xrSummaryCr.DataBindings.Add(bindings);
xrCloseBal.DataBindings.Add(bindincol);
xrAmt.DataBindings.Add(bindingAmt);
xrOpenBal.DataBindings.Add(bindingopen);
// Create an XRSummary object.
XRSummary summdb = new XRSummary();
XRSummary summcr = new XRSummary();
XRSummary sumclose = new XRSummary();
XRSummary sumAt = new XRSummary();
XRSummary sumOpen = new XRSummary();
summdb.Func = SummaryFunc.Sum;
summdb.Running = SummaryRunning.Group;
summdb.IgnoreNullValues = true;
summdb.FormatString = "# {0:n2}";
summcr.Func = SummaryFunc.Sum;
summcr.Running = SummaryRunning.Group;
summcr.IgnoreNullValues = true;
summcr.FormatString = "# {0:n2}";
sumclose.Func = SummaryFunc.DSum;
sumclose.Running = SummaryRunning.Report;
sumclose.FormatString = "# {0:n2}";
sumOpen.Func = SummaryFunc.DSum;
sumOpen.Running = SummaryRunning.Report;
sumOpen.FormatString = "# {0:n2}";
sumAt.Func = SummaryFunc.DSum;
sumAt.Running = SummaryRunning.Report;
sumAt.FormatString = "# {0:n2}";
xrSummaryDr.Summary = summdb;
xrSummaryDr.ForeColor = Color.Green;
xrAmt.Summary = sumAt;
xrAmt.ForeColor = Color.Red;
xrSummaryCr.Summary = summcr;
xrSummaryCr.ForeColor = Color.Green;
xrCloseBal.Summary = sumclose;
xrCloseBal.ForeColor = Color.DarkOliveGreen;
//xrLabel12.ForeColor = Color.DarkOliveGreen;
xrOpenBal.Summary = sumOpen;
xrOpenBal.ForeColor = Color.DarkOliveGreen;
SummaryFunc res = default(SummaryFunc);
res = SummaryFunc.Sum;
XRSummary totdb = default(XRSummary);
totdb = xrSummaryDr.Summary;
XRSummary totcd = default(XRSummary);
totcd = xrSummaryCr.Summary;
}
