PC SOFT

WINDEV的在线文档

  • Overview
  • Adding a break
  • Adding a break
  • Break header and footer
  • Handling the controls found in the break headers and footers
  • Initializing the controls found in the break headers and footers
  • Retrieving the value of controls found in the break headers and footers
  • Automatic calculations in the looper breaks
  • Handling the break headers and footers by programming
  • Initializing the break headers and footers
  • Functions associated with break headers and footers
  • Properties associated with the break headers and footers
文档页面当前正在翻译。对于此延迟我们深表歉意。
您可以自愿地帮助我们翻译您想要的文档段落,然后只需通过以下地址与我们联系:info@cn.windev.com
产品
WinDevWebDev-服务器代码WebDev-浏览器代码WinDev Mobile报表和查询
平台
WindowsLinuxWindows MobileWindows PhoneWindows Store appsAndroidAndroid Widget iPhone/iPad
语言
JavaPHPAjax用户代码(MCU)外部语言
数据库
HFSQLHFSQL Client/Server存储过程HF 5.5OLE DBODBC本地访问

Overview
A break in a looper is used to group the data corresponding to one or more arguments.

For example, you can list:

  • the customers by country and by city,
  • the invoices per customer,
  • the products according to their family and sub-family, ...
The breaks in the loopers are available for:
  • The browsing Looper controls loaded in memory.
  • The memory Looper controls.

20版本和更高版本
WinDev Note: At run time, the user has the ability to store the status of the current breaks in the Looper control (collapsed breaks, expanded breaks, ...). See Storing the breaks in the Table/Looper controls (AAF) for more details.
20新版本
WinDev Note: At run time, the user has the ability to store the status of the current breaks in the Looper control (collapsed breaks, expanded breaks, ...). See Storing the breaks in the Table/Looper controls (AAF) for more details.
WinDev Note: At run time, the user has the ability to store the status of the current breaks in the Looper control (collapsed breaks, expanded breaks, ...). See Storing the breaks in the Table/Looper controls (AAF) for more details.

Adding a break

Adding a break

To add a break into a Looper control:
  1. Display the description window of the Looper control ("Description" from the popup menu).
  2. In the "Content" tab, click. The window for break management is displayed:
  3. Select the item or the attribute on which a break must be performed. Several items and/or attributes can be selected in order to implement several breaks.
    The proposed items and attributes depend on the type of the looper:
    • In a Looper control linked to a data file:
      • automatic browse: the search item, the attributes linked to this search item and the attributes linked to no item are proposed. If the search item corresponds to a composite key, the components of this composite key, the attributes linked to these components and the attributes linked to no item are proposed.
      • programmed browse: the items of the data file, the attributes linked to these items and the attributes linked to no item are proposed.
    • In a Looper control linked to a query:
      • automatic browse: the search item, the attributes linked to this search item and the attributes linked to no item are proposed. If the search item is not specified ("<Automatic>" option), the sorted query items, the attributes linked to these items and the attributes linked to no item are proposed.
      • programmed browse: the query items, the attributes linked to these items and the attributes linked to no item are proposed.
    • In a memory looper, all the attributes of the looper are proposed.
  4. Validate the window for break management.
  5. The breaks will be performed according to the order in which they are displayed in the table of breaks found in the "Content" tab of the looper description. Modify (if necessary) this order via the arrow buttons found on the right of the table.
17版本和更高版本
WinDevWindows 6. Indicate whether the breaks must be "Breaks with collapsed/expanded". If this option is checked, a "+ /-" button is automatically added into the break header. This button will allow the user to collapse or expand the break.
6. Specify the operating mode of the breaks:
  • WinDevWindowsLinux whether breaks must be "Breaks with collapsed/expanded". If this option is checked, a "+ /-" button is automatically added into the break header. This button will allow the user to collapse or expand the break.
17新版本
WinDevWindows 6. Indicate whether the breaks must be "Breaks with collapsed/expanded". If this option is checked, a "+ /-" button is automatically added into the break header. This button will allow the user to collapse or expand the break.
6. Specify the operating mode of the breaks:
  • WinDevWindowsLinux whether breaks must be "Breaks with collapsed/expanded". If this option is checked, a "+ /-" button is automatically added into the break header. This button will allow the user to collapse or expand the break.
WinDevWindows 6. Indicate whether the breaks must be "Breaks with collapsed/expanded". If this option is checked, a "+ /-" button is automatically added into the break header. This button will allow the user to collapse or expand the break.
6. Specify the operating mode of the breaks:
  • WinDevWindowsLinux whether breaks must be "Breaks with collapsed/expanded". If this option is checked, a "+ /-" button is automatically added into the break header. This button will allow the user to collapse or expand the break.
7. Validate.

Note: Breaks can be created in the single-column loopers and in the multi-column loopers.

Break header and footer

When adding a new break, a break header and a break footer are automatically added to the looper. If the looper includes several breaks, there will be as many break headers and break footers as the number of breaks.

The characteristics of these break headers and footers (name, visibility, background color, ...) can be modified in their description window ("Description" from the popup menu).

Each break header and break footer is associated with the "Row display" process. This process is run when a new break header or break footer is displayed in the looper.

These break headers and footers can contain controls. These controls can be handled by programming.

16版本和更高版本
WinDevWindowsLinux The sums, averages and counts are automatic in the looper breaks. The controls found in the break headers and footers can display these calculations. See automatic calculations in the looper breaks for more details.
16新版本
WinDevWindowsLinux The sums, averages and counts are automatic in the looper breaks. The controls found in the break headers and footers can display these calculations. See automatic calculations in the looper breaks for more details.
WinDevWindowsLinux The sums, averages and counts are automatic in the looper breaks. The controls found in the break headers and footers can display these calculations. See automatic calculations in the looper breaks for more details.

Handling the controls found in the break headers and footers

Initializing the controls found in the break headers and footers

To initialize the controls found in the break headers and footers:
  • handle each control found in all the break headers and footers:
    <Control Name> .. <Property Name> = <Value>
    or
    <Looper Name>.<Name of Break Header/Footer>.<Control Name>..<Property Name> = <Value>
    If <Property Name> corresponds to ..值, only the value of the specified control for the current row is modified
  • handle each control found in a given break:
    <Looper Name>[<Subscript>].<Control Name>..<Property Name> = <Value>
    <Subscript> must correspond to one of the rows found in the specified break.
  • handle each attribute found in all the break headers and footers:
    <Attribute Name> = <Value>
    The property associated with <Attribute Name> will be initialized.
  • handle each attribute of a given break:
    <Attribute Name>[<Subscript>] = <Value>
    The property associated with <Attribute Name> will be initialized.
    <Subscript> must correspond to one of the rows found in the specified break.

Note: These code lines must be found in the "Display process of a row found in the break header/footer".

Retrieving the value of controls found in the break headers and footers

To retrieve the value of controls found in the break headers and footers:
  • handle each control found in the current break:
    <Value> = <Control Name>..<Property Name>
    or
    <Value> = <Looper Name>.<Break Header/Footer Name>.<Control Name>..<Property Name>
  • handle each control found in a given break:
    <Value> = <Looper Name>[<Subscript>].<Control Name>..<Property Name>
    <Subscript> must correspond to one of the rows found in the specified break.
  • handle each attribute found in all the break headers and footers:
    <Value> = <Attribute Name>
    The value of the property associated with <Attribute Name> will be retrieved.
  • handle each attribute of a given break:
    <Value> = <Attribute Name>[<Subscript>]
    The value of the property associated with <Attribute Name> will be retrieved.
    <Subscript> must correspond to one of the rows found in the specified break.

Note: These code lines must be found in the "Display process of a row found in the break header/footer".

16版本和更高版本
Automatic calculations in the looper breaks
WinDev You have the ability to perform automatic calculations (sum, count and average) in the break headers and footers.

To implement the automatic calculations:

  1. Insert a Static control or an edit control into the break header and footer.
  2. Display the description window of the control ("Description" from the popup menu).
  3. In the "GUI" tab, in the "In a break, display" area, click the "No calculation" link or click the description of the calculation (if an automatic calculation was already defined). The description window of an automatic calculation is displayed.
  4. Select the calculation to perform. You can choose:
    • "The sum of": the control will display the sum per break.
    • "The average of": the control will display the average on the break.
    • "The number (count) of": the control will count the number of elements per break.
  5. Select the element on which the calculation must be performed. The calculation can be performed on:
    • A control: the calculation will be performed on the value property of the control.
    • An attribute of the looper: the calculation will be performed on the property of the control.
    • An item of the data file (for the browsing loopers).
  6. Validate.

Tips:

  • Don't forget to modify the input mask of the control that displays the calculation according to the type of calculated information.
  • Don't hesitate to use the "eye magnet" technology on the edit controls that display calculations in the breaks. This gives you the ability you to highlight a calculation (displaying an insufficient turnover in red for example).
16新版本
Automatic calculations in the looper breaks
WinDev You have the ability to perform automatic calculations (sum, count and average) in the break headers and footers.

To implement the automatic calculations:

  1. Insert a Static control or an edit control into the break header and footer.
  2. Display the description window of the control ("Description" from the popup menu).
  3. In the "GUI" tab, in the "In a break, display" area, click the "No calculation" link or click the description of the calculation (if an automatic calculation was already defined). The description window of an automatic calculation is displayed.
  4. Select the calculation to perform. You can choose:
    • "The sum of": the control will display the sum per break.
    • "The average of": the control will display the average on the break.
    • "The number (count) of": the control will count the number of elements per break.
  5. Select the element on which the calculation must be performed. The calculation can be performed on:
    • A control: the calculation will be performed on the value property of the control.
    • An attribute of the looper: the calculation will be performed on the property of the control.
    • An item of the data file (for the browsing loopers).
  6. Validate.

Tips:

  • Don't forget to modify the input mask of the control that displays the calculation according to the type of calculated information.
  • Don't hesitate to use the "eye magnet" technology on the edit controls that display calculations in the breaks. This gives you the ability you to highlight a calculation (displaying an insufficient turnover in red for example).
Automatic calculations in the looper breaks
WinDev You have the ability to perform automatic calculations (sum, count and average) in the break headers and footers.

To implement the automatic calculations:

  1. Insert a Static control or an edit control into the break header and footer.
  2. Display the description window of the control ("Description" from the popup menu).
  3. In the "GUI" tab, in the "In a break, display" area, click the "No calculation" link or click the description of the calculation (if an automatic calculation was already defined). The description window of an automatic calculation is displayed.
  4. Select the calculation to perform. You can choose:
    • "The sum of": the control will display the sum per break.
    • "The average of": the control will display the average on the break.
    • "The number (count) of": the control will count the number of elements per break.
  5. Select the element on which the calculation must be performed. The calculation can be performed on:
    • A control: the calculation will be performed on the value property of the control.
    • An attribute of the looper: the calculation will be performed on the property of the control.
    • An item of the data file (for the browsing loopers).
  6. Validate.

Tips:

  • Don't forget to modify the input mask of the control that displays the calculation according to the type of calculated information.
  • Don't hesitate to use the "eye magnet" technology on the edit controls that display calculations in the breaks. This gives you the ability you to highlight a calculation (displaying an insufficient turnover in red for example).

Handling the break headers and footers by programming

Initializing the break headers and footers

To initialize the break headers and footers, use the following syntax:
<Name of Break Header/Footer>..<Property Name> = <Value>

Note: These code lines must be found in the "Display process of a row found in the break header/footer".

Functions associated with break headers and footers

The following functions are associated with the break headers and footers:
17版本和更高版本
重复区域展开
重复区域展开
Expands a break in the Looper control on a given row.
17版本和更高版本
重复区域展开全部
重复区域展开全部
Expands all the breaks in a Looper control with breaks.
17版本和更高版本
重复区域折叠
重复区域折叠
Collapses a break that was expanded beforehand in a Looper control.
17版本和更高版本
重复区域折叠展开
重复区域折叠展开
On a given row in a Looper control:
  • collapses a break (if it is expanded)
  • expands a break (if it is collapsed).
17版本和更高版本
重复区域收起全部
重复区域收起全部
Collapses all the expanded breaks in a Looper control.
10版本和更高版本
重复区域下标分隔条
重复区域下标分隔条
Returns the subscript of the break header and break footer for a given break in a looper control.

Properties associated with the break headers and footers

Several properties are used to handle the breaks by programming, especially:
收起..收起 is used to:
  • find out or define the status (collapsed or expanded) that will be used when rows are added into a Treeview Table control.
  • find out or modify the collapsed/expanded status for:
    • the breaks of a Table control,
    • the breaks of a Looper control,
    • a HideShow control,
    • a Ribbon control.

To find out the entire list of available properties, see Properties available for the breaks.