PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • 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:
Notes:
  • If the report is linked to a query with no parameter, use iPrintReport.
  • 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 iInitReportQueryConnection.
  • Versions 16 and later
    If the report is included in a composite report, iInitReportQuery must be called in the "Initializing" event of the report.
    New in version 16
    If the report is included in a composite report, iInitReportQuery must be called in the "Initializing" event of the report.
    If the report is included in a composite report, iInitReportQuery must be called in the "Initializing" event of the report.

Important

If the query is created with Reports & Queries, there is no need to use iInitReportQuery 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.
iInitReportQuery(RPT_SchoolReport, "Doe", "1994")
iPrintReport(RPT_SchoolReport)
Syntax
iInitReportQuery(<Report name> [, <Parameter 1 of query> [... [, <Parameter N of query>]]])
<Report name>: Character string (with or without quotes)
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 iInitReportQuery 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 re-run the query (e.g add records), simply use HExecuteQuery or iInitReportQuery.

Freeing the query

When printing a report based on a query initialized by iInitReportQuery, the query is freed at the end of the report print (behavior identical to the call to HCancelDeclaration).

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 iInitReportQuery is greater than the number of parameters expected by the query, the additional parameters are ignored.
Component : wd250etat.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment