ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Standard functions / Windows functions / Miscellaneous WINDEV functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
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.
For more details, see Reports & Queries.
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.
Example
// 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.
For more details on Reports & Queries, see Distributing Reports & Queries.

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:
CreateQueryStarts the wizard for query creation
CreateReportStarts the wizard for report creation
Component: wd300etat.dll
Minimum version required
  • Version 10
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help