XRSummary.GetResult() Method

Returns the calculated function’s result.

Namespace: DevExpress.XtraReports.UI

Assembly: DevExpress.XtraReports.v23.2.dll

NuGet Package: DevExpress.Reporting.Core

Declaration

C#

public object GetResult()

VB.NET

Public Function GetResult As Object

Returns

Type	Description
Object	An object representing the result for the calculated function.

Remarks

The calculated function is set by the XRSummary.Func property.

Example

This example demonstrates how to use the XRSummary.GetResult method. It introduces a handler method for the XRControl.BeforePrint event which calculates the grand total for the labels, which display values for the first five months of the year.

Note

For this example to work correctly, its application should contain an XtraReport1 object, which contains five labels (totalJanuary, totalFebruary, totalMarch, totalApril, and totalMay) that calculate a summary for the corresponding months’ values, and are situated on the ReportFooter or the GroupFooter band. Also the report should contain a grandTotal label situated on the same band as other labels.

C#

using System;
using System.Drawing.Printing;
using DevExpress.XtraReports.UI;
// ...

private void grandTotal_BeforePrint(object sender, CancelEventArgs e) {
   // Create an array of labels which the total summary will be calculated for.
   XRLabel[] monthLabels = new XRLabel[] {totalJanuary, 
       totalFebruary, totalMarch, totalApril, totalMay};

   // Create a total variable.
   double total = 0;

   // Use the Summary.GetResult method of each summary label to calculate
   // the total of all the subtotals for the first 5 months in the year.
   foreach(XRLabel monthLabel in monthLabels){
      total += Convert.ToDouble(monthLabel.Summary.GetResult());
   }

   // Set the result to the grandTotal label's text.
   ((XRLabel)sender).Text = total.ToString("n2");
}

VB.NET

Imports System
Imports System.Drawing.Printing
Imports DevExpress.XtraReports.UI
' ...

Private Sub GrandTotal_BeforePrint(ByVal sender As Object, _ 
ByVal e As CancelEventArgs) Handles GrandTotal.BeforePrint
   ' Create an array of labels which the total summary will be calculated for.
   Dim MonthLabels() As XRLabel = {TotalJanuary, TotalFebruary, _ 
       TotalMarch, TotalApril, TotalMay}

   ' Create a total variable.
   Dim Total As Double = 0

   ' Use the Summary.GetResult method of each summary label to calculate
   ' the total of all the subtotals for the first 5 months in the year.
   Dim MonthLabel As XRLabel
   For Each MonthLabel In MonthLabels
      Total += Convert.ToDouble(MonthLabel.Summary.GetResult())
   Next MonthLabel

   ' Set the result to the grandTotal label's text.
   sender.Text = Total.ToString("n2")
End Sub