Home | Sign in | English UK
  • Overview
  • Example
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Stored procedures
Clickable control in a report
The report editor allows you to propose clickable controls during the print preview.
When printing an invoice, the user wants to see all the details about the selected customer or all the characteristics of the products ordered? Nothing's easier, all you have to do is modify the click code of the control to perform the requested operation.
In the print preview, the clickable areas can be easily identified by the symbol. Furthermore, these areas are colored in yellow when they are hovered by the mouse cursor.
A report lists the customers by zip code. The user wants to display the customer form by clicking his name. The customer form already exists in the project, it must be linked to the click performed on the Name control in the report.
To open the window from the print preview directly:
  1. Open the report in the report editor.
  2. Select the control to click and display the different events available ( "Code" option in the popup menu).
  3. Write the following code in the event "Click xxx":
    Open(WIN_CustomerForm, "Modif", MySource.CustomerID)

    This code is used to:
    • open the "WIN_CustomerForm" window in modification mode
    • pass the identifier of the customer in parameter to the window (this identifier is found in the embedded query). The MySource keyword allows managing the source of the report.
Caution: If a query is associated with the report, the query is automatically closed at the end of the report execution. The items of this query are no longer accessible.
See also
Minimum version required
  • Version 10
This page is also available for…
Click [Add] to post a comment