Description
Reports the number of a row associated with a band in a report.
Syntax
GetRow ( )
Return value
Long. Returns the number of a row if it succeeds, 0 if no data has been retrieved or added, and -1 if an error occurs. Where you call GetRow determines what row it returns, as follows:
|
If the control in the report is in this band |
GetRow returns |
|---|---|
|
Header |
First row on the page |
|
Group header |
First row in the group |
|
Detail |
The row in which the expression occurs |
|
Group trailer |
Last row in the group |
|
Summary |
Last row in the report |
|
Footer |
Last row on the page |
Examples
This expression for a computed field in the detail band displays the number of each row:
GetRow()
This expression for a computed field in the header band checks to see if there is data. It returns the number of the first row on the page if there is data, and otherwise returns No Data:
If(GetRow()= 0, "No Data", String(GetRow()))
See also
