Sometimes it is necessary to manage report DataSets directly from the template.

DataSets which are attached to the report, may be accessed using cursor navigation commands and functions. These functions are described below.

 

EOF(Table) - Indicates whether or not a cursor is positioned at the last record in a Table. 
BOF(Table) - Indicates whether or not a cursor is positioned at the first record in a Table. 
LAST(Table) - Positions the cursor on the last record in the Table.

 

FIRST(Table) - Positions the cursor on the first record in the Table.

NEXT(Table) - Positions the cursor on the next record in the Table.

PRIOR(Table) - Positions the cursor on the previous record in the Table.

For example \eof(a)\, \next(table1)\.

NOTE: You should not use these functions at the same time with SCAN command having data table name. You may use these functions in SCAN with no name mentioned, for example: 

\Scan(), while( ! eof(table1))\ 
..... 
\endscan, next(table1)\

Next topic: Numeric functions