Appendix D: Data types

Home Products Downloads Registered users Support Prices Order Primary Subscription

<< Previous

Table of contents

Next >>

Below follows the data types supported by Active XL Report

ADO

Data Type		Field type
xlrString		adGUID, adChar, adWChar, adVarChar, adVarWChar, adLongVarChar, adLongVarWChar, adBSTR
xlrInteger		adTinyInt, adSmallInt, adInteger, adBigInt, adUnsignedTinyInt, adUnsignedSmallInt, adUnsignedInt, adUnsignedBigInt
xlrFloat		adSingle, adDouble, adCurrency, adDecimal, adNumeric
xlrDateTime		adDate, adDBDate, adDBTime, adDBTimeStamp
xlrBoolean		adBoolean

DAO

Data Type		Field type
xlrString		dbGUID, dbByte, dbChar, dbMemo, dbText
xlrInteger		dbInteger, dbLong
xlrFloat		dbCurrency, dbSingle, dbDecimal, dbDouble, dbFloat, dbNumeric
xlrDateTime		dbDate, dbTime, dbTimeStamp
xlrBoolean		dbBoolean

RDO

Data Type		Field type
xlrString		rdTypeCHAR, rdTypeVARCHAR, rdTypeLONGVARCHAR, rdTypeWCHAR, rdTypeWVARCHAR, rdTypeWLONGVARCHAR, rdTypeGUID
xlrInteger		rdTypeINTEGER, rdTypeSMALLINT, rdTypeBIGINT, rdTypeTINYINT
xlrFloat		rdTypeNUMERIC, rdTypeDECIMAL, rdTypeDOUBLE, rdTypeFLOAT, rdTypeREAL
xlrDateTime		rdTypeDATE, rdTypeTIME, rdTypeTIMESTAMP
xlrBoolean		rdTypeBIT

Glossary

Arbitrary range		A range not suiting the definition of a table in a relational database or a list in Excel terminology. Consists of one or more rows with data and formulas (including field formulas) and an option row. The range doesn't have to have a header above it. Can contain merged cells.
Column option		An option residing in an option row and describing some actions for a range's column.
Dataset		Provides an abstraction for any kinds of data - a recordset (DAO or ADO), a resultset (RDO) or unbound data.
Datasource		A named object that acts as a conduit between a dataset and a report. Every dataset must be associated with a datasource in order for its data to be transferred to a report. You can also use datasources to link datasets in master-detail relationships.
Detail range		A range enclosed into another range and not containing enclosed ranges.
Field formula		A reference to a field of a dataset in a Microsoft Excel worksheet. Can be used in any Excel formula. Has the following format - DatasourceName_FieldName, where DatasourceName is the name of a datasource and FieldName is the name of a field of the dataset containing in the datasource. See Appendix C for learning about names in Microsoft Excel.
List range		A range suiting the definition of a table in a relational database or a list in Excel terminology. Consists of one row with data and formulas (including field formulas) plus obligatory option row and option column. The range must have a one-row header above it. Must not contain merged cells.
Master range		A range enclosed into another range and containing any number of enclosed ranges.
NoRange-datasource		A datasource not bound to a range - only the current record is transferred to a report.
Option		A string value recognized by Active XL Report and residing in an option cell. Several options in an option cell must be separated by semicolon.
Option cell		A cell in an option row or in an option column, as well as A1 and A2 cells of every worksheet in a template. Intended for specifying Active XL Report options. Can contain any other data.
Option column		The leftmost column of a range - can contain only range options and only in the bottom cell.
Option row		The bottom row of a range intended for specifying Active XL Report range and column options
Range		A rectangular set of cells having name, obligatory option column and option row. (It's Active XL Report terminology. A range is a set of cells in Excel terminology. Feel the difference.)
Range option		An option residing in the leftmost cell of an option row and describing some actions over a whole range that XL Report performs.
Range-datasource		A datasource bound to a range - all records are transferred to a report.
Report		A workbook generated by Active XL Report basing on a template.
Report option		An option describing actions over a whole report workbook. Such options must reside in A1 cell of any template worksheet(s).
Root range		A top-level master range.
Sheet option		An option describing actions over a whole report worksheet. Such options must reside in A2 cell of a given template worksheet.
Template		A workbook (xls-file) or Excel template (xlt-file) containing field formulas and/or Active XL Report ranges.