PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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).
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Modifier le nombre maximum d'enregistrements à imprimer
ETAT_Client.NbEnrTotal = 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 be printed will be between 1 and the value of Property 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.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment