ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Developing an application or website / Controls, windows and pages / Controls: Available types / Pivot Table control
  • 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
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Overview
A Pivot Table control can be handled in WLanguage:
  • in a window.
  • in a report.
Properties available in a window

Properties that can be used on the pivot table

The following properties are associated with Pivot Table controls:
New in version 2024
Accessibility
The Accessibility property gets and sets the accessibility properties of a control.
AnchorThe Anchor property sets the anchors of a control in a window, page or report.
AnchorRateBottomThe AnchorRateBottom property 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.
AnchorRateHeightThe AnchorRateHeight property is used to:
  • Find out the vertical anchor rate of a control.
  • Modify the vertical anchor rate of a control.
AnchorRateRightThe AnchorRateRight property is used to:
  • 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.
AnchorRateWidthThe AnchorRateWidth property is used 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.
AutoLineWrapThe AutoLineWrap property is used to:
  • determine if the automatic line wrap feature is enabled in a multiline Edit control, in a column of a Table or TreeView control or in a row header of a Pivot Table control.
  • set the line wrap mode in a multiline Edit control, in a column of a Table or TreeView control or in a row header of a Pivot Table control.
AutomaticTooltipThe AutomaticTooltip property is used enable or disable automatic tooltips on List Box, Table and TreeView Table controls.
BackgroundColorThe BackgroundColor property is used to set the background color of a control, window, page or block of a report.
BackgroundImageLineThe BackgroundImageLine property is used to get and change the background image of each row:
  • of a Table control,
  • of a TreeView Table control,
  • of a Looper control.
BorderThe Border property is used to get and change the characteristics of the borders:
  • for a report control or block.
  • for a window control.
  • for a cell of a Table control.
BrowsedFileThe BrowsedFile property gets and sets the data source used to display records in controls based on a data file.
New in version 2024
CalculationInProgress
The CalculationInProgress property allows you to determine whether the data of a Pivot Table control is being calculated (synchronously or asynchronously).
CaptionIn a database, the Caption property 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, the Caption property 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 page, the Caption property is also 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 Breadcrumb control.
ColorThe Color property is used to get or change 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.
ContextMenuThe ContextMenu property is used to:
  • Get the custom context menu of a control, window or page.
  • Change the custom context menu of a control, window or page (or associate another context menu).
  • WINDEVWINDEV Mobile Customize the system menus of the controls by adding options.
CountThe Count property returns the number of elements in a given set.
DisplayEnabledThe DisplayEnabled property is used to:
  • determine whether or not a control or window is refreshed. If the control is displayed, its content is refreshed regularly.
  • refresh a control or window.
DndSourceThe DndSource property is used to determine and change a control's drag-and-drop behavior.
DndTargetThe DndTarget property determines and changes how a control behaves in a drag-and-drop operation.
DoubleClickThe DoubleClick property is used to get and change the name of the Button control that will be executed when a control is double-clicked.
EmptyThe Empty property is used to determine if:
  • 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.
ExtraThe Extra property is used to:
  • Get additional information about a control, window, or page.
  • Edit additional information of a control, window or page.
New in version 2024
FlexAlignSelf
The FlexAlignSelf property gets and sets the alignment of an item along the cross axis of a Flexbox control (corresponding CSS property: "align-self").
New in version 2024
FlexGrow
The FlexGrow property gets and sets the grow factor of an item in a line of a Flexbox control.
New in version 2024
FlexShrink
The FlexShrink property gets and sets the shrink factor of an item in a line of a Flexbox control.
FocusOnClickThe FocusOnClick property is used to:
  • Determine if a control gains focus when clicked.
  • Allow or prevent a control from gaining focus when clicked.
FontCharsetThe FontCharset property is used to:
  • 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.
FullNameThe FullName property is used to find out the full name:
  • of a control.
  • of a window.
  • of a menu option.
  • of a table column.
GrayedThe Grayed property is used to:
  • Determine if a control (or a group of controls) is grayed out.
  • Gray out or ungray a control, a group of controls or a window.
GroupThe Group property is used to:
  • find out whether the control belongs to a group of controls. If the control belongs to one or more groups, the Group property can be used to identify these groups of controls.
  • associate a control with a group of controls.
HeightThe Height property is used to get and change 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 Table or Looper control. The control can be overlayable or not.
  • of a break cell in a Table or Looper control.
HelpNumberThe HelpNumber property is used to identify and modify the help number associated with a control.
HideWhileScrollingThe HideWhileScrolling property is used to:
  • Determine if the pinned control is hidden while scrolling,
  • Show or hide the pinned control while scrolling.
InitialHeightThe InitialHeight property is used 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.
InitialStateThe InitialState property gets the initial state of a control.
InitialVisibleThe InitialVisible property is used to determine if:
  • a control was visible during the first display of the associated window or page.
  • a window was visible during its first display.
InitialWidthThe InitialWidth property is used 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.
LeftIndentThe LeftIndent property is used to get and change the space to the left of the text in a control.
LineHeightThe LineHeight property is used to get and change the height of the rows:
  • 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.
MarkdownThe Markdown property is used to enable or disable Markdown formatting in the controls of a window or a report.
MaxHeightThe MaxHeight property is used to get and change the maximum height of a control or window.
MaxWidthThe MaxWidth property is used to get and change the maximum width of a control or window.
MessageThe Message property is used 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).
MinHeightThe MinHeight property is used to get and change the minimum height of a control or window.
MinWidthThe MinWidth property is used to get and change the minimum width of a control or window.
MouseCursorThe MouseCursor property is used to identify and change the hover cursor defined for a control, window or page.
MultiselectionThe Multiselection property gets and sets the selection mode:
  • in a Table and TreeView Table control.
  • in a Pivot Table control.
  • in a List Box and ListView control.
  • in a Looper control.
  • in a Calendar control.
  • of files in an Upload control.
NameThe Name property is used to get:
  • 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.
NewLineThe NewLine property is used to determine:
  • in a Table control, whether the current row was created with TableAddXXX or TableInsertXXX.
  • in a Looper control, whether the current row was created with 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.
NoteThe Note property 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.
NoteTitleThe NoteTitle property is used to:
  • Get the title of the notes used in the technical documentation of a control, window, page or report.
  • Change the title of the notes used in the technical documentation of a control, window, page or report.
NumberColumnThe NumberColumn property is used to:
  • Get the number of columns in Table, Check Box, Radio Button controls, etc..
  • Set the number of columns in a multi-column List Box control.
OpacityThe Opacity property is used to get and define the opacity percentage for a window, or for controls in a window or page.
PaneThe Pane property is used to:
  • Find out the pane tabs associated with a control.
  • Define the pane tabs associated with a control.
ParallaxRateHeightThe ParallaxRateHeight property is used to determine and specify how fast a control is reduced when the scrollbar in the window, internal window or page moves.
ParallaxRateYThe ParallaxRateY property is used to determine and specify how fast a control moves when the scrollbar in the window, internal window or page moves.
PinnedThe Pinned property is used to:
  • Pin a control: the position of the pinned control will be relative to the visible area of its container and not to the content area.
  • Determine if a control is pinned.
PlaneThe Plane property is used to:
  • Get:
    • the active plane of a window (or report) or the plane to which a control belongs.
    • the active plane of a WEBDEV element.
  • Change:
    • the active plane of a window (or report) or associate a control with another plane.
    • the active plane of a WEBDEV element.
ProcessThe Process property is used to modify the processes to be executed by the events available on a control, window, page, report, etc.
ProgressBarThe ProgressBar property is used to identify and change the Progress Bar control used when calculating a Pivot Table control (PVTCalculateAll and PVTCalculateUpdate functions).
RightClickThe RightClick property gets and sets the name of the Button control that will be executed when an object is right-clicked.
RightToLeftThe RightToLeft property is used to get the writing direction on a control, column, window or report.
StateThe State property is used to get and change the state of an element.
StyleThe Style property is used to retrieve and assign the entire style of a control (including the overrides).
TABOrderThe TABOrder property gets and sets the position of a control in the tab order of a window.
TextDirectionThe 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).
ToolTipThe ToolTip property is used to get and change the text displayed in the tooltip associated with a window or page control.
TotalsEnabledThe TotalsEnabled property enables you to:
  • Identify the calculation method used for columns in a Table or TreeView Table control (automatic or custom),
  • Temporarily forbid or force column calculations (automatic or custom) in a Table or TreeView Table control.
TypeThe Type property is used to get:
  • the type of element (data file or item) defined programmatically or in the data model editor, view or query.
  • the type of object.
  • the type of data held in a Variant.
