iInitReportQuery (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Internal Report control: report based on a query with parameters

Running a query and report based on this query

iChangeSubReportSource

iInitReportQueryConnection

iReportPrintingStatus

Internal Report control: report based on a query with parameters
Running a query and report based on this query
Freeing the query
Various

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

iInitReportQuery (Function)

In french: iInitRequêteEtat

Initializes the query linked to the report (for a query with parameters). This function can be called:

in the initialization code of report,
before iPrintReport.

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.

Versions 18 and later

This function is now available for iPhone/iPad applications.

New in version 18

This function is now available for iPhone/iPad applications.

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.


	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.

Example

See additional examples

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 : wd240etat.dll