Tera Ltd. :: Software development [russian version]
[home] [about company] [products] [buy] [download] [feedback]
TERA / PRODUCTS / TERA XL REPORT / POSSIBILITIES
tera

about company

products

Tera XL Report

version history

possibilities

download

download

feedback

possibilities

Property Flags

Description

Handle of functionalities of the program. It is recommended to install the given property before call of a method CreateReport. The transmission of several flags simultaneously is possible, using the sign "+".

Syntax

class.Flags As trxlrepFlags

Title Description
trxlrepFlagNamesInFirstRow (by default) Names of fields are in the first rows of the arrays DataArray and NoTableDataArray.
trxlrepFlagNamesInLastRow The names of fields are in last row of the arrays DataArray and NoTableDataArray.
trxlrepFlagNamesInFirstColumn The names of fields are in first column of the arrays DataArray and NoTableDataArray.
trxlrepFlagNamesInLastColumn The names of fields are in last column of the arrays DataArray and NoTableDataArray.
trxlrepFlagViewNotMinimizedOnStart To not minimize the window MS Excel in execution time of the method CreateReport.
trxlrepFlagNewExcel By call of method CreateReport always creates a new copy of the application MS Excel.
trxlrepFlagPageBreaks To take into account horizontal forced ruptures of page on the template. Transmission of the given flag magnifies execution time of a method CreateReport.
trxlrepFlagReportSave To save the report after creation. Transmission of the given flag magnifies execution time of a method CreateReport. Not available in free version.
trxlrepFlagInsertRows Allow insert rows. Not available in free version.
trxlrepFlagRemoveDeepLevelIfEmpty To delete the most internal level in the report, if the given level does not contain the data. Not available in free version.
trxlrepFlagRemoveReportIfEmpty To delete the report if he does not contain the data. Not available in free version.
trxlrepFlagAutoFitDeepLevel To switch on auto selection of height of rows for the most internal level. Not available in free version.
trxlrepFlagAutoFitNotDeepLevels To switch on auto selection of height of rows for all levels, except for most internal. Not available in free version.
trxlrepFlagViewNotNormalOnComplete To not show the window MS Excel in normal size after execution of the method CreateReport.
trxlrepFlagTemplateScanOnce To not scan repeatedly a sheet of template. Not available in free version.
trxlrepFlagReportCellsFontSize1OnStart Set font size = 1 on report sheet before creation.
trxlrepFlagReportSaved May to close new report workbook without prompt to save. Not available in free version.
trxlrepFlagExcelQuitOnComplete Close MS Excel after creating of report.
trxlrepFlagReportProtect Protect report sheet after creation. Not available in free version.
trxlrepFlagPrint Print report sheet after creation. Not available in free version.
trxlrepFlagPrint2 Print report sheet (2 copies) after creation. Not available in free version.

Example


' Names of fields in the first column of data arrays, _
include pagebreaks in the report, save report after create

clsXLReport.Flags = trxlrepFlagNamesInFirstColumn + trxlrepFlagPageBreaks + trxlrepFlagReportSave
' Names of fields in the last row of data arrays
clsXLReport1.Flags = trxlrepFlagNamesInLastRow