ValueThe Value property is used 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.
VisibleThe Visible property is used to:
  • Find out whether an element is visible.
  • Make an element visible or invisible.
VisibleWithAnimationThe VisibleWithAnimation property is used to make a control visible or invisible via the "Appear/Disappear" animation.
VisualEffectThe VisualEffect property allows you to apply a visual effect on a control or group of controls in a window.
WidthThe Width property gets and changes 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.
WinEditAllowedThe WinEditAllowed property is used to determine and configure the actions allowed on a control when the window switches to "Allow end users to modify the UI" mode.
XThe X property is used to:
  • Get the X-coordinate of a control, Table control column or window (position on the X-axis).
  • Get the X-coordinate of a control or window (position on the X-axis).
XInitialThe XInitial property is used to:
  • Get the X-coordinate:
    • of a control (position on the X-axis) when opening the window or the page.
    • of a window (position on X-axis) when opening the window.
  • Change the X-coordinate of a control anchored "to the right" (position on the X-axis) when opening the window.
  • Get the X-coordinate of a control in relation to its block (position in millimeters on the X-axis) when opening the report.
YThe Y property is used to:
  • Find out the Y-coordinate of a control or window (position on Y-axis).
  • Modify the Y-coordinate of a control or window.
YInitialThe YInitial property is used 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.
ZoomThe Zoom property gets or sets the zoom value:
  • 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 Camera control.
  • in a Diagram Editor control;
  • in a window.
ZOrderThe ZOrder property defines the Z-order of an element.

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:
CaptionIn a database, the Caption property 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, the Caption property 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 page, the Caption property is also 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 Breadcrumb control.
CumulatedThe Cumulated property is used to determine if the value of a column or row in Pivot Table control corresponds to a total (total at the end of a row or column).
DisplayEvenIfNullThe DisplayEvenIfNull property is used to:
  • Determine whether a row or column in a Pivot Table control is displayed even if it contains no value.
  • Show or hide a row or column in a Pivot Table control if it does not contain any values.
DisplayMaskThe DisplayMask property is used 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.
DisplayOrphanThe DisplayOrphan property is used to:
  • Determine whether a row or column in a Pivot Table control is displayed when it has no parent.
  • Change the display mode of a row or column in a Pivot Table control when it has no parent.
FilterProcedureThe FilterProcedure property allows you to get and modify the procedure used to apply a filter on a row or column header when calculating a Pivot Table control.
MarkdownThe Markdown property is used to enable or disable Markdown formatting in the controls of a window or a report.
MaxValueThe MaxValue property is used to:
  • get and set the top value of a report based on a data file.
  • get the maximum value of the current filter.
  • get the maximum value of a data series in a chart.
  • get and set the maximum value for some types of controls.
MinValueThe MinValue property is used to:
  • get and set the bottom value of a report based on a data file.
  • get the minimum value of the current filter.
  • get the minimum value of a data series in a chart.
  • get and set the minimum value for some types of controls.
NameThe Name property is used to get:
  • 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.
PaneThe Pane property is used to:
  • Find out the pane tabs associated with a control.
  • Define the pane tabs associated with a control.
ParallaxRateHeightThe ParallaxRateHeight property is used to determine and specify how fast a control is reduced when the scrollbar in the window, internal window or page moves.
ParallaxRateYThe ParallaxRateY property is used to determine and specify how fast a control moves when the scrollbar in the window, internal window or page moves.
ProcessThe Process property is used to modify the processes to be executed by the events available on a control, window, page, report, etc.
ValueThe Value property is used 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.
WinEditAllowedThe WinEditAllowed property is used to determine and configure the actions allowed on a control when the window switches to "Allow end users to modify the UI" 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:
New in version 2024
Accessibility
The Accessibility property gets and sets the accessibility properties of a control.
AutomaticEraseThe AutomaticErase property is used to:
  • find out whether an edit control is in "Automatic erase" mode.
  • modify the "Automatic erase" characteristic of an edit control.
BackgroundColorThe BackgroundColor property is used to set the background color of a control, window, page or block of a report.
BackgroundStyleThe BackgroundStyle property is used to get and modify the background style of cells in tables and/or TreeView Tables.
CaptionIn a database, the Caption property 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, the Caption property 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 page, the Caption property is also 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 Breadcrumb control.
ColorThe Color property is used to get or change 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.
ContextMenuThe ContextMenu property is used to:
  • Get the custom context menu of a control, window or page.
  • Change the custom context menu of a control, window or page (or associate another context menu).
  • WINDEVWINDEV Mobile Customize the system menus of the controls by adding options.
