PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

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
Starts Reports & Queries and opens the WINDEV project corresponding to the current application. When Reports & Queries is started and if the WINDEV project is opened, RunReportsAndQueries is also 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.
See Reports & Queries for more details.
Notes:
  • 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 find out the error details, use ErrorInfo associated 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 find out the error details, use ErrorInfo associated with the errMessage constant.
<Report to Open>: Character string (with or without quotes)
Logical name of report that will 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).
During the first call to RunReportsAndQueries, the file corresponding to the report to open (".WDE" file) is automatically checked out from the application library and copied into the "Custom reports and queries" directory (defined when creating the setup procedure of the WINDEV application or when installing the WINDEV application). This file will be used by the end users.
During the next calls to RunReportsAndQueries, the report to open will be sought:
  • 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.
See Distributing Reports & Queries for more details.

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 find out the error details, use ErrorInfo associated with the errMessage constant.
<Type of Element to Create>: Integer constant
Type of element to create:
CreateReportStarts the wizard for report creation
CreateQueryStarts the wizard for query creation
Components
WINDEV wd230etat.dll
Minimum required version
  • Version 10
Comments
Click [Add] to post a comment