Report Definition Structure › Report Sections

Report Sections

Each section consists of a heading section and one or more data sections. Each data section is the result of executing a structured query language (SQL) query (or, occasionally, several queries). A data section can be presented as a chart, a table, or a statement.

Heading Sections

A heading section contains a <title> tag and can optionally contain <text> tags. As with report headings, these tags contain the name of the section and some explanatory text; however, headings section do not have a <subtitle> tag.

Data Sections

Each data section can be presented as a chart, table, or statement.

Charts

A chart has an optional <title> tag, a <query> or a <reference> tag, and an optional <footnote> tag.

More information:

Charts

Tables

A table contains an optional <title> tag that contains text, a <query> or a <reference> tag that defines the displayed data, and an optional <footnote> tag to pass on handy hints to the user. By default, the table is a copy of the result returned by executing the query. Alternatively, you can turn the table into a crosstab by including the summarise=crosstab attribute in the query.

You can use the optional datalimit="n" attribute in the <table> tag to limit the number of rows displayed. Any rows in excess of n are discarded. You should order the query to ensure that the most significant rows are at the start of the set of results.

Example: Table Section

<table>
   <title>Utilization of CHPID</title>
   <query>
      select pintervalname as Date, nfMinimum as Minimum,
      nfvalue as Average, nfMaximum as Maximum
      from <databasename/>.numericfact n, 
             <databasename/>.resource r, 
             <databasename/>.period p, 
             <databasename/>.attribute a
      where a.attribute = n.attribute
      and r.resource = n.resource
      and p.period = n.period
      and aname = 'ChpidUtilization'
      and p.pDate='2001-12-31'
      and p.plevel = 'Hourly'
      and rclass='IpOsaM'
      and r.raddress = '<parm name="OsaChpid"/>'
   </query>
   <footnote>See the “detail” report for more info.</footnote>
</table>

Statements

A statement contains a mixture of text and query results, and is presented as an HTML paragraph.

Example: Statement Section

<statement>
An interesting number in the database is <query> select nfValue from numericfact </query>. An interesting enumeratedFact is <query> select efValue from enumeratedFact </query>.
</statement>

The query can return as much data as you like, but only the first datum (that is, the item in the first column of the first row) is used.