CumulatedThe Cumulated property is used to determine if the value of a column or row in Pivot Table control corresponds to a total (total at the end of a row or column).
DisplayCurrencyThe DisplayCurrency property gets and sets the currency used when entering or displaying values in a "Currency + Euro" control.
DisplayedValueThe DisplayedValue property returns the value currently displayed in the control of a window or page.
DisplayMaskThe DisplayMask property is used 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.
EllipsisThe Ellipsis property is used to determine and change the truncation mode with ellipses in:
  • a window control (Static, edit control, List box, Button, Combo box or Static table column).
  • a Static control in a report.
EmptyIfZeroThe EmptyIfZero property is used to:
  • Find out the management mode of zero value in a control.
  • Modify the management mode of zero value in a control
ExtraThe Extra property is used to:
  • Get additional information about a control, window, or page.
  • Edit additional information of a control, window or page.
FontThe Font property is used to
  • Get the identifier of the font used in a control in a report, page or window.
  • Change the font used in a control in a report, page or window.
FontBoldThe FontBold property is used to:
  • Determine if the text is bold.
  • Change the weight of the text.
FontCharsetThe FontCharset property is used to:
  • 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.
FontCondensedThe FontCondensed property is used to:
  • Determine if characters in a text are condensed.
  • Condense (or not) the characters in a text.
FontExtendedThe FontExtended property is used to:
  • Find out whether the spacing between characters in a text is increased.
  • Increase the spacing between characters in a text.
FontItalicThe FontItalic property is used to:
  • Determine if the text is italicized.
  • Apply or remove italic formatting from the text.
FontLargeThe FontLarge property is used to:
  • Determine if the text is expanded.
  • Expand the text.
FontNameThe FontName property is used to:
  • Identify the font used in a control.
  • Change the font used in a control.
FontSizeThe FontSize property is used to:
  • Identify the size of the font used in a control.
  • Change the size of the font used in a control.
FontStrikeOutThe FontStrikeOut property is used to:
  • Determine if the text displayed is struck through.
  • Apply strikethrough formatting (or not) the text displayed in a control.
FontUnderlinedThe FontUnderlined property is used to:
  • Determine if the text is underlined.
  • Underline (or not) a text.
FullNameThe FullName property is used to find out the full name:
  • of a control.
  • of a window.
  • of a menu option.
  • of a table column.
GrayedThe Grayed property is used to:
  • Determine if a control (or a group of controls) is grayed out.
  • Gray out or ungray a control, a group of controls or a window.
GroupThe Group property is used to:
  • find out whether the control belongs to a group of controls. If the control belongs to one or more groups, the Group property can be used to identify these groups of controls.
  • associate a control with a group of controls.
HeightThe Height property is used to get and change 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 Table or Looper control. The control can be overlayable or not.
  • of a break cell in a Table or Looper control.
HelpNumberThe HelpNumber property is used to identify and modify the help number associated with a control.
HorizontalAlignmentThe HorizontalAlignment property gets and changes the horizontal alignment of a control.
InitialHeightThe InitialHeight property is used 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.
InitialStateThe InitialState property gets the initial state of a control.
InitialVisibleThe InitialVisible property is used to determine if:
  • a control was visible during the first display of the associated window or page.
  • a window was visible during its first display.
InitialWidthThe InitialWidth property is used 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.
InputMaskThe InputMask property is used to:
  • get the input mask.
  • set the input mask (from the masks available for the type).
InputTypeThe InputType property is used to identify or change the type of input supported by a control: Duration, Date, Numeric, etc.
InterpretAmpersandThe InterpretAmpersand property is used to determine and change how the '&' character is interpreted 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.
LeftIndentThe LeftIndent property is used to get and change the space to the left of the text in a control.
MemoryCurrencyThe MemoryCurrency property gets and sets the currency used when manipulating a "Currency + Euro" control programmatically.
MemoryFormatThe MemoryFormat property is used to get and change the format of the value returned for:
  • Date or Time edit controls.
  • Date or Time table columns.
  • Calendar controls.
  • Static controls.
  • editable combo boxes.
  • table columns displayed by combo boxes.
MinWidthThe MinWidth property is used to get and change the minimum width of a control or window.
MouseCursorThe MouseCursor property is used to identify and change the hover cursor defined for a control, window or page.
NameThe Name property is used to get:
  • 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.
NoteThe Note property 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.
NoteTitleThe NoteTitle property is used to:
  • Get the title of the notes used in the technical documentation of a control, window, page or report.
  • Change the title of the notes used in the technical documentation of a control, window, page or report.
ParallaxRateHeightThe ParallaxRateHeight property is used to determine and specify how fast a control is reduced when the scrollbar in the window, internal window or page moves.
ParallaxRateYThe ParallaxRateY property is used to determine and specify how fast a control moves when the scrollbar in the window, internal window or page moves.
ProcessThe Process property is used to modify the processes to be executed by the events available on a control, window, page, report, etc.
SelectedThe Selected property is used to:
  • Select, or determine if a row is selected in a List, ListView or Table control.
  • Select, or determine if a column or cell is selected in a Table control with row or column selection.
  • Select, or determine if a WEBDEV menu option is selected.
SizeThe Size property is used to determine and change the size of an element.
StateThe State property is used to get and change the state of an element.
TextDirectionThe 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).
ToolTipTitleThe ToolTipTitle property gets and sets the text displayed in the tooltip associated with the column title of a Table control. This tooltip only appears when the Table control column title is hovered over.
TypeThe Type property is used to get:
  • the type of element (data file or item) defined programmatically or in the data model editor, view or query.
  • the type of object.
  • the type of data held in a Variant.
UnicodeThe Unicode property is used to:
  • Determine if the value of a control is a Unicode string.
  • Specify whether the value of a control is a Unicode string.
ValueThe Value property is used 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.
VerticalAlignmentThe VerticalAlignment property gets and changes the vertical alignment of a control.
VisibleThe Visible property is used to:
  • Find out whether an element is visible.
  • Make an element visible or invisible.
WidthThe Width property gets and changes 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.
WinEditAllowedThe WinEditAllowed property is used to determine and configure the actions allowed on a control when the window switches to "Allow end users to modify the UI" mode.
Properties available in a report

Properties that can be used on the pivot table

The following properties are associated with Pivot Table controls:
BlurLevelThe BlurLevel property gets and sets the percentage of blur applied to a control in a report.
CollapsedThe Collapsed property is used to:
  • get or define the state (collapsed or expanded) that will be used when rows are added to 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,
    • the break headers and footers of Table and Looper controls,
    • a Drawer control,
    • a Ribbon control,
    • a Navigation Bar control.
    • a Pivot Table control in a report.
HeightThe Height property is used to get and change 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 Table or Looper control. The control can be overlayable or not.
  • of a break cell in a Table or Looper control.
HiddenThe Hidden is used to:
  • Determine if a control in a report is hidden.
  • Redact or blur a control in a report.
NoteThe Note property 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.
NoteTitleThe NoteTitle property is used to:
  • Get the title of the notes used in the technical documentation of a control, window, page or report.
  • Change the title of the notes used in the technical documentation of a control, window, page or report.
PlaneThe Plane property is used to:
  • Get:
    • the active plane of a window (or report) or the plane to which a control belongs.
    • the active plane of a WEBDEV element.
  • Change:
    • the active plane of a window (or report) or associate a control with another plane.
    • the active plane of a WEBDEV element.
ValueThe Value property is used 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.
VisibleThe Visible property 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:
BackgroundColorThe BackgroundColor property is used to set the background color of a control, window, page or block of a report.
BlurLevelThe BlurLevel property gets and sets the percentage of blur applied to a control in a report.
ColorThe Color property is used to get or change 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.
FontThe Font property is used to
  • Get the identifier of the font used in a control in a report, page or window.
  • Change the font used in a control in a report, page or window.
HiddenThe Hidden is used to:
  • Determine if a control in a report is hidden.
  • Redact or blur a control in a report.
ValueThe Value property is used 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.
VisibleThe Visible property is used to:
  • Find out whether an element is visible.
  • Make an element visible or invisible.
Minimum version required
  • Version 18
Comments
Click [Add] to post a comment

Last update: 03/05/2024

Send a report | Local help