PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
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
Properties associated with reports and controls
The following properties are associated with the reports and their controls:
ZOrderThe ZOrder property is used to manage the Z-order of an element.
AnchorThe Anchor property is used to set the anchors of a control in a window, page or report.
PageEndStickThe PageEndStick property is used to:
  • Find out whether the page footer must be stuck to the last block.
  • Modify the management mode of the Page Footer block.
MaxValueThe MaxValue property 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.
MinValueThe MinValue property 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.
HorizontalAlignmentThe HorizontalAlignment property is used to get and change the horizontal alignment of a control.
VerticalAlignmentThe VerticalAlignment property is used to get and change the vertical alignment of a 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.
CertificateThe Certificate property is used to get and change the certificate used by a Signature control.
KeepVisibleHierarchyThe KeepVisibleHierarchy property is used to:
  • Find out which elements of the TreeView table will be printed: printing the entire hierarchy or printing the hierarchy that is visible in the control.
  • Modify the print mode of the hierarchy: printing the entire hierarchy or printing the hierarchy that is visible in the 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.
BackgroundColorThe BackgroundColor property is used to set the background color of a control, window, page or block of a report.
StartDatePeriodDisplayedThe StartDatePeriodDisplayed property is used to get the start date of the time period displayed in a Scheduler or Organizer control of a report.
EndDatePeriodDisplayedThe EndDatePeriodDisplayed property is used to get the end date of the time period displayed in a Scheduler or Organizer control of a report.
DisplayCurrencyThe DisplayCurrency property is used to get and change the currency used when entering or displaying values in a "Currency + Euro" control.
MemoryCurrencyThe MemoryCurrency property is used to get and change the currency used when manipulating a "Currency + Euro" control programmatically.
RightToLeftThe RightToLeft property is used to get the writing direction on a control, column, window or report.
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.
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,
    • a Drawer control,
    • a Ribbon control,
    • a Navigation Bar control.
    • a Pivot Table control in a report.
HeaderVisibleThe HeaderVisible property is used to:
  • Find out whether the row and column headers are displayed in a Spreadsheet control.
  • Display (or not) the row and column headers in a Spreadsheet control.
HSpaceThe HSpace property is used to determine and modify the horizontal spacing between labels in a report. This spacing was defined when creating the Label report.
VSpaceThe VSpace property is used to get and change the vertical spacing between the labels in a report. This spacing was defined when creating the Label report.
StateThe State property is used to get and change the state of an element.
PrintedSheetWithin a report, the PrintedSheet property is used to get and change the sheet of a Spreadsheet control to be printed.
GranularityGridlinesThe GranularityGridlines property gets and changes the size of the grid that defines the gridlines in a Scheduler or Organizer control in a report.
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.
LabelHeightThe LabelHeight property is used to:
  • Find out the height of labels in a Label report.
  • Modify the height of labels in a Label report.
FutureHeightThe FutureHeight property is used to determine how high an auto-resizing control in a report will be after being enlarged.
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.
HeightInPixelThe HeightInPixel property is used to get the height in pixels of a control in a report.
HTMLThe HTML property is used to:
  • find out whether the current report is printed in HTML mode.
  • manage the HTML type of a Static control found in a report.
ImageImage is used to find out and modify the background image displayed in a control or in a block.
ExpandedImageThe ExpandedImage property is used to:
  • find out and modify the default image associated with an expanded row in a TreeView Table control.
  • find out and/or modify the default image associated with an expanded row in a TreeView control.
  • find out and modify the image associated with a specific expanded row in a TreeView Table control.
  • find out and modify the image associated with an expanded row in a treeview item of a "TreeView table" report.
CollapsedImageThe CollapsedImage property is used to:
  • find out and/or modify the default image associated with a collapsed row in a TreeView Table control.
  • find out and/or modify the default image associated with a collapsed row in a TreeView control.
  • find out and/or modify the image associated with a specific collapsed row in a TreeView Table control.
  • find out and modify the image in a collapsed row of a TreeView item in a "TreeView table" type report.
BackgroundImageThe BackgroundImage property is used to identify and modify the background color of an element: window, page, control or report.
BackgroundImagePrintedThe BackgroundImagePrinted is used to:
  • Determine if the background image of a report (form or other) should be printed.
  • Print (or not) the background image of a report.
PageByPagePrintThe PageByPagePrint property is used to:
  • Ask a report to be printed page by page. Each page of the report will be sent separately to the printer spooler.
  • Find out the print mode of the report (page by page or all at once).
