XtraReportBase.GetCurrentRow() Method

Returns the current data row in the report’s data source.

Namespace: DevExpress.XtraReports.UI

Assembly: DevExpress.XtraReports.v18.2.dll

Declaration

C#

public object GetCurrentRow()

VB.NET

Public Function GetCurrentRow As Object

Returns

Type	Description
Object	A DataRowView value (if the report’s data source is a DataTable), or a collection item (if the report’s data source is an object implementing the IList interface).

Remarks

The report’s data source is assigned to the XtraReportBase.DataSource property.

Example

This example demonstrates how to use the XtraReportBase.GetCurrentRow and XtraReportBase.GetCurrentColumnValue methods in master-detail reports.

To be able to run this example, the sample application should contain a report that is bound to the Categories and Products tables in the demo Northwind database (the nwind.mdb file located in the directory, where you installed DevExpress demos), and the dataset for these tables should contain a master-detail relationship (CategoriesProducts).

In the following code, “DetailReport” is the name of the DetailReportBand that should be added when creating a master-detail report.

C#

using System.Data;
using System.Drawing.Printing;
// ...

private void Detail_BeforePrint(object sender, PrintEventArgs e) {
   // Get the value of the current row in the master report.
   xrLabel1.Text = ((DataRowView)GetCurrentRow()).Row["CategoryName"].ToString();

   // Get the value of the current cell in the CategoryName column in the master report.
   xrLabel2.Text = GetCurrentColumnValue("CategoryName").ToString();
}

private void Detail1_BeforePrint(object sender, PrintEventArgs e) {
   // You shouldn't use the GetCurrentRow method in this way in a detail report.
   // ((DataRowView)GetCurrentRow()).Row["Categories.CategoriesProducts.ProductName"].ToString();

   // Get the value of the current row in the detail report.
   xrLabel3.Text = ((DataRowView)DetailReport.GetCurrentRow()).Row["ProductName"].ToString();

   // You shouldn't use the GetCurrentColumnValue method in this way in a detail report.
   // GetCurrentColumnValue("Categories.CategoriesProducts.ProductName").ToString();

   // Get the current value of the CategoryName data column in a detail report.
   xrLabel4.Text = DetailReport.GetCurrentColumnValue("ProductName").ToString();
}

VB.NET

Imports System.Data
Imports System.Drawing.Printing
' ...

Private Sub Detail_BeforePrint(ByVal sender As Object, _ 
ByVal e As PrintEventArgs) Handles Detail.BeforePrint
   ' Get the value of the current row in the master report.
   XrTableCell1.Text = GetCurrentRow().Row("CategoryName").ToString()

  ' Get the value of the current cell in the CategoryName column in the master report.
   XrTableCell2.Text = GetCurrentColumnValue("CategoryName").ToString()
End Sub

Private Sub Detail1_BeforePrint(ByVal sender As Object, _ 
ByVal e As PrintEventArgs) Handles Detail1.BeforePrint
   ' You shouldn't use the GetCurrentRow method in this way in a detail report.
   ' GetCurrentRow().Row("Categories.CategoriesProducts.ProductName").ToString()

   ' Get the value of the current row in the detail report.
   XrTableCell3.Text = DetailReport.GetCurrentRow().Row("ProductName").ToString()

   ' You shouldn't use the GetCurrentColumnValue method in this way in a detail report.
   ' GetCurrentColumnValue("Categories.CategoriesProducts.ProductName").ToString()

   ' Get the value of the current cell in the CategoryName column in the detail report.
   XrTableCell4.Text = DetailReport.GetCurrentColumnValue("ProductName").ToString()
End Sub

Related GitHub Examples

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

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-implement-editing-in-the-preview-form-e26/CS/XtraReport1.cs#L25

private void xrLabel4_BeforePrint(object sender, PrintEventArgs e) {
    ((XRLabel)sender).Tag = this.DetailReport.GetCurrentRow();
}

Reporting_sqldatasource-how-to-use-expressionevaluator-to-programmatically-filter-report-t328522/CS/XtraReport2.cs#L25

private bool IsFit() {
    ResultRow rr = this.GetCurrentRow() as ResultRow;

Reporting_how-to-create-a-hierarchical-report-t456484/CS/TreeViewReport/ChildReport.cs#L15

XRSubreport subReport = sender as XRSubreport;
ParentNode parentNode = this.GetCurrentRow() as ParentNode;
ChildReport childReport = new ChildReport();

VB.NET

Reporting_how-to-implement-editing-in-the-preview-form-e26/VB/XtraReport1.vb#L27

Private Sub xrLabel4_BeforePrint(ByVal sender As Object, ByVal e As PrintEventArgs) Handles xrLabel6.BeforePrint, xrLabel5.BeforePrint, xrLabel4.BeforePrint
    CType(sender, XRLabel).Tag = Me.DetailReport.GetCurrentRow()
End Sub

Reporting_sqldatasource-how-to-use-expressionevaluator-to-programmatically-filter-report-t328522/VB/XtraReport2.vb#L27

Private Function IsFit() As Boolean
    Dim rr As ResultRow = TryCast(Me.GetCurrentRow(), ResultRow)

Reporting_how-to-create-a-hierarchical-report-t456484/VB/TreeViewReport/ChildReport.vb#L17

Dim subReport As XRSubreport = TryCast(sender, XRSubreport)
Dim parentNode As ParentNode = TryCast(Me.GetCurrentRow(), ParentNode)
Dim childReport As New ChildReport()