ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / Properties associated with reports and controls
  • Number of records
  • Type of report
  • Limit
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
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).
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 in the file AND selected by the filter code (if any).
  • The TotalNbRec property is used to determine and change the number of records to print. The number of records to print will be between 1 and the value of the NbPrintedRec property.

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" in the context 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.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help