InterfaceModifiableWithReportsAndQueriesThe InterfaceModifiableWitReportsAndQueries property is used to determine if the interface of a report can be modified in Reports & Queries.
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.
LabelWidthThe LabelWidth property is used to:
  • Find out the width of labels in a "Label" report.
  • Modify the width of labels in a "Label" report.
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.
WidthInPixelThe WidthInPixel property is used to get the width in pixels of a control in a report.
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.
CaptionPeriodHeaderThe CaptionPeriodHeader property is used to get and change the caption of the time period displayed in the header of a Scheduler or Agenda control in a report.
BottomMarginThe BottomMargin property is used to:
  • Find out the bottom margin of a report.
  • Modify the bottom margin of a report.
RightMarginThe RightMargin property is used to:
  • Find out the right margin of a report.
  • Modify the right margin of a report.
LeftMarginThe LeftMargin property is used to:
  • Find out the left margin of a report.
  • Modify the left margin of a report.
TopMarginThe TopMargin property is used to:
  • Find out the top margin of a report.
  • Modify the top margin of a report.
InputMaskThe InputMask property is used to:
  • find out the input mask.
  • modify the input mask (among the available masks for the type).
AdjustmentModeThe AdjustmentMode property determines and changes how a Spreadsheet control is adjusted in a report.
MsgSortSelThe MsgSortSel property is used to:
  • Find out the wait message displayed when sorting and selecting the report records.
  • Modify the wait message displayed when sorting and selecting the report records.
MultilineIn a window or page, the Multiline property is used to:
  • find out and modify the "Multiline" option of an Edit control.
  • find out and modify the "Multiline" option of a column in a Table control.
In a report, the Multiline property is used to determine and change the "Multiline" option of a control.
NbColumnThe NbColumn property is used to get the number of columns in a report.
NbCopyThe NbCopy property is used to determine and change the number of report copies to print.
NbPrintedRecThe NbPrintedRec property is used to determine the number of records already printed.
NbRecReadNbRecRead is used to find out the number of records read: selected both by the source of the report AND by the filter code (if it exists).
TotalNbRecThe TotalNbRec property is used to:
  • Get the number of records to be printed.
  • Change the number of records to be printed.
NbLabelThe NbLabel property is used to:
  • Find out the number of labels printed across the page width.
  • Modify the number of labels printed across the page width.
NbLabelCopyThe NbLabelCopy property is used to:
  • Get the number of copies of identical labels.
  • Change the number of copies of identical labels.
NbDayDisplayedThe NbDayDisplayed property is used to:
  • get and change the number of days displayed in an Organizer or Scheduler control.
  • get the number of days displayed in a Gantt Chart control in a report.
New in version 27
BlurLevel
The BlurLevel property gets and sets the percentage of blur applied to a control in a report.
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.
InternalReportNameThe InternalReportName property is used to:
SourceNameThe SourceName property is used to:
  • Get the name of the report data source.
  • Change the report data source.
ViewNameThe ViewName property is used to:
  • find out the name of the HFSQL view, data source of a report
  • modify the name of the HFSQL view, data source of a report.
MemZoneNameThe MemZoneName property is used to:
  • find out the name of the memory area used as data source for a report.
  • modify the name of the memory area used as data source for 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.
PageNumberThe PageNumber property is used to:
  • get and change the number of the page displayed in an Image control ("multi-page" image files)
  • get and change the page number of a PDF file displayed in an image control of a window
  • get and change the page number of a PDF file displayed in the background of a report.
LabelNumberToStartThe LabelNumberToStart property is used to:
  • Find out the number of the label on the label sheet from which the print will be performed.
  • Modify the number of the label from which the print will be performed on the label sheet.
New in version 27
Hidden
The Hidden is used to:
  • Determine if a control in a report is hidden.
  • Redact or blur a control in a report.
ODBCSQLCodeODBCSQLCode is used to:
  • Find out the SQL code of the "query performed on a connection" (data source of report).
  • Modify the SQL code of the "query performed on a connection" (data source of report).
ODBCPasswordThe ODBCPassword property is used to:
  • Identify the password used to connect to a database via an ODBC driver or a Native Connector.
  • Specify the password used to connect to a database via an ODBC driver or a Native Connector.
