PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

  • The different types of controls
  • Short description of the different types of controls
  • Static control
  • Item control
  • Calculated control
  • Image control
  • Bar Code control
  • RTF control
  • Preset control
  • Chart control
  • Shape control
  • Check Box control
  • Internal Report control
  • URL Link control
  • Edit control
  • HTML control
  • Signature control
Products
WinDevWebDev - Server codeWebDev - Browser codeWinDev MobileReports and Queries
Platforms
WindowsLinuxWindows MobileUniversal Windows 10 AppAndroidAndroid Widget iPhone/iPadApple Watch
Languages
JavaPHPAjaxUser code (UMC)External language
Databases
HFSQLHFSQL Client/ServerStored proceduresOLE DBODBCNative Accesses
The different types of controls
Several types of controls can be handled in a report created by the report editor:
Note: See the online help about each type of control for more details.
Versions 18 and later
WinDev MobileiPhone/iPad Most of these controls are available in the reports created for the iPhone/iPad applications.
New in version 18
WinDev MobileiPhone/iPad Most of these controls are available in the reports created for the iPhone/iPad applications.
WinDev MobileiPhone/iPad Most of these controls are available in the reports created for the iPhone/iPad applications.
Short description of the different types of controls

Static control

The "Static" control is used to display a character string. This character string can contain:
  • the content of an item (or variable) found in the data source of the report.
  • the content of another control found in the report.
  • a value defined by programming.
To insert the value of a report item or control into the text, the name of the item or control must be entered between the [% and %] characters.
For example, the caption can correspond to: The [%SupplierName%] supplier sells the [%ProductName%] product at [%PriceIOT%]. The SupplierName, ProductName and PriceIOT items will be replaced by their value when printing the report.
The character string can be entered over several lines. In this case, the control must be a multiline control and its size must be large enough.
Reminder: The "Auto-sizable" option is used to automatically increase the size of the control according to its content.
Examples:
Modifying the caption
The caption of a "Static" control can be modified:
  • by programming (..Caption).
  • in the report editor. In this case, two methods are available:
    • Method 1:
      1. Select the control. The selection handles appear around the control.
      2. Click the control again. The mouse cursor turns into an input cursor.
      3. Type the new caption of the control.
      4. Modify (if necessary) the formatting via the formatting toolbar:
        Modify (if necessary) the formatting of the caption via the layout options found on the "Modification" pane, in the "Fast edit" group of the ribbon:
    • Method 2:
      1. Select the control.
      2. Display the description window of the control ("Description" from the popup menu of the control).
      3. Type the new caption in each language supported by the control.
      4. Modify (if necessary) the formatting in the "Style" tab.
Multilingual captions
If your application or your site is multilingual, a different caption can be entered for each language supported by the report.
The corresponding caption will be printed according to the runtime language of the project.
Transforming a "Static" control into an "RTF" control
To display text in RTF format in a "Static" control, check "RTF format" in the "Details" tab of the control description ("Description" from the popup menu of the control).
The "Static" control becomes an "RTF" control. All the characteristics of the "Static" control are kept.
See Static control for more details.
iPhone/iPad The RTF controls are not available.

Item control

The "Item" control is used to edit the content of an item found in a data file. The item can be:
  • an item found in the data source of the report (data file, query, variable, ...).
  • an item of a file accessible by a link.
This control can also be assigned by programming.
Examples:
To define the item linked to the "Item" control:
  1. Display the "Link" tab in the description window of the control ("Description" from the popup menu of the control).
  2. To link the control to an item or to a variable that belongs to the data source of the report, select this item in the "Linked item" list.
  3. To link the control to an item that does not belong to the data source of the report, select "Multi-file" then select the item linked to the current control.
Specific "Item" control: "Currency + Euro"
If the type of the "Item" control is "Currency + Euro", you have the ability to manage:
  • the stored currency: currency of the data found in the data source of the report. If the control is handled by programming, the currency used for the value will be the stored currency.
  • the display currency: currency used to display the value when printing the report. This currency can differ from the stored currency. The conversion is automatically performed.
  • the dual display: two "Currency + Euro" controls can be linked. In this case, the report editor distinguishes between two types of controls:
  • the base control: this control contains the value found in the data source of the report.
  • the tracker control: this control is used to display the value of the base control in the selected currency.
See the Currency + Euro type and the Item control for more details.

Calculated control

The "Calculated" control is used to perform calculations in a report. These calculations can be made:
  • on an item of the data source.
  • on a control found in the report.
  • by programming.
Examples:
Specific "Calculated" control: "Currency + Euro"
If the type of the "Calculated" control is "Currency + Euro", you have the ability to manage:
  • the stored currency: currency of the data found in the data source of the report. If the control is handled by programming, the currency used for the value will be the stored currency.
  • the display currency: currency used to display the value when printing the report. This currency can differ from the stored currency. The conversion is automatically performed.
  • the dual display: two "Currency + Euro" controls can be linked. In this case, the report editor distinguishes between two types of controls:
  • the base control: this control contains the value found in the data source of the report.
  • the tracker control: this control is used to display the value of the base control in the selected currency.
See the Currency + Euro type and the Calculated control for more details.

Image control

An "Image" control is used to display an image in the report. The image displayed in the control can:
  • be selected via the file picker (from the description window of the control).
  • correspond to the content of an item found in the data source (for example, if the data source is a HFSQL file, the item can be an Image memo or a character string containing the full path of the image).
    The "Image" control is linked to this item.
To define the item or the variable linked to the "Image" control:
  1. Display the "Link" tab in the description window of the control ("Description" from the popup menu of the control).
  2. To link the control to an item or to a variable that belongs to the data source of the report, select this item in the "Linked item" list.
  3. To link the control to an item that does not belong to the data source of the report, select "Multi-file" then select the item linked to the current control.
Multilingual images
If your application or your site is multilingual, a different image can be selected for each language supported by the report. This option is useful when the images contain a text for example.
The corresponding image will be printed according to the runtime language of the project.
See The Image control for more details.
WinDevWebDev - Server codeWinDev MobileReports and QueriesiPhone/iPad

Bar Code control

The "Bar code" control is used to easily print bar codes in your reports.
The value of a "Bar code" control corresponds to an alphanumeric string.
The "Bar code" control can be associated with an item found in the data source of the report or it can be assigned by programming.
Versions 19 and later
Note: You also have the ability to specify an initial value in the "General" tab of the description window of the control.
New in version 19
Note: You also have the ability to specify an initial value in the "General" tab of the description window of the control.
Note: You also have the ability to specify an initial value in the "General" tab of the description window of the control.
The report editor proposes several types of bar codes that can be printed horizontally or vertically.
iPhone/iPad This type of control is not available.
Example:
To define the item or the variable linked to the "Bar Code" control:
  1. Display the "Link" tab in the description window of the control ("Description" from the popup menu of the control).
  2. To link the control to an item that belongs to the data source of the report, select this item in the "Linked item" list.
  3. To link the control to an item that does not belong to the data source of the report, select "Multi-file" then select the item linked to the current control.
See The Bar Code control for more details.
WinDevWebDev - Server code

RTF control

The "RTF" (Rich Text Format) control is used to display a formatted character string in your report. This character string is in RTF format. Specific tags are used to define the formatting of each character or character string. These tags are not displayed in the control.
Note: The text displayed in the control can:
  • contain the value of an item or variable printed in the report.
    To insert the value of a report item or control into the text, enter the name of the item or control between the [% and %] characters.
    For example, the text of the control can correspond to: The [%SupplierName%] supplier sells the [%ProductName%] product at [%PriceIOT%]. The SupplierName, ProductName and PriceIOT items will be replaced by their value when printing the report.
  • come from a text item or variable found in the data source of the report.
    If the control is linked to an item (or to a variable), the name of the associated item is displayed in the "Linked item" list of the "Link" tab of the control description.
Example:
Caption of a report that is using fonts of different colors
Caption of a report that is using fonts of different colors
Modifying the text of an "RTF" control
The text of an "RTF" control can be modified:
  • by programming (..Caption).
  • in the report editor:
    1. Select the control (click the control for example). The selection handles appear around the control.
    2. Click the control again. The mouse cursor turns into an input cursor.
    3. Enter the new text of the control.
    4. Modify (if necessary) the formatting of the text via the formatting toolbar that is displayed above the control:
Transforming a "Static" control into an "RTF" control
To display text in RTF format in a "Static" control, check "RTF format" in the "Details" tab of the control description ("Description" from the popup menu of the control).
The "Static" control becomes an "RTF" control. All the characteristics of the "Static" control are kept.
Transforming an "Item" control into an "RTF" control
To display text in RTF format in an "Item" control, check "RTF format" in the "Details" tab of the control description ("Description" from the popup menu of the control).
The "Item" control becomes an "RTF" control. All the characteristics of the "Item" control are kept.
Transforming an "RTF" Control into an "Item" control
To display the RTF tags or to link the control to an item other than a text item, uncheck "RTF format" in the "Details" tab of the control description ("Description" from the popup menu of the control).
The "RTF" control becomes an "Item" control. All the characteristics of the "RTF" control are kept.

Preset control

The preset control is used to display current information without any programming. A "Preset" control can be inserted into a report to display the following information:
  • System date,
  • System time,
  • Number of the current page,
  • Total number of pages in the report,
  • Number of the current page in relation to the total number of pages in the report.
Example:
To modify the type of information displayed in a "Preset" control:
  1. Display the "General" tab in the description window of the "Preset" control ("Description" from the popup menu of the control).
  2. Select the type of displayed information ("Type" combo box).
  3. Validate.
See Preset control for more details.

Chart control

The "Chart" control is used to view and print a chart in your reports. The available types of charts are as follows:
  • Pie, donut, semi-circular.
  • Column (grouped or stacked, vertical or horizontal)
  • Line, area
  • Scatter, radar
  • Versions 17 and later
    Bubble chart
    New in version 17
    Bubble chart
    Bubble chart
  • Stock chart (Candlestick, MinMax or BarChart).
Notes:
  • This control is not available in WINDEV Mobile.
  • This control cannot be linked to a variable.
Example:
Information specific to the chart creation
A wizard for chart creation is automatically started. This wizard is used to enter the information required to create the Chart control. This information is as follows:
  • the type of chart (stock, pie, line, ...).
  • the mode for filling the chart (source identical to the one of the report or fill by programming).
  • the number of series.
  • the source of the caption for the series. This caption comes from a control or from an item found in the data source associated with the report. This caption corresponds to:
    • the label of a data category (or section).
    • the label of a data series.
Category label
Series label
  • For each series:
    • the color and the caption of the series.
    • the source of the series. The values of the series come from a control or from an item found in the data source associated with the report.
  • the fill block.
  • the frequency of the marks on the vertical/horizontal axis of the chart (if necessary).
  • the style of the chart (relief, color gradients and gridlines).
  • the titles of the axes if necessary.
You also have the ability to create a Chart report or a Table + Chart report. See The different types of reports for more details.
Notes:
  • Windows Mobile This control is not available.
  • iPhone/iPad Only the Chart controls created from version 17 (or updated) are available.
  • The series of the Chart control can be linked to an Array variable.
Example:
Information specific to the chart creation
A wizard for chart creation is automatically started. This wizard is used to enter the information required to create the Chart control. This information is as follows:
  • the type of chart (stock, pie, line, ...).
  • the parameters of the chart: title, legend, 3D chart, display of labels, ...
  • the parameters of axes: titles, grid, ...
  • the characteristics of series:
    • the source and the data displayed by the category labels (programming, data file, query, WLanguage array, data source of the report).
    • the name of the series (used for the series labels):
    • the source of the series (programming, data file, query, WLanguage array, data source of the report)
    • the data displayed by the series.
    • the thickness of the line, the color and the type of dots.
Note: if the data source corresponds to the data source of the report, you have the ability to define:
  • the fill block,
  • the control or the item corresponding to the series,
  • the selection mode of data.
See Chart control for more details.

Shape control

A "Shape" control is used to insert geometric shapes into a report. You have the ability to insert:
  • horizontal or vertical lines,
  • circles,
  • rectangles (with straight or rounded borders).
The style, the thickness and the color of the line can be configured.

Check Box control

A "Check box" control corresponds to a box to check.
If the value of the control is set to True, the box is checked::
If the value of the control is set to False, the box is unchecked:
A "Check box" control can be linked to an item or variable found in the data source of the report. For example, if the data source corresponds to a HFSQL file, the item can be a boolean or a check box.
The size, the background color and the color of the check box can be configured.
Example:
To define the item or the variable linked to the "Check Box" control:
  1. Display the "Link" tab in the description window of the control ("Description" from the popup menu of the control).
  2. To link the control to an item or to a variable that belongs to the data source of the report, select this item in the "Linked item" list.
  3. To link the control to an item that does not belong to the data source of the report, select "Multi-file" then select the item linked to the current control.

Internal Report control

The "Internal report" controls are used to print several reports (secondary reports) in a single report (main report) without programming.
For example, the following main report is made of two secondary reports printed side-by-side:
  • a report displaying the data in a table.
  • a report displaying the data in a chart.
See Internal report for more details.
Benefits of internal reports compared to the nested reports
The report editor can also be used to simultaneously print several reports via nested reports. However, the nested reports are a bit more complicated to use. Indeed, the nested reports require:
  • the use of iPrintReport to print the secondary report.
  • the obligation to print the nested report after the main report. These reports cannot be printed side by side.
The internal reports allow you to print several reports without programming:
  • one below another,
  • side by side.
See Nested reports for more details.

URL Link control

A "URL link" control is used to insert links into a report. You have the ability to insert:
  • a link to an email address,
  • a link to an Internet site,
  • ...
The "URL Link" control is enabled only if the report is printed in an HTML file. Otherwise, the "URL link" control is visible but it is disabled.
Example:
To define the item or the variable linked to the "URL link" control:
  1. Display the "Link" tab in the description window of the control ("Description" from the popup menu of the control).
  2. To link the control to an item or to a variable that belongs to the data source of the report, select this item in the "Linked item" list.
  3. To link the control to an item that does not belong to the data source of the report, select "Multi-file" then select the item linked to the current control.

Edit control

An edit control is used to enter and display text in a report. You can use an edit control:
  • to allow the user to enter the information to print,
  • to allow the user to modify the information to print,
  • ...
The edit control is enabled only if the report is displayed in "Print preview" mode or if it is printed in a PDF file. In the other cases, the edit control is visible but it is disabled.
Characteristics of edit controls
When creating an edit control in a report, you have the ability to define:
  • the type of control (text, numeric, date, time),
  • the associated mask: the available masks are the ones supported by the PDF format. They are available for the numerics, the dates and the times.
  • the input size, which means the maximum number of characters allowed in the control. If this parameter is set to 0, there is no limit.
  • the horizontal alignment,
  • the initial value,
  • the style of the caption and input area.
Notes:
  • Multi-line edit control: if the users enter more lines than what is visible, the non-visible lines will not be printed. During the input, the edit controls manage a vertical scrollbar.
  • Style of the input area: In this version, only the "Arial" font can be used.
  • The edit control is not linked to an item found in a file or in a query. To display information coming form a file or from a query, the control must be assigned by programming.
  • The border of the input area cannot be configured (thickness, color, ...).
  • No currency type can be used (the Euro symbol is not supported).
  • iPhone/iPad This type of control is not available (Acrobat on iOS does not support the input).
See Editable reports for more details.
Versions 18 and later
WinDevWebDev - Server codeWindows

HTML control

The "HTML" control is used to display and print an HTML content in your report. The HTML content corresponds to a character string in HTML format. Specific tags are used to define the formatting of each character or character string. These tags are not displayed in the control.
Note: The text displayed in the control can:
  • contain the value of an HTML edit control found in a window.
  • come from an HTML file found on the computer.
  • come from a Memo item or from a text variable found in the data source of the report.
    If the control is linked to an item (or to a variable), the name of the associated item is displayed in the "Linked item" list of the "Link" tab of the control description.
See HTML control for more details.
New in version 18
WinDevWebDev - Server codeWindows

HTML control

The "HTML" control is used to display and print an HTML content in your report. The HTML content corresponds to a character string in HTML format. Specific tags are used to define the formatting of each character or character string. These tags are not displayed in the control.
Note: The text displayed in the control can:
  • contain the value of an HTML edit control found in a window.
  • come from an HTML file found on the computer.
  • come from a Memo item or from a text variable found in the data source of the report.
    If the control is linked to an item (or to a variable), the name of the associated item is displayed in the "Linked item" list of the "Link" tab of the control description.
See HTML control for more details.
WinDevWebDev - Server codeWindows

HTML control

The "HTML" control is used to display and print an HTML content in your report. The HTML content corresponds to a character string in HTML format. Specific tags are used to define the formatting of each character or character string. These tags are not displayed in the control.
Note: The text displayed in the control can:
  • contain the value of an HTML edit control found in a window.
  • come from an HTML file found on the computer.
  • come from a Memo item or from a text variable found in the data source of the report.
    If the control is linked to an item (or to a variable), the name of the associated item is displayed in the "Linked item" list of the "Link" tab of the control description.
See HTML control for more details.
Versions 21 and later
WinDevWebDev - Server codeWindows

Signature control

The "Signature" control is used to sign the reports printed in PDF format. Two types of signatures are available:
  • Approval signature,
  • Certification signature.
See Signature control for more details.
New in version 21
WinDevWebDev - Server codeWindows

Signature control

The "Signature" control is used to sign the reports printed in PDF format. Two types of signatures are available:
  • Approval signature,
  • Certification signature.
See Signature control for more details.
WinDevWebDev - Server codeWindows

Signature control

The "Signature" control is used to sign the reports printed in PDF format. Two types of signatures are available:
  • Approval signature,
  • Certification signature.
See Signature control for more details.
Related Examples:
WD Reports Training (WINDEV): WD Reports
[ + ] This example presents the different methods for creating a report:

- prints based on different data sources (queries, variables, ...)
- prints based on controls (Table, Spreadsheet, PVT, ...)
- printing composite reports
- specific prints (portrait/landscape, report with watermark, report with bar code, ...)
Minimum required version
  • Version 9
This page is also available for…
Comments
Create links in reports
//criar links nos relatorios
//para abrir pagina e email

// Create links in reports
// To open page and email

PROCEDURE RPT_Relatorio_Duplicata_Receber_Geral_Aberto()

//colocar site no link
//Put site in link
IF empresa.pagina[[1 TO 7]]="http://" THEN
//Se as 7 primeiras letras for http://
//If the first 7 letters are http: //
LINK_pagina_empresa..URL=empresa.pagina
//link url é igual empresa pagina
//Link url is the same company page
ELSE
//senão
//
LINK_pagina_empresa..URL="http://"+empresa.pagina
//link url é igual http:// mais empresa pagina
//Link url is equal http: // more company page

END
LINK_pagina_empresa..Caption=empresa.pagina
// link caption = empresa pagina
// Link caption = company page


//Blog com Video e Exemplo

https://forum.pcsoft.fr/pt-BR/pcsoft.br.windev/2225-aula-1102-windev-relatorio-048-links-para-abrir/read.awp

http://windevdesenvolvimento.blogspot.com.br/2017/03/aula-1102-windev-relatorio-048-links.html

h
De matos
Mar. 25 2017