Properties associated with the Pivot Table control

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Overview
Properties available in a window
Properties that can be used on the pivot table
Properties that can be used on a row, a column or a filter
Properties that can be used on a value displayed in a cell
Properties available in a report
Properties that can be used on the pivot table
Properties that can be used on a value displayed in a cell

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Properties associated with the Pivot Table control

Overview

A Pivot Table control can be handled in WLanguage:

in a window.
Versions 21 and later
in a report.
New in version 21
in a report.
in a report.

Properties available in a window

Properties that can be used on the pivot table

The following properties are associated with the Pivot Table controls:


Versions 09 and later Anchor New in version 09 Anchor Anchor	The Anchor property is used to manage the anchors of a control in a window or report.
Versions 09 and later AnchorRateBottom New in version 09 AnchorRateBottom AnchorRateBottom	..AnchorRateBottom is used to: Find out the anchor rate when a control moves on the vertical axis. Modify the anchor rate when a control moves on the vertical axis.
Versions 09 and later AnchorRateHeight New in version 09 AnchorRateHeight AnchorRateHeight	..AnchorRateHeight is used to: Find out the anchor rate in height of a control. Modify the anchor rate in height of a control.
Versions 09 and later AnchorRateRight New in version 09 AnchorRateRight AnchorRateRight	The Property RateRight allows: Find out the anchor rate when a control moves on the horizontal axis. Modify the anchor rate when a control moves on the horizontal axis.
Versions 09 and later AnchorRateWidth New in version 09 AnchorRateWidth AnchorRateWidth	The Property WidthAnchorRate allows you to: Find out the anchor rate when a control (or a table column) stretches on the horizontal axis. Modify the anchor rate when a control (or a table column) stretches on the horizontal axis.
Versions 21 and later AutoLineWrap New in version 21 AutoLineWrap AutoLineWrap	The AutoLineWrap property is used to: find out whether the line wrap is automatically supported in a multiline edit control or in a column found in a table (or in a treeview table). indicate the line wrap management mode in a multiline edit control or in a column in a table (or in a treeview table)
Versions 15 and later AutomaticTooltip New in version 15 AutomaticTooltip AutomaticTooltip	0
Versions 09 and later BackgroundColor New in version 09 BackgroundColor BackgroundColor	..BackgroundColor is used to manage the background color of a control, window, page or report block.
Versions 14 and later BackgroundImageLine New in version 14 BackgroundImageLine BackgroundImageLine	The Property Image FondLigne makes it possible to know and modify the Image of Background used for each row: of a Table control, of a TreeView Table control, of a Looper control.
Versions 14 and later Border New in version 14 Border Border	..Border is used to find out and modify the border characteristics: for a report control or for a report block. for a window control. for a cell of a Table control.
Versions 09 and later BrowsedFile New in version 09 BrowsedFile BrowsedFile	The Property BrowseFile allows you to know and modify the HEX@ of data used to display records in a data file based fields.
Versions 09 and later Caption New in version 09 Caption Caption	In a database, ..Caption is used to: Find out the caption associated with a file item. Find out the caption associated with a data file. Find out and modify the connection caption. In a report, ..Caption is used to: Find out the text displayed in a Static or Link control. Modify the text displayed in a Static or Link control. In a window or in a page, ..Caption is used to: Find out and modify the caption of a control in a window or in a page. Find out and modify the caption of a menu option. Find out and modify the title of a window or page. Find out the content of a site map path.
Versions 09 and later Color New in version 09 Color Color	..Color is used to find out and modify the font color for: a font variable. a text displayed in a Static control or in a calculated control of a report. a text displayed in a window control. a text displayed in a page control.
Versions 12 and later Count New in version 12 Count Count	..Count is used to find out the number of elements in a set.
Versions 09 and later DisplayEnabled New in version 09 DisplayEnabled DisplayEnabled	The DisplayEnabled property is used to: find out whether the display of a control or window is enabled or not. If the display is enabled, the content of the control is refreshed on a regular basis. enable (or not) the display of a control or window.
Versions 09 and later DndSource New in version 09 DndSource DndSource	..DndSource is used to find out and modify the behavior of a control during Drag and Drop.
Versions 09 and later DndTarget New in version 09 DndTarget DndTarget	..DndTarget is used to find out and modify the behavior of a control during Drag and Drop.
Versions 09 and later DoubleClick New in version 09 DoubleClick DoubleClick	..DoubleClick allows you to know and modify the name of the Button control that will be executed when double-clicking on a control.
Versions 09 and later Empty New in version 09 Empty Empty	..Empty is used to find out whether: a Looper, Table, List Box or Combo Box control is empty. The control can be a browsing control or a memory control. a Chart control contains no series. a report control is empty (control linked to an item). an array (or an associative array) contains no element. an element of an associative array exists or not. a queue, a list or a stack contains no element.
Versions 16 and later FocusOnClick New in version 16 FocusOnClick FocusOnClick	..FocusOnClick is used to: Find out whether a control gains focus during a click. Modify the effect for taking focus during the click on a control.
Versions 09 and later FontCharset New in version 09 FontCharset FontCharset	The Property PoliceAlphabet allows: Find out the character set used by the screen fonts of a control. Modify the character set used by the screen fonts of a control.
Versions 09 and later FullName New in version 09 FullName FullName	FullName is used to find out the full name: of a control. of a window. of a menu option. of a table column.
Versions 17 and later Grayed New in version 17 Grayed Grayed	..Grayed is used to: Find out whether a control (or a group of controls) is grayed or not. Gray or ungray a control or a group of controls.
Versions 09 and later Group New in version 09 Group Group	..Group is used to: find out whether the control belongs to a group of controls. If the control belongs to one or more groups, ..Group is used to identify these groups of controls. associate a control with a group of controls.
Versions 09 and later Height New in version 09 Height Height	The Property Height allows to know and modify the height: of a control or block in a report. of a control (in a window), window, row of a Table, List Box or ListView control, option of a Radio Button or Check Box control, break header or footer of a Table or Looper control. of a control (in a page), break header or footer in a Looper control. The control can be overlayable or not.
Versions 09 and later HelpNumber New in version 09 HelpNumber HelpNumber	The HelpNumber property is used to identify and modify the help number associated with a control.
Versions 09 and later InitialHeight New in version 09 InitialHeight InitialHeight	The Property InitialHeight allows you to: Find out the creation height of a control or window. Modify the base height used to anchor the controls "in height". Find out the creation height of a block or control in a report.
Versions 09 and later InitialState New in version 09 InitialState InitialState	The Property StateInitial makes it possible to know the initial report of an Control.
Versions 09 and later InitialVisible New in version 09 InitialVisible InitialVisible	The Property VisibleInitial can be used to determine whether: a control was visible during the first display of the associated window or page. a window was visible during its first display.
Versions 09 and later InitialWidth New in version 09 InitialWidth InitialWidth	The Property InitialWidth makes it possible to: Find out the initial width of a control or window. Modify the base width used to anchor the controls in "width". Find out the initial width of a report control.
Versions 11 and later LeftIndent New in version 11 LeftIndent LeftIndent	..LeftIndent is used to find out and modify the available space on the left of text in: the columns of Table and TreeView Table controls (between the beginning of column and the beginning of text). the edit controls. the Combo Box and List Box controls. the Button controls. the Ribbon controls. the Tab controls. The Static controls.
Versions 09 and later LineHeight New in version 09 LineHeight LineHeight	The Property LineHeight allows you to know and modify the height of the lines: in a List Box control, in a ListView control (standard display mode only), in a Table control, in a Combo Box control, in a Looper control (height of the row), in an Organizer control.
Versions 09 and later MaxHeight New in version 09 MaxHeight MaxHeight	The Property HeightMax allows to know and modify the maximum height of an control or a window.
Versions 09 and later MaxWidth New in version 09 MaxWidth MaxWidth	MaxWidth is used to find out and modify the maximum width of a control or window.
Versions 11 and later Message New in version 11 Message Message	The Property Message allows you to: Find out the help message associated with a control or with a menu option (in a window). Modify the help message associated with a control or with a menu option (in a window).
Versions 09 and later MinHeight New in version 09 MinHeight MinHeight	MinHeight is used to find out and modify the minimum height of a control or window.
Versions 09 and later MinWidth New in version 09 MinWidth MinWidth	..MinWidth is used to find out and modify the minimum width of a control or window.
Versions 09 and later MouseCursor New in version 09 MouseCursor MouseCursor	The Property MouseCursor allows you to know and modify the hover cursor defined for an control, a window or a page.
Versions 12 and later Multiselection New in version 12 Multiselection Multiselection	..Multiselection is used to find out and modify the selection mode: of a Table (and TreeView Table) control. of a Pivot Table control. of a List Box (and ListView) control. of a Looper control. of a Calendar control. of files in an Upload control.
Versions 09 and later Name New in version 09 Name Name	Name is used to find out the name of the font associated with a Font variable. the name of a control, report or report block. the name of a control, group of controls or window. the name of a control, group of controls or page.
Versions 09 and later NewLine New in version 09 NewLine NewLine	The Property New allows you to know: in a Table control, whether the current row was created by TableAddXXX or TableInsertXXX. in a Looper control, whether the current row was created by LooperAddXXX or LooperInsertXXX. in an Organizer control, whether an appointment was created via the popup menu. in a Scheduler control, whether an appointment was created via the popup menu.
Versions 09 and later NoteTitle New in version 09 NoteTitle NoteTitle	The Property TitleNote allows to: Find out the title of the notes used in the program documentation of a control, window, page or report. Modify the title of the notes used in the program documentation of a control, window, page or report.
Versions 09 and later NumberColumn New in version 09 NumberColumn NumberColumn	NumberColumn is used to: Find out the number of columns in a control containing columns (Table, Check Box, Radio Button controls, etc.). Modify the number of columns in a multi-column List Box control.
Versions 09 and later Opacity New in version 09 Opacity Opacity	The Property Opacity allows you to know and define the opacity percentage of a window or of the fields present in a window or a page.
Versions 19 and later Pane New in version 19 Pane Pane	The Property Volet makes it possible to: Find out the pane tabs associated with a control. Define the pane tabs associated with a control.
Versions 21 and later ParallaxRateHeight New in version 21 ParallaxRateHeight ParallaxRateHeight	..ParallaxRateHeight is used to find out and specify the speed at which a control is reduced when the scrollbar found in the window, the internal window or the page moves.
Versions 21 and later ParallaxRateY New in version 21 ParallaxRateY ParallaxRateY	The Property RateParallaxisY allows you to know and indicate how fast an control is moving when the scrollbar of the window, the internal window or the page is moving.
Versions 09 and later Plane New in version 09 Plane Plane	Plane is used to: Find out: the active plane of a window (or report) or the plane to which a control belongs. the active plane of a WEBDEV element. Modify: the active plane of a window (or report) or associate a control with another plane. the active plane of a WEBDEV element.
Versions 09 and later PopupMenu New in version 09 PopupMenu PopupMenu	PopupMenu is used to: Find out the custom popup menu associated with a control or window. Modify the popup menu associated with a control or window (associate another popup menu with the control or window). Customize the system menus of controls by adding options.
Versions 19 and later Process New in version 19 Process Process	The Process property is used to modify the processes to be executed by the events available on a control, window, page, report, etc.
Versions 18 and later ProgressBar New in version 18 ProgressBar ProgressBar	0
Versions 09 and later Note New in version 09 Note Note	Note is used to: Find out the notes associated with a control, a window, a page or a report. Modify the notes associated with a control, a window a page or a report.
Versions 09 and later RightClick New in version 09 RightClick RightClick	RightClick is used to find out and modify the name of the button that will be run when a right click is performed on an object.
Versions 12 and later RightToLeft New in version 12 RightToLeft RightToLeft	The RightToLeft property allows to know the real set direction, effective on an control, a column, a window or an report.
Versions 09 and later State New in version 09 State State	The Property Report makes it possible to know and modify the display report of an item.
Versions 20 and later Style New in version 20 Style Style	The Property Style allows you to retrieve or affect the complete style of an Control (including overloads).
Versions 09 and later TABOrder New in version 09 TABOrder TABOrder	The Property NumTAB allows you to know and modify the position of an control in the tab order of a window.
Versions 15 and later TextDirection New in version 15 TextDirection TextDirection	The TextDirection property is used to determine and change the writing direction in a window, report or control (useful for languages such as Arabic or Hebrew).
Versions 09 and later ToolTip New in version 09 ToolTip ToolTip	The Property Bubble allows you to know and modify the text displayed in the tooltip associated with an Control of a window or a page.
Versions 09 and later TotalsEnabled New in version 09 TotalsEnabled TotalsEnabled	The Property TotalActive allows to: Find out the operating mode of column calculations (automatic or custom) for a Table or TreeView Table control, Temporarily forbid or force the column calculations (automatic or custom) in a Table or TreeView Table control.
Versions 09 and later Type New in version 09 Type Type	Type is used to find out: the type of element described by programming (file or item description) or not (file or item defined in the data model editor, view or query). the type of object. the type of value stored in a variant.
Versions 09 and later Value New in version 09 Value Value	The Property Value allows to: Find out and modify the value of a report control. Find out and modify the value of a control or the title of a window. Find out the identifier of a stream. Find out and modify the value of a control or the title of a page.
Versions 09 and later Visible New in version 09 Visible Visible	..Visible is used to: Find out whether an element is visible. Make an element visible or invisible.
Versions 26 and later VisibleWithAnimation New in version 26 VisibleWithAnimation VisibleWithAnimation	The VisibleWithAnimation property is used to make a control visible or invisible via the "Appear/Disappear" animation.
Versions 15 and later VisualEffect New in version 15 VisualEffect VisualEffect	The Property VisualEffect allows you to manage a visual effect on an Control or a group of Control s of a window.
Versions 09 and later Width New in version 09 Width Width	Width is used to find out and modify the width: of a control or block in a report. of a control (found in a window), window, column found in a table or column found in a list box (including listview). of a control (found in a page), column found in a table or column found in a list box. The control can be overlayable or not.
Versions 21 and later WinEditAllowed New in version 21 WinEditAllowed WinEditAllowed	The Property AuthorizedEditionWindow allows to know and modify the manipulations authorized on an control when the window goes into "UI modification by the end user" mode.
Versions 09 and later X New in version 09 X X	X is used to: Find out the X coordinate of a control, of a Table control column or of a window (position on X axis). Modify the X-coordinate of a control or window (position on X-axis).
Versions 09 and later XInitial New in version 09 XInitial XInitial	XInitial is used to: Find out the X coordinate: of a control (position on X axis) when opening the window or the page. of a window (position on X axis) when opening the window. Modify the X coordinate of a control anchored "to right" (position on X axis) when opening the window. Find out the X coordinate of a control in relation to its block (position in millimeters on X axis) when opening the report.
Versions 09 and later Y New in version 09 Y Y	The Property Y makes it possible to: Find out the Y coordinate of a control or window (position on Y axis). Modify the Y coordinate of a control or window.
Versions 09 and later YInitial New in version 09 YInitial YInitial	The Property YInitial allows to: Find out the Y coordinate: of a control (position on Y axis) when opening the window or the page. of a window (position on Y axis) when opening the window. Modify the Y coordinate of a control anchored "to bottom" (position on the vertical axis) when opening the window. Find out the Y coordinate of a control in relation to its block (position in millimeters on the vertical axis) when opening the report.
Versions 12 and later Zoom New in version 12 Zoom Zoom	The Property Zoom allows you to know or modify the zoom value used: in an Image control. in a Map control. in an Organization Chart control. in a Table, TreeView Table, Pivot Table, Spreadsheet or List Box control. in a Word Processing control. in a PDF Reader control. in a window.
Versions 09 and later ZOrder New in version 09 ZOrder ZOrder	The Property Altitude allows you to manage the altitude of an control.

Properties that can be used on a row, a column or a filter

The following properties are associated with the rows, columns or filters found in a Pivot Table control:


Versions 09 and later Caption New in version 09 Caption Caption	In a database, ..Caption is used to: Find out the caption associated with a file item. Find out the caption associated with a data file. Find out and modify the connection caption. In a report, ..Caption is used to: Find out the text displayed in a Static or Link control. Modify the text displayed in a Static or Link control. In a window or in a page, ..Caption is used to: Find out and modify the caption of a control in a window or in a page. Find out and modify the caption of a menu option. Find out and modify the title of a window or page. Find out the content of a site map path.
Versions 18 and later Cumulated New in version 18 Cumulated Cumulated	The Property Cumul makes it possible to know if the value of a column or an row of an Pivot Table control corresponds to a total (end of row or end of column total).
Versions 20 and later DisplayEvenIfNull New in version 20 DisplayEvenIfNull DisplayEvenIfNull	DisplayEvenIfNull is used to: Find out whether a row or a column in a Pivot Table control is displayed even if it contains no value. Configure a row or a column found in a Pivot Table control so that it is displayed (or not) even if it contains no value.
Versions 17 and later DisplayMask New in version 17 DisplayMask DisplayMask	The Property DisplayMask allows to: Find out the display mask. Modify the display mask. This display mask is displayed when the control is in read-only or when the control does not have focus.
Versions 18 and later DisplayOrphan New in version 18 DisplayOrphan DisplayOrphan	The DisplayOrphan property is used to: Find out whether a row or a column found in a Pivot Table control is displayed when it has no parent. Modify the display mode of a row or column in a Pivot Table control when it has no parent.
Versions 18 and later FilterProcedure New in version 18 FilterProcedure FilterProcedure	The Procedure Filter property allows to know and modify the Procedure to be called to filter on an row or column header during the calculation of a dynamic cross array.
Versions 09 and later MaxValue New in version 09 MaxValue MaxValue	MaxValue is used to: find out and modify the upper bound of a report based on a data file. find out the upper bound defined for the current filter. find out the maximum value of a chart series. find out and modify the maximum value for some types of controls.
Versions 09 and later MinValue New in version 09 MinValue MinValue	MinValue is used to: find out and modify the lower bound of a report based on a data file. find out the lower bound defined for the current filter. find out the minimum value of a chart series. find out and modify the minimum value for some types of controls.
Versions 09 and later Name New in version 09 Name Name	Name is used to find out the name of the font associated with a Font variable. the name of a control, report or report block. the name of a control, group of controls or window. the name of a control, group of controls or page.
Versions 19 and later Pane New in version 19 Pane Pane	The Property Volet makes it possible to: Find out the pane tabs associated with a control. Define the pane tabs associated with a control.
Versions 21 and later ParallaxRateHeight New in version 21 ParallaxRateHeight ParallaxRateHeight	..ParallaxRateHeight is used to find out and specify the speed at which a control is reduced when the scrollbar found in the window, the internal window or the page moves.
Versions 21 and later ParallaxRateY New in version 21 ParallaxRateY ParallaxRateY	The Property RateParallaxisY allows you to know and indicate how fast an control is moving when the scrollbar of the window, the internal window or the page is moving.
Versions 19 and later Process New in version 19 Process Process	The Process property is used to modify the processes to be executed by the events available on a control, window, page, report, etc.
Versions 09 and later Value New in version 09 Value Value	The Property Value allows to: Find out and modify the value of a report control. Find out and modify the value of a control or the title of a window. Find out the identifier of a stream. Find out and modify the value of a control or the title of a page.
Versions 21 and later WinEditAllowed New in version 21 WinEditAllowed WinEditAllowed	The Property AuthorizedEditionWindow allows to know and modify the manipulations authorized on an control when the window goes into "UI modification by the end user" mode.

Properties that can be used on a value displayed in a cell

The following properties are associated with the values displayed in a Pivot Table control:


Versions 12 and later AutomaticErase New in version 12 AutomaticErase AutomaticErase	The Property Automatic erase allows you to: find out whether an edit control is in "Automatic erase" mode. modify the "Automatic erase" characteristic of an edit control.
Versions 09 and later BackgroundColor New in version 09 BackgroundColor BackgroundColor	..BackgroundColor is used to manage the background color of a control, window, page or report block.
Versions 11 and later BrushStyle New in version 11 BrushStyle BrushStyle	The Property StyleBackground allows to know and modify the display style of the Background of the cells of tables and/or hierarchical tables..
Versions 09 and later Caption New in version 09 Caption Caption	In a database, ..Caption is used to: Find out the caption associated with a file item. Find out the caption associated with a data file. Find out and modify the connection caption. In a report, ..Caption is used to: Find out the text displayed in a Static or Link control. Modify the text displayed in a Static or Link control. In a window or in a page, ..Caption is used to: Find out and modify the caption of a control in a window or in a page. Find out and modify the caption of a menu option. Find out and modify the title of a window or page. Find out the content of a site map path.
Versions 09 and later Color New in version 09 Color Color	..Color is used to find out and modify the font color for: a font variable. a text displayed in a Static control or in a calculated control of a report. a text displayed in a window control. a text displayed in a page control.
Versions 18 and later Cumulated New in version 18 Cumulated Cumulated	The Property Cumul makes it possible to know if the value of a column or an row of an Pivot Table control corresponds to a total (end of row or end of column total).
Versions 09 and later DisplayCurrency New in version 09 DisplayCurrency DisplayCurrency	The Property CurrencyDisplay allows you to know and modify the currency used when displaying and/or entering in an Control of the "Currency + Euro" type.
Versions 09 and later DisplayedValue New in version 09 DisplayedValue DisplayedValue	DisplayedValue is used to find out the value currently displayed on the screen in a window control or in a page control.
Versions 17 and later DisplayMask New in version 17 DisplayMask DisplayMask	The Property DisplayMask allows to: Find out the display mask. Modify the display mask. This display mask is displayed when the control is in read-only or when the control does not have focus.
Versions 09 and later Ellipsis New in version 09 Ellipsis Ellipsis	..Ellipsis is used to find out and modify the management mode of ellipsis in: a window control (Static, edit control, List box, Button, Combo box or Static table column). a Static control in a report.
Versions 18 and later EmptyIfZero New in version 18 EmptyIfZero EmptyIfZero	The Property VideSiZero allows to: Find out the management mode of zero value in a control. Modify the management mode of zero value in a control
Versions 09 and later Font New in version 09 Font Font	Font is used to: Find out the identifier of the font used in a control found in a report, in a page or in a window. Modify the font used in a control found in a report, in a page or in a window.
Versions 09 and later FontBold New in version 09 FontBold FontBold	FontBold is used to: Find out whether a text is bold or not. Modify the weight of a text.
Versions 09 and later FontCharset New in version 09 FontCharset FontCharset	The Property PoliceAlphabet allows: Find out the character set used by the screen fonts of a control. Modify the character set used by the screen fonts of a control.
Versions 09 and later FontCondensed New in version 09 FontCondensed FontCondensed	The Property PoliceCondensed allows: Find out whether the characters in a text are condensed or not. Condense (or not) the characters in a text.
Versions 09 and later FontExtended New in version 09 FontExtended FontExtended	The Property PoliceExtended makes it possible to: Find out whether the characters in a text are extended or not. Extend (or not) the characters displayed in a text.
Versions 09 and later FontItalic New in version 09 FontItalic FontItalic	FontItalic is used to: Find out whether the italic attribute is assigned to a text. Modify the italic attribute of a text.
Versions 09 and later FontLarge New in version 09 FontLarge FontLarge	..FontLarge is used to: Find out whether the characters in a text are enlarged or not. Enlarge (or not) the characters in a text.
Versions 09 and later FontName New in version 09 FontName FontName	FontName is used to: Find out the font used in a control. Modify the font used in a control.
Versions 09 and later FontSize New in version 09 FontSize FontSize	FontSize is used to: Find out the size of the font used in a control. Modify the size of the font used in a control.
Versions 09 and later FontStrikeOut New in version 09 FontStrikeOut FontStrikeOut	The Property PoliceBarré allows to: Find out whether a text is struck out or not. Strike out (or not) the text displayed in a control.
Versions 09 and later FontUnderlined New in version 09 FontUnderlined FontUnderlined	..FontUnderlined is used to: Find out whether a text is underlined or not. Underline (or not) a text.
Versions 09 and later FullName New in version 09 FullName FullName	FullName is used to find out the full name: of a control. of a window. of a menu option. of a table column.
Versions 17 and later Grayed New in version 17 Grayed Grayed	..Grayed is used to: Find out whether a control (or a group of controls) is grayed or not. Gray or ungray a control or a group of controls.
Versions 09 and later Group New in version 09 Group Group	..Group is used to: find out whether the control belongs to a group of controls. If the control belongs to one or more groups, ..Group is used to identify these groups of controls. associate a control with a group of controls.
Versions 09 and later Height New in version 09 Height Height	The Property Height allows to know and modify the height: of a control or block in a report. of a control (in a window), window, row of a Table, List Box or ListView control, option of a Radio Button or Check Box control, break header or footer of a Table or Looper control. of a control (in a page), break header or footer in a Looper control. The control can be overlayable or not.
Versions 09 and later HelpNumber New in version 09 HelpNumber HelpNumber	The HelpNumber property is used to identify and modify the help number associated with a control.
Versions 09 and later HorizontalAlignment New in version 09 HorizontalAlignment HorizontalAlignment	..HorizontalAlignment is used to find out and modify the horizontal alignment of a control.
Versions 09 and later InitialHeight New in version 09 InitialHeight InitialHeight	The Property InitialHeight allows you to: Find out the creation height of a control or window. Modify the base height used to anchor the controls "in height". Find out the creation height of a block or control in a report.
Versions 09 and later InitialState New in version 09 InitialState InitialState	The Property StateInitial makes it possible to know the initial report of an Control.
Versions 09 and later InitialVisible New in version 09 InitialVisible InitialVisible	The Property VisibleInitial can be used to determine whether: a control was visible during the first display of the associated window or page. a window was visible during its first display.
Versions 09 and later InitialWidth New in version 09 InitialWidth InitialWidth	The Property InitialWidth makes it possible to: Find out the initial width of a control or window. Modify the base width used to anchor the controls in "width". Find out the initial width of a report control.
Versions 09 and later InputMask New in version 09 InputMask InputMask	The Property Mask allows to: find out the input mask. modify the input mask (among the available masks for the type).
Versions 09 and later InputType New in version 09 InputType InputType	The Property TypeSaisie makes it possible to know or modify the type of entry allowed by an Control: Duration, Date, Numeric, ...
Versions 10 and later InterpretAmpersand New in version 10 InterpretAmpersand InterpretAmpersand	The Property InterpreterAndCommercial makes it possible to know and modify the mode of interpretation of the '&' character in: the caption of a Static control. the elements of a List Box control. the elements of a Combo Box control. the values of a column in a Table control.
Versions 11 and later LeftIndent New in version 11 LeftIndent LeftIndent	..LeftIndent is used to find out and modify the available space on the left of text in: the columns of Table and TreeView Table controls (between the beginning of column and the beginning of text). the edit controls. the Combo Box and List Box controls. the Button controls. the Ribbon controls. the Tab controls. The Static controls.
Versions 09 and later MemoryCurrency New in version 09 MemoryCurrency MemoryCurrency	MemoryCurrency is used to find out and modify the currency used when a "Currency + Euro" control is handled by programming.
Versions 09 and later MemoryFormat New in version 09 MemoryFormat MemoryFormat	MemoryFormat is used to find out and modify the format of the value returned for: the Date or Time edit controls. the Date or Time table columns. the Calendar controls. the Static controls. the editable combo boxes. the table columns displayed by combo boxes.
Versions 09 and later MinWidth New in version 09 MinWidth MinWidth	..MinWidth is used to find out and modify the minimum width of a control or window.
Versions 09 and later MouseCursor New in version 09 MouseCursor MouseCursor	The Property MouseCursor allows you to know and modify the hover cursor defined for an control, a window or a page.
Versions 09 and later Name New in version 09 Name Name	Name is used to find out the name of the font associated with a Font variable. the name of a control, report or report block. the name of a control, group of controls or window. the name of a control, group of controls or page.
Versions 09 and later NoteTitle New in version 09 NoteTitle NoteTitle	The Property TitleNote allows to: Find out the title of the notes used in the program documentation of a control, window, page or report. Modify the title of the notes used in the program documentation of a control, window, page or report.
Versions 21 and later ParallaxRateHeight New in version 21 ParallaxRateHeight ParallaxRateHeight	..ParallaxRateHeight is used to find out and specify the speed at which a control is reduced when the scrollbar found in the window, the internal window or the page moves.
Versions 21 and later ParallaxRateY New in version 21 ParallaxRateY ParallaxRateY	The Property RateParallaxisY allows you to know and indicate how fast an control is moving when the scrollbar of the window, the internal window or the page is moving.
Versions 09 and later PopupMenu New in version 09 PopupMenu PopupMenu	PopupMenu is used to: Find out the custom popup menu associated with a control or window. Modify the popup menu associated with a control or window (associate another popup menu with the control or window). Customize the system menus of controls by adding options.
Versions 19 and later Process New in version 19 Process Process	The Process property is used to modify the processes to be executed by the events available on a control, window, page, report, etc.
Versions 09 and later Note New in version 09 Note Note	Note is used to: Find out the notes associated with a control, a window, a page or a report. Modify the notes associated with a control, a window a page or a report.
Versions 09 and later Selected New in version 09 Selected Selected	..Selected is used to find out whether a row is selected (in a List Box control, a ListView control or a Table control) and to select a row (in a List Box control, a ListView control or a Table control).
Versions 11 and later Size New in version 11 Size Size	The Property Size allows to know and modify the size of an element.
Versions 09 and later State New in version 09 State State	The Property Report makes it possible to know and modify the display report of an item.
Versions 15 and later TextDirection New in version 15 TextDirection TextDirection	The TextDirection property is used to determine and change the writing direction in a window, report or control (useful for languages such as Arabic or Hebrew).
Versions 09 and later ToolTipTitle New in version 09 ToolTipTitle ToolTipTitle	The Property Tooltip allows you to know and modify the text displayed in the tooltip associated with the title of a column of table. This tooltip is displayed when the title of table column is hovered by the mouse cursor.
Versions 09 and later Type New in version 09 Type Type	Type is used to find out: the type of element described by programming (file or item description) or not (file or item defined in the data model editor, view or query). the type of object. the type of value stored in a variant.
Versions 12 and later Unicode New in version 12 Unicode Unicode	Unicode is used to: Find out whether the value of a control is a Unicode string. Specify whether the value of a control is a Unicode string.
Versions 09 and later Value New in version 09 Value Value	The Property Value allows to: Find out and modify the value of a report control. Find out and modify the value of a control or the title of a window. Find out the identifier of a stream. Find out and modify the value of a control or the title of a page.
Versions 09 and later VerticalAlignment New in version 09 VerticalAlignment VerticalAlignment	The Property CadrageVertical makes it possible to know and modify the vertical framing of an control.
Versions 09 and later Visible New in version 09 Visible Visible	..Visible is used to: Find out whether an element is visible. Make an element visible or invisible.
Versions 09 and later Width New in version 09 Width Width	Width is used to find out and modify the width: of a control or block in a report. of a control (found in a window), window, column found in a table or column found in a list box (including listview). of a control (found in a page), column found in a table or column found in a list box. The control can be overlayable or not.
Versions 21 and later WinEditAllowed New in version 21 WinEditAllowed WinEditAllowed	The Property AuthorizedEditionWindow allows to know and modify the manipulations authorized on an control when the window goes into "UI modification by the end user" mode.

Versions 21 and later

Properties available in a report

Properties that can be used on the pivot table

The following properties are associated with the Pivot Table controls:


Versions 11 and later Collapsed New in version 11 Collapsed Collapsed	The Property Wound makes it possible 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 Drawer control, a Ribbon control, a Navigation Bar control. a Pivot Table control in a report.
Versions 09 and later Height New in version 09 Height Height	The Property Height allows to know and modify the height: of a control or block in a report. of a control (in a window), window, row of a Table, List Box or ListView control, option of a Radio Button or Check Box control, break header or footer of a Table or Looper control. of a control (in a page), break header or footer in a Looper control. The control can be overlayable or not.
Versions 09 and later NoteTitle New in version 09 NoteTitle NoteTitle	The Property TitleNote allows to: Find out the title of the notes used in the program documentation of a control, window, page or report. Modify the title of the notes used in the program documentation of a control, window, page or report.
Versions 09 and later Plane New in version 09 Plane Plane	Plane is used to: Find out: the active plane of a window (or report) or the plane to which a control belongs. the active plane of a WEBDEV element. Modify: the active plane of a window (or report) or associate a control with another plane. the active plane of a WEBDEV element.
Versions 09 and later Note New in version 09 Note Note	Note is used to: Find out the notes associated with a control, a window, a page or a report. Modify the notes associated with a control, a window a page or a report.
Versions 09 and later Value New in version 09 Value Value	The Property Value allows to: Find out and modify the value of a report control. Find out and modify the value of a control or the title of a window. Find out the identifier of a stream. Find out and modify the value of a control or the title of a page.
Versions 09 and later Visible New in version 09 Visible Visible	..Visible is used to: Find out whether an element is visible. Make an element visible or invisible.

Properties that can be used on a value displayed in a cell

The following properties are associated with the values displayed in a Pivot Table control:


Versions 09 and later BackgroundColor New in version 09 BackgroundColor BackgroundColor	..BackgroundColor is used to manage the background color of a control, window, page or report block.
Versions 09 and later Color New in version 09 Color Color	..Color is used to find out and modify the font color for: a font variable. a text displayed in a Static control or in a calculated control of a report. a text displayed in a window control. a text displayed in a page control.
Versions 09 and later Font New in version 09 Font Font	Font is used to: Find out the identifier of the font used in a control found in a report, in a page or in a window. Modify the font used in a control found in a report, in a page or in a window.
Versions 09 and later Value New in version 09 Value Value	The Property Value allows to: Find out and modify the value of a report control. Find out and modify the value of a control or the title of a window. Find out the identifier of a stream. Find out and modify the value of a control or the title of a page.
Versions 09 and later Visible New in version 09 Visible Visible	..Visible is used to: Find out whether an element is visible. Make an element visible or invisible.

New in version 21

Properties available in a report

Properties that can be used on the pivot table

The following properties are associated with the Pivot Table controls:


Versions 11 and later Collapsed New in version 11 Collapsed Collapsed	The Property Wound makes it possible 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 Drawer control, a Ribbon control, a Navigation Bar control. a Pivot Table control in a report.
Versions 09 and later Height New in version 09 Height Height	The Property Height allows to know and modify the height: of a control or block in a report. of a control (in a window), window, row of a Table, List Box or ListView control, option of a Radio Button or Check Box control, break header or footer of a Table or Looper control. of a control (in a page), break header or footer in a Looper control. The control can be overlayable or not.
Versions 09 and later NoteTitle New in version 09 NoteTitle NoteTitle	The Property TitleNote allows to: Find out the title of the notes used in the program documentation of a control, window, page or report. Modify the title of the notes used in the program documentation of a control, window, page or report.
Versions 09 and later Plane New in version 09 Plane Plane	Plane is used to: Find out: the active plane of a window (or report) or the plane to which a control belongs. the active plane of a WEBDEV element. Modify: the active plane of a window (or report) or associate a control with another plane. the active plane of a WEBDEV element.
Versions 09 and later Note New in version 09 Note Note	Note is used to: Find out the notes associated with a control, a window, a page or a report. Modify the notes associated with a control, a window a page or a report.
Versions 09 and later Value New in version 09 Value Value	The Property Value allows to: Find out and modify the value of a report control. Find out and modify the value of a control or the title of a window. Find out the identifier of a stream. Find out and modify the value of a control or the title of a page.
Versions 09 and later Visible New in version 09 Visible Visible	..Visible is used to: Find out whether an element is visible. Make an element visible or invisible.