ODBCDatabaseNameODBCDatabaseName is used to:
  • Find out the name of the database used when printing a report based on a "query performed on a connection".
  • Specify the name of the database used when printing a report based on a "query performed on a connection".
ODBCConnectionNameThe ODBCConnectionName property is used to:
  • Identify the name of the ODBC connection used when printing a report based on a "query performed on a connection".
  • Specify the name of the ODBC connection used when printing a report based on a "query performed on a connection".
ODBCUserNameODBCUserName is used to:
  • Identify the username used to connect to a database via an ODBC driver or a Native Connector.
  • Specify the username used to connect to a database via an ODBC driver or a Native Connector.
OptionThe Option property is used to configure how a Bar Code control is displayed.
PlanePlane 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.
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.
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.
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.
FontCondensedThe FontCondensed property is used to:
  • Determine if characters in a text are condensed.
  • Condense (or not) the characters in a text.
FontAppointmentContentThe FontAppointmentContent property is used to:
  • Find out the characteristics of the font used for the content of appointments in the Scheduler and Organizer reports.
  • Modify the characteristics of the font used for the content of appointments in the Scheduler and Organizer reports.
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.
FontBoldFontBold is used to:
  • Determine if the text is bold.
  • Change the weight of the text.
FontItalicFontItalic is used to:
  • Determine if the text is italicized.
  • Apply or remove italic formatting from the text.
FontLargeFontLarge is used to:
  • Find out whether the characters in a text are enlarged or not.
  • Enlarge (or not) the characters in a text.
FontNameThe FontName property is used to:
  • Identify the font used in a control.
  • Change the font used in a control.
FontUnderlinedFontUnderlined is used to:
  • Find out whether a text is underlined or not.
  • Underline (or not) a text.
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.
FontAppointmentTitleThe FontAppointmentTitle property is used to:
  • Find out the characteristics of the font used for the title of appointments in the Scheduler and Organizer reports.
  • Modify the characteristics of the font used for the title of appointments in the Scheduler and Organizer reports.
HierarchicalDepthThe HierarchicalDepth property is used to:
  • Find out the depth of a hierarchical control in a report.
  • Modify the depth of a hierarchical control in a report (only if the report uses a data source through programming).
GridlinesVisibleThe GridlinesVisible property is used to:
  • Determine whether or not gridlines are visible in a control.
  • Show or hide gridlines in a control.
RTFWithImagesAndTablesThe RTFWithImagesAndTables property is used to manage images and tables in RTF Static controls in a report.
DisplayedItemThe DisplayedItem property is used to:
  • Find out the item or the variable displayed by the control.
  • Modify the item or the variable displayed by the control.
BrowsedItemThe BrowsedItem property is used to:
  • Get the item used to automatically loop through Table, Looper, List Box, ListView and Combo Box controls, supercontrols and reports based on data files.
  • Change the item used to automatically loop through Table, Looper, List Box, ListView and Combo Box controls, supercontrols and reports based on data files. Then, the iteration is reinitialized.
SelectionOnlyThe SelectionOnly property is used to:
  • Find out which elements of the Table or TreeView Table control will be printed: print all the records or the selected records only.
  • Change the print mode of rows in the Table or TreeView Table control: print all records or the selected records only.
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).
SizeThe Size property is used to determine and change the size of an element.
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.
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.
AnchorRateHeightThe AnchorRateHeight property is used to:
  • Find out the vertical anchor rate of a control.
  • Modify the vertical anchor rate of a control.
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.
TitleThe Title property is used to:
  • Get the title of a Table control column, a Chart control, a window or a page
  • Change the title of a Table control column, a Chart control, a window or a page.
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.
AllModifiableWithReportsAndQueriesThe AllModifiableWithReportsAndQueries property is used to determine if a report can be modified in Reports & Queries.
ProcessThe Process property is used to modify the processes to be executed by the events available on a control, window, page, report, etc.
SignatureTypeThe SignatureType property is used to get and define the type of signature to be used in a Signature control.
URLThe URL property is used to:
  • Get the address associated with a control.
  • Change the address associated with a control.
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.
ReturnedValueThe ReturnedValue property is used to:
  • Get and change the value returned by a window, page or report.
  • Get and change the value returned by an option in a Radio Button control.
EmptyEmpty 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.
VisibleThe Visible property is used to:
  • Find out whether an element is visible.
  • Make an element visible or invisible.
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.
PrintAreaThe PrintArea property is used to get and change the print area of a Spreadsheet control in a report.
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment