TotalNbRec (Property)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Help

WLanguage

WLanguage properties

Properties associated with reports and controls

AllModifiableWithReportsAndQueries

BackgroundImagePrinted

BottomMargin

CaptionPeriodHeader

Certificate

EndDatePeriodDisplayed

FontAppointmentContent

InterfaceModifiableWithReportsAndQueries

RTFWithImagesAndTables

StartDatePeriodDisplayed

Number of records
Type of report
Limit

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

TotalNbRec (Property)

In french: NbEnrTotal

..TotalNbRec is used to:

Find out the number of records to print (for a report based on a file, a memory zone or a query).
Modify the number of records to print (which means defining a limit, print the first 50 records for example).

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

// Modify the maximum number of records to print
RPT_Customer..TotalNbRec = 25

Syntax

Finding out the maximum number of records to print Hide the details

<Result> = <Report name>..TotalNbRec

<Result>: Integer

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

<Report name>: Character string (with or without quotes)

Name of report to use.

Modify the maximum number of records to print Hide the details

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

<Report name>: Character string (with or without quotes)

Name of report to use.

<New maximum number>: Integer

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

Remarks

Number of records

..NbRecRead returns the number of records selected by the source of the report (query, view, memory zone or Table control).
..NbPrintedRec returns the number of records selected both by the source of the report AND by the filter code (if it exists).
For a report based on file, ..NbRecRead and ..NbPrintedRec return the same value: the number of records found in the file AND selected by the filter code (if it exists).
..TotalNbRec is used to find out and modify 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:

a HFSQL file, the records to print are selected from the beginning of the 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" from the popup menu of the query.
- In the window that is displayed, click the "Advanced" button.

Limit

..TotalNbRec cannot be used on a report without data source.