PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • 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
..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
iPhone/iPad This property is now available for reports in iPhone/iPad applications.
New in version 18
iPhone/iPad This property is now available for reports in iPhone/iPad applications.
iPhone/iPad 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
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Universal Windows 10 App 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.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment