GetValueEventArgs.Row Property

Provides access to a data row whose data can be used to calculate a calculated field‘s custom value in the CalculatedField.GetValue event handler.

Namespace: DevExpress.XtraReports.UI

Assembly: DevExpress.XtraReports.v20.2.dll

NuGet Packages: DevExpress.Reporting.Core, DevExpress.WindowsDesktop.Reporting.Core

Declaration

C#

public object Row { get; }

VB.NET

Public ReadOnly Property Row As Object

Property Value

Type	Description
Object	A Object representing a data row.

Remarks

Use the Row property to get access to a data row whose data may be necessary when calculating a custom value for a calculated field.

Example

The code sample below performs the following tasks:

1. Handle a calculated field‘s GetValue event to set the calculated field’s value.
2. Bind a XRLabel control instance named HeaderLabel to the calculated field described above.

C#

using System;
using DevExpress.XtraReports.UI;
using DevExpress.DataAccess.Sql.DataApi;
// ...
calculatedField.GetValue += calculatedField_GetValue;
mainReport.Bands["GroupHeaderBand"].Controls["HeaderLabel"].ExpressionBindings.Add(
    new ExpressionBinding() { PropertyName = "Text", Expression = "[calculatedField]" }
    );
// ...
private void calculatedField_GetValue(object sender, GetValueEventArgs e) {
    IRow row = e.Row as IRow;
    object columnValue = row["OrderDate"];
    e.Value = (int)((DateTime)columnValue).DayOfWeek;
}

VB.NET

Imports System
Imports DevExpress.XtraReports.UI
Imports DevExpress.DataAccess.Sql.DataApi
' ...
Private calculatedField.GetValue += AddressOf calculatedField_GetValue
mainReport.Bands("GroupHeaderBand").Controls("HeaderLabel").ExpressionBindings.Add(New ExpressionBinding() With {.PropertyName = "Text", .Expression = "[calculatedField]"})
' ...
private void calculatedField_GetValue(Object sender, GetValueEventArgs e)
    Dim row As IRow = TryCast(e.Row, IRow)
    Dim columnValue As Object = row("OrderDate")
    e.Value = CInt(DirectCast(columnValue, Date).DayOfWeek)

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Row property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

Reporting_how-to-get-access-to-the-fields-in-the-parent-table-e1632/CS/GetValue/XtraReport1.cs#L19

{
    DataRowView view = e.Row as DataRowView;
    e.Value = GetCurrentColumnValue("CategoryName") + " " + view.Row["UnitPrice"];

Reporting_how-to-print-a-balanced-number-of-records-in-each-column-in-the-case-of-a-e2029/CS/WindowsApplication1/XtraReport1.cs#L17

private void calculatedField1_GetValue(object sender,GetValueEventArgs e) {
    DetailItemClass currentRow = e.Row as DetailItemClass;
    List<ParentItemClass> ds = (List<ParentItemClass>)e.Report.DataSource;

VB.NET

Reporting_how-to-get-access-to-the-fields-in-the-parent-table-e1632/VB/GetValue/XtraReport1.vb#L17

Private Sub calculatedField1_GetValue(ByVal sender As Object, ByVal e As GetValueEventArgs) Handles calculatedField1.GetValue
    Dim view As DataRowView = TryCast(e.Row, DataRowView)
    e.Value = GetCurrentColumnValue("CategoryName") & " " & view.Row("UnitPrice")

Reporting_how-to-print-a-balanced-number-of-records-in-each-column-in-the-case-of-a-e2029/VB/WindowsApplication1/XtraReport1.vb#L19

Private Sub calculatedField1_GetValue(ByVal sender As Object, ByVal e As GetValueEventArgs)
    Dim currentRow As DetailItemClass = TryCast(e.Row, DetailItemClass)
    Dim ds As List(Of ParentItemClass) = CType(e.Report.DataSource, List(Of ParentItemClass))