RunReportsAndQueries (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Windows management functions

Miscellaneous WINDEV functions

BuildAutomationVariant

Calling a DLL written in Visual Basic

ComponentInfo (Example)

ComponentInfo

ConfigureAAF

Constants for managing the WLanguage types

Constants for sound management

Constants used by ExecutePresetAction

Constants used by the TraceStart function

EndAutomatedProcedure

InAndroidEmulatorMode

InAndroidMode (Example)

InAndroidMode

InAndroidSimulatorMode

InAppleWatchEmulatorMode

InAppleWatchMode

InAppleWatchSimulatorMode

InAutomaticTestMode

InBackgroundMode

InComponentMode

InDelayedProcedureMode

InPocketSimulatorMode

InPrelaunchedSessionMode

InReportsAndQueriesMode

InServiceMode (Example)

InServiceMode

InSimulatorMode

InStoredProcedureMode

InSysNotificationMode

InTSEMode

InTestMode

InUMCMode

InUniversalWindowsAppMode

InUniversalWindowsAppSimulatorMode

InUniversalWindowsPlatformMode

InUniversalWindowsPlatformSimulatorMode

InVGAMode

InWebMode

InWebSocketServerGlobalServiceMode

InWebSocketServerMode

InWindowsPhoneEmulatorMode

InWindowsPhoneMode

InWindowsPhoneSimulatorMode

InWindowsStoreAppMode

InWindowsStoreAppSimulatorMode

OpenDocumentAsynchronous

StyleDrawCaptionGrayed

Voice commands in your applications

WHelp

WINDEVVersion

WLanguage procedure called by OpenDocumentAsynchronous

diffApply

diffCreate

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

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.

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:
CreateQuery Starts the wizard for query creation
CreateReport Starts the wizard for report creation

Component: wd270etat.dll