TotalNbRec (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

WLanguage properties

Properties associated with reports and controls

See also

TotalNbRec (Property)

In french: NbEnrTotal

The TotalNbRec property is used to:

Get the number of records to be printed (e.g., a report based on a file, memory area or query).
Change the number of records to be printed (i.e., set a limit, for example, print only the first 50 records).

Versions 18 and later

This property is now available for reports in iPhone/iPad applications.

New in version 18

This property is now available for reports in iPhone/iPad applications.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Versions 21 and later

This property is now available in Universal Windows 10 App mode.

New in version 21

This property is now available in Universal Windows 10 App mode.

Example

// Change the maximum number of records to be printed
RPT_Customer.TotalNbRec = 25

Syntax

Getting the maximum number of records to be printed Hide the details

<Result> = <Report used>.TotalNbRec

<Result>: Integer

Number of records to be printed,
0 if all the records must be printed.

<Report used>: Report name

Name of the report to be used.

Modifying the maximum number of records to printed Hide the details

<Report used>.TotalNbRec = <New maximum number>

<Report used>: Report name

Name of the report to be used.

<New maximum number>: Integer

New number of records to be printed,
0 if all the records must be printed.

Remarks

Number of records

The NbRecRead property returns the number of records selected by the source of the report (query, view, memory area or Table control).
The NbPrintedRec property returns the number of records selected both by the source of the report AND by the filter code (if any).
The NbRecRead and NbPrintedRec properties return the same value for a report based on a file: the number of records found in the file AND selected by the filter code (if it exists).
The TotalNbRec property is used to determine and change the number of records to print. The number of records to print will be included between 1 and NbPrintedRec.

Type of report

If the report is linked to:

an HFSQL file, the records to print are selected in the beginning of the data file.
a query, the maximum number of records to print can be known and/or modified in the description of advanced options of the query. To display the advanced options of the query linked to the report:
- Select "Edit the query" from the popup menu of report. The query editor is displayed.
- Select "Query description" in the context menu of the query.
- In the window that is displayed, click the "Advanced" button.

Limit

The TotalNbRec property cannot be used on reports without a data source.