<< Click to Display Table of Contents >> Navigation:  Delphi HTML Report Library > Tables

Tables are displayed using special tag DATAPACKET.

Datapacket has following format:

<DATAPACKET>

<METADATA>

 <FIELDS>

  <FIELD>

   …

  </FIELDS>

<SQL>

 …

</SQL>

<SCRIPT>

...

<SCRIPT>

</METADATA>

<ROWDATA>

…

</ROWDATA>

</DATAPACKET>

 

All DATAPACKET nodes are optional. SQL and ROWDATA are mutually exclusive, only one should exist.

When processing SQL tag, query is executed and result converted to XML is substituted to a ROWDATA tag of DATAPACKET.

Example of simple DATAPACKET:

<DATAPACKET>

<METADATA>

 <FIELDS>

   <FIELD name="name"/>

   <FIELD name="color"/>

 </FIELDS>

</METADATA>

<ROWDATA>

 <R NAME="Dog" COLOR="brown"/>

 <R NAME="Bird" COLOR=”green"/>

</ROWDATA>

</DATAPACKET>

 

Result:

 

 

 

Example of DATAPACKET with SQL

 

<DATAPACKET>

<METADATA>

 <FIELDS>

  <FIELD name="CUSTNO"/>

  <FIELD name="ADDR1" />

  <FIELD name="COMPANY" />

  <FIELD name="CITY" />

  <FIELD name="STATE" />

  <FIELD name="PHONE" />

  <FIELD name="CONTACT" />

 </FIELDS>

 <SQL>

  select * from customer

 </SQL>

</METADATA>

</DATAPACKET>

 

Result: