PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
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. When Reports & Queries is launched and if the WINDEV project is open, the RunReportsAndQueries function also allows:
  • 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
// Ouvre le projet WINDEV correspondant à l'application en cours
// dans le logiciel Etats & Requêtes
RunReportsAndQueries()
// Ouvre l'état "ETAT_MonEtatStat" dans le logiciel Etats & Requêtes
RunReportsAndQueries(ETAT_MonEtatStat)
// Lance l'assistant de création d'une requête
// dans le logiciel Etats & Requêtes
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 the details of 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 the details of the error, use ErrorInfo with the errMessage constant.
<Report to open>: Character string
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).
When the RunReportsAndQueriesfunction is called for the first time, the file corresponding to the report to be opened (".WDE" file) is automatically extracted from the application's library and copied into the "Personal reports and queries" directory (defined when creating the Procedure of setup of the WINDEV application or when creating the setup of the WINDEV application). This file will be used by the end users.
On subsequent calls to the RunReportsAndQueriesfunction, the report to be opened will be searched:
  • 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 the operation of the Reports & Queries software, 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 the details of the error, use ErrorInfo 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
Component: wd270etat.dll
Minimum version required
  • Version 10
Comments
Click [Add] to post a comment