Database tags and components

THTMLReportProducer uses all of tags represented below for generating reports from dataset. These components represent additional HTML tags that are not included in HTML version 4.0 and they are an extended set for generating reports from Delphi applications.

THTMLTAG_DBD_DATASET
THTMLTAG_DBD_GRID
THTMLTAG_DBD_DATA
THTMLTAG_DBD_DATAFIELD
THTMLTAG_DBD_VARIABLE
THTMLTAG_DBD_DATAGROUP
THTMLTAG_DBD_PIVOT
THTMLTAG_DBD_DATAGROUPFOOTER
ADDITIONAL INFORMATION

THTMLTAG_DBD_DATASET


Component represents a DBD_DATASET tag. Component represents a DBD_DATASET tag. This tag is used for creating a link to data source such as TQuery or TTable. Use this tag when you use data stream from temporary dataset.

Properties

Examples
<DBD_DATASET NAME="SimpleList" DATABASE="DBDEMOS" TABLE="customer.db" INDEX="Company"> creates temporary TTable with DatabaseName=DBDEMOS, TableName=customer.db and IndexName=Company.
<DBD_DATASET NAME="SimpleList" DATABASE="DBDEMOS" QUERY="SELECT * FROM customer.db ORDER BY COMPANY"> creates temporary TQuery with DatabaseName=DBDEMOS and SQL.Text="SELECT * FROM customer.db ORDER BY COMPANY".

THTMLTAG_DBD_GRID


Represents a DBD_GRID tag. Use this tag for creating whole table from dataset.

Properties

Examples
<DBD_GRID COUNT="MAX" DATASET="_GridVendors" COLOR=yellow BGCOLOR=#E0E0E0> generates whole table from dataset with Name=GridVendors that is placed at a Form.

THTMLTAG_DBD_DATA


Represents a DBD_DATA tag. Creates data stream for generating report.

Properties

Examples
<DBD_GRID COUNT="MAX" DATASET="_GridVendors"> generates data stream from dataset with Name=GridVendors that placed at a Form.
<DBD_GRID COUNT="MAX" DATASET="_default"> generates data stream from dataset using THTMLReportProducer.DataSource as link to dataset.

THTMLTAG_DBD_DATAFIELD


Represents a DBD_DATAFIELD tag. Creates data stream for generating report.

Properties

Examples
<DBD_DATAFIELD DATASET="SimpleList" VALUE=_1 CONTENT=HEADER> generates HeaderName for Field[1]. It equals Fields[1].DisplayName
<DBD_DATAFIELD DATASET="SimpleList" VALUE=_Fax CONTENT=VALUE> generates HeaderName for Fields[1]. It equals Fields[1].DisplayName

THTMLTAG_DBD_VARIABLE


Represents a DBD_VARIABLE tag. Is used for generating auto increment fields and grouping values.

Properties

Examples
<DBD_VARIABLE DATASET="SimpleList" NAME=COUNTER VALUE=COUNT(_1)> creates Variable with Name=Counter and uses as AutoIncrement field
<DBD_VARIABLE DATASET="SimpleList" NAME=COUNTER VALUE=SHOW()> shows current value of Variable with Name=Counter

THTMLTAG_DBD_DATAGROUP


Represents a DBD_DATAGROUP tag. Is used for grouping data.

Properties

Examples
<DBD_DATAGROUP NAME=FIRSTLETTER DATASET="SimpleList" EXPR="COPY(_Company, 1, 1)>
groups the data by first letter of Company field.

THTMLTAG_DBD_PIVOT


Represents a DBD_PIVOT tag. Is used for creating of the crosstab reports.

Properties

Examples
<DBD_PIVOT DATASET="SimpleList" ALIGN=right HSPACE="%.2m" VSPACE="%.2m" COLOR=yellow BGCOLOR=#EFEFEF>
generates the crosstab report, that have total column and total row. Note: any dataset, which is used as data source, must have 3 fields and be grouped by two first fields.

THTMLTAG_DBD_DATAGROUPFOOTER


Represents a DBD_DATAGROUPFOOTER tag. Is used for showing of grouped data.

Properties

Examples
<DBD_DATAGROUPFOOTER NAME=ORDERGROUP DATASET="SimpleList" EXPR="_OrderNo">
groups the data by OrderNo field from SimpleList dataset.

ADDITIONAL INFORMATION


Names

When you use names for Dataset, you can choose next

When you use names for Variables and Data Fields, you can choose next

Functions


Simple functions

Grouping functions for Variables