Properties that can be used on a value displayed in a cell

The following properties are associated with the values displayed in a Pivot Table control:


Versions 09 and later BackgroundColor New in version 09 BackgroundColor BackgroundColor	..BackgroundColor is used to manage the background color of a control, window, page or report block.
Versions 09 and later Color New in version 09 Color Color	..Color is used to find out and modify the font color for: a font variable. a text displayed in a Static control or in a calculated control of a report. a text displayed in a window control. a text displayed in a page control.
Versions 09 and later Font New in version 09 Font Font	Font is used to: Find out the identifier of the font used in a control found in a report, in a page or in a window. Modify the font used in a control found in a report, in a page or in a window.
Versions 09 and later Value New in version 09 Value Value	The Property Value allows to: Find out and modify the value of a report control. Find out and modify the value of a control or the title of a window. Find out the identifier of a stream. Find out and modify the value of a control or the title of a page.
Versions 09 and later Visible New in version 09 Visible Visible	..Visible is used to: Find out whether an element is visible. Make an element visible or invisible.

Properties available in a report

Properties that can be used on the pivot table

The following properties are associated with the Pivot Table controls:


Versions 11 and later Collapsed New in version 11 Collapsed Collapsed	The Property Wound makes it possible 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 Drawer control, a Ribbon control, a Navigation Bar control. a Pivot Table control in a report.
Versions 09 and later Height New in version 09 Height Height	The Property Height allows to know and modify the height: of a control or block in a report. of a control (in a window), window, row of a Table, List Box or ListView control, option of a Radio Button or Check Box control, break header or footer of a Table or Looper control. of a control (in a page), break header or footer in a Looper control. The control can be overlayable or not.
Versions 09 and later NoteTitle New in version 09 NoteTitle NoteTitle	The Property TitleNote allows to: Find out the title of the notes used in the program documentation of a control, window, page or report. Modify the title of the notes used in the program documentation of a control, window, page or report.
Versions 09 and later Plane New in version 09 Plane Plane	Plane is used to: Find out: the active plane of a window (or report) or the plane to which a control belongs. the active plane of a WEBDEV element. Modify: the active plane of a window (or report) or associate a control with another plane. the active plane of a WEBDEV element.
Versions 09 and later Note New in version 09 Note Note	Note is used to: Find out the notes associated with a control, a window, a page or a report. Modify the notes associated with a control, a window a page or a report.
Versions 09 and later Value New in version 09 Value Value	The Property Value allows to: Find out and modify the value of a report control. Find out and modify the value of a control or the title of a window. Find out the identifier of a stream. Find out and modify the value of a control or the title of a page.
Versions 09 and later Visible New in version 09 Visible Visible	..Visible is used to: Find out whether an element is visible. Make an element visible or invisible.

Properties that can be used on a value displayed in a cell

The following properties are associated with the values displayed in a Pivot Table control:


Versions 09 and later BackgroundColor New in version 09 BackgroundColor BackgroundColor	..BackgroundColor is used to manage the background color of a control, window, page or report block.
Versions 09 and later Color New in version 09 Color Color	..Color is used to find out and modify the font color for: a font variable. a text displayed in a Static control or in a calculated control of a report. a text displayed in a window control. a text displayed in a page control.
Versions 09 and later Font New in version 09 Font Font	Font is used to: Find out the identifier of the font used in a control found in a report, in a page or in a window. Modify the font used in a control found in a report, in a page or in a window.
Versions 09 and later Value New in version 09 Value Value	The Property Value allows to: Find out and modify the value of a report control. Find out and modify the value of a control or the title of a window. Find out the identifier of a stream. Find out and modify the value of a control or the title of a page.
Versions 09 and later Visible New in version 09 Visible Visible	..Visible is used to: Find out whether an element is visible. Make an element visible or invisible.