To create a Rowset object

Parent Previous Next

 

Report Application Server .NET SDK Developer Guide

To create a Rowset object

 







The Rowset object is a structure that stores rows of filtered records in a flat, unnormalized format. ARowset object can store any kind of data from any database that your report can access. In this example a Rowset object is created containing fields from a report.

  1. Create a RowsetMetaData object.

Visual Basic

Dim rowsetMD As New RowsetMetaData()

C#

RowsetMetaData rowsetMD = new RowsetMetaData();
  1. Add the fields to the RowsetMetaData object.

In this example the RowsetMetaData object is populated with result fields from the report. Any Field object can be used to populate the RowsetMetaData.

Visual Basic

Dim resultFields As Fields = rcd.DataDefinition.ResultFields 
rowsetMD.DataFields = resultFields

C#

Fields resultFields = rcd.DataDefinition.ResultFields;
rowsetMD.DataFields = resultFields;
  1. Use the RowsetBatchSize property of the RowsetController object to set the number of records to retrieve in each batch.

Visual Basic

Dim rowController As RowsetController = rcd.RowsetController 
rowController.RowsetBatchSize = pageSize

C#

RowsetController rowController = rcd.RowsetController;
rowController.RowsetBatchSize = pageSize;
  1. Create a RowsetCursor object using the CreateCursormethod of the RowsetController object.

Visual Basic

Dim rowCursor As RowsetCursor = rowController.CreateCursor(Nothing, rowsetMD, 0) 

C#

RowsetCursor rowCursor = rowController.CreateCursor(null, rowsetMD, 0);
  1. Retrieve an instance of the Rowset object using the Rowset property of the RowsetController object.

Visual Basic

Dim currentRowset As Rowset = rowCursor.Rowset

C#

Rowset currentRowset = rowCursor.Rowset;

This example creates a Rowset object containing result fields pulled from the report.

Visual Basic

Private Function CreateRowset(ByVal rcd As ISCDReportClientDocument, ByVal pageSize As Integer) As Rowset
 Dim rowsetMD As New RowsetMetaData()
 Dim resultFields As Fields = rcd.DataDefinition.ResultFields
 rowsetMD.DataFields = resultFields
 Dim rowController As RowsetController = rcd.RowsetController
 rowController.RowsetBatchSize = pageSize
 Dim rowCursor As RowsetCursor = rowController.CreateCursor(Nothing, rowsetMD, 0)
 Dim currentRowset As Rowset = rowCursor.Rowset
 Return currentRowset
End Function

C#

private Rowset CreateRowset(ISCDReportClientDocument rcd, int pageSize)
{
 RowsetMetaData rowsetMD = new RowsetMetaData();
 Fields resultFields = rcd.DataDefinition.ResultFields;
 rowsetMD.DataFields = resultFields;
 RowsetController rowController = rcd.RowsetController;
 rowController.RowsetBatchSize = pageSize;
 RowsetCursor rowCursor = rowController.CreateCursor(null, rowsetMD, 0);
 Rowset currentRowset = rowCursor.Rowset;
 return currentRowset;
}

This list includes the namespaces used by the sample code:

© 2021 SAP AG. All rights reserved.

http://www.sap.com/sapbusinessobjects/

Support services

http://service.sap.com/bosap-support/

Created with the Personal Edition of HelpNDoc: Free HTML Help documentation generator