PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
..VisibleInExportAndPrint is used to:
  • Find out whether a column of a Table or TreeView Table control is visible for export and printing.
  • Modify the visibility of a column in a Table or TreeView Table control for export and printing.
Remark: This property corresponds to the "Export and print" option in the "General" tab of the description window of a column in a Table or TreeView Table control.
Example
// [Print without details] button
TABLE_CUSTOMER.COL_Details..VisibleInExportAndPrint = False
iPrintReport(RPT_ReportOnCustomerTable)
TABLE_CUSTOMER.COL_Details..VisibleInExportAndPrint = Default
// Export to Excel:
// 1. The COL_Details column is exported
TABLE_MyTable.COL_Details..VisibleInExportAndPrint = False
TableToExcel(TABLE_MyTable, sFile, taNoTitle + taWithInvisibleColumns)
// 2. The COL_Details column is not exported
TABLE_MyTable.COL_Details..VisibleInExportAndPrint = False
TableToExcel(TABLE_MyTable, sFile, taNoTitle)
Syntax

Find out whether a column of a Table or TreeView Table control is visible for export and printing Hide the details

<Result> = <Column>..VisibleInExportAndPrint
<Result>: Integer constant
Management mode of column:
DefaultThe column is exported or printed only if it is visible at display.
FalseThe column can never be exported or printed.
Caution: When exporting with one of the export functions (TableToExcel, TableToText, TableToWord, TableToXML, TableToClipboard), if the taWithInvisibleColumns constant is used, the column will still be exported.
TrueThe column can be exported or printed (even if it is invisible at display).
<Column>: Control name
Name of column to use. This column can be a column found in a Table or TreeView Table control.

Modify the visibility of a column in a Table or TreeView Table control for export and printing Hide the details

<Column>..VisibleInExportAndPrint = <Visibility>
<Column>: Control name
Name of column to use. This column can be a column found in a Table or TreeView Table control.
<Visibility>: Integer constant
Management mode of column:
DefaultThe column is exported or printed only if it is visible at display.
FalseThe column can never be exported or printed.
Caution: When exporting with one of the export functions (TableToExcel, TableToText, TableToWord, TableToXML, TableToClipboard), if the taWithInvisibleColumns constant is used, the column will still be exported.
TrueThe column can be exported or printed (even if it is invisible at display).
Remarks
..VisibleInExportAndPrint is taken into account in the following cases:
  • print performed via the print AAF (Automatic Application Feature): print via the "Print" option from the popup menu of the Table control.
  • print performed via the export AAFs found in the popup menu of the Table control.
  • export via the export functions (TableToExcel, TableToText, TableToWord, TableToXML, TableToClipboard).
Minimum version required
  • Version 22
This page is also available for…
Comments
Click [Add] to post a comment