PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
New WINDEV, WEBDEV and WINDEV Mobile 26 feature!
This content has been translated automatically. Click here to view the French version.
  • Internal Report control: report based on a query with parameters
  • Running a query and report based on this query
  • Freeing the query
  • Various
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
Initializes the query linked to the report (for a query with parameters). This function can be called:
Remarks:
  • If the report is linked to a query with no parameter, use <Report>.Print.
  • If the report is linked to a query (with or without parameters) that is using a specific connection (connection to a database via an OLE DB provider for example), use <Report>.InitRequestConnection.
  • Versions 16 and later
    If the report is included in a composite report, <Report>.InitRequest must be called in the "Initializing" event of the report.
    New in version 16
    If the report is included in a composite report, <Report>.InitRequest must be called in the "Initializing" event of the report.
    If the report is included in a composite report, <Report>.InitRequest must be called in the "Initializing" event of the report.
Versions 15 and later
Linux This function is now available for WINDEV applications in Linux.
WEBDEV - Server codeLinux This function is now available for WEBDEV sites in Linux.
Linux Caution: A specific configuration is required to use this function in Linux. For more details, see Print in Linux.
New in version 15
Linux This function is now available for WINDEV applications in Linux.
WEBDEV - Server codeLinux This function is now available for WEBDEV sites in Linux.
Linux Caution: A specific configuration is required to use this function in Linux. For more details, see Print in Linux.
Linux This function is now available for WINDEV applications in Linux.
WEBDEV - Server codeLinux This function is now available for WEBDEV sites in Linux.
Linux Caution: A specific configuration is required to use this function in Linux. For more details, see Print in Linux.

Important

If the query is created with Reports & Queries, there is no need to use <Report>.InitRequest to specify the query parameters. Indeed, when a report based on a query with parameters is run from Reports & Queries, a window allows you to enter the query parameters.
Example
ETAT_BulletinScolaire.InitQuery("Dupond", "1994")
STATE_SchoolNewsletter.Print()
Syntax
<Report used>.InitQuery([<Parameter 1 of query> [... [, <Parameter N of query>]]])
<Report used>: Report name
Logical name of report to print.
<Parameter 1 of query>: Type of query parameter (optional)
First parameter of query defined as report source (if the query expects a parameter).
<Parameter N of query>: Type of query parameter (optional)
Last parameter of query defined as report source (if the query expects a parameter).
Remarks

Internal Report control: report based on a query with parameters

If the report associated with an "Internal Report" control is based on a query with parameters, use <Report>.InitRequest to pass the parameters to the query. This function must be used in the event "Before printing" of the block containing the "Internal report" control.
See Internal Report control for more details.

Running a query and report based on this query

When printing a report based on a query, the query is not re-run if it was already run. To force the re-execution of the query (e.g., add records), simply use 0 or <Report>.InitRequest.

Freeing the query

When printing a report based on a query initialized by <Report>.InitRequest, the query is freed at the end of the report print (behavior identical to the call to <Source>.CancelDeclaration).

Various

  • If some of the parameters expected by the query are not specified (value corresponding to NULL for example), the selection conditions corresponding to these parameters will be ignored.
  • If the number of parameters specified in <Report>.InitRequest is greater than the number of parameters expected by the query, the additional parameters are ignored.
Business / UI classification: Neutral code
Component: wd260etat.dll
Minimum version required
  • Version 26
This page is also available for…
Comments
Click [Add] to post a comment