RunReportsAndQueries (Function) In french: LanceEtatsEtRequêtes Starts Reports & Queries and opens the WINDEV project corresponding to the current application. If Reports & Queries is started and the WINDEV project is open, RunReportsAndQueries can also be used to: - open a report. This report must be included in a WINDEV library (.WDL file) of the application.
- start the wizard for report creation.
- start the wizard for query creation.
Remarks: - This function is not available in test mode (window or project Go).
- If "Reports and Queries" is not installed on the computer, RunReportsAndQueries displays a specific window allowing the user to find and install this software.
// Opens the WINDEV project corresponding to the current application
// in Reports & Queries
RunReportsAndQueries()
// Opens "RPT_MyStatReport" in Reports & Queries
RunReportsAndQueries(RPT_MyStatReport)
// Starts the wizard for query creation
// in Reports & Queries
RunReportsAndQueries(CreateQuery)
Syntax
Opening the WINDEV project corresponding to the current application in Reports & Queries Hide the details
<Result> = RunReportsAndQueries()
<Result>: Boolean - True if the project corresponding to the current application opened in Reports & Queries,
- False otherwise. To get more details on the error, use ErrorInfo with the errMessage constant.
Opening a report in Reports & Queries Hide the details
<Result> = RunReportsAndQueries(<Report to open>)
<Result>: Boolean - True if the specified report is opened in Reports & Queries,
- False otherwise. To get more details on the error, use ErrorInfo with the errMessage constant.
<Report to open>: Character string Logical name of the report to be opened in Reports & Queries. This report must be modifiable in Reports & Queries ("Modifiable in Reports and Queries" checked in the "Details" tab of the report description).When RunReportsAndQueries is called for the first time, the report file (".WDE" file) is automatically extracted from the application's library and copied to the "Custom reports and queries" directory (defined when creating the WINDEV application setup procedure or installing the WINDEV application). This file will be used by the end users. On subsequent calls to RunReportsAndQueries, the report to be opened will be searched for: - first, in the directory of "Custom reports and queries".
- then, in the directory of "Shared reports and queries".
These directories have been defined in the setup wizard of the application.
Creating a report or a query in Reports & Queries Hide the details
<Result> = RunReportsAndQueries(<Type of element to create>)
<Result>: Boolean - True if the wizard for creating a report or a query was started in Reports & Queries,
- False otherwise. To get more details on the error, use ErrorInfo with the errMessage constant.
<Type of element to create>: Integer constant Type of element to create: | | | CreateQuery | Starts the wizard for query creation | | CreateReport | Starts the wizard for report creation |
|
|
|
|