varlena ere: Design Structure


Overview

Requirements

Examples

How It Works

Design Structure

Tags

Design a Report

Variables

Built-in Arguments

Debugging

Using CSV files

Tricks

Copyright

Reports Home

Design Structure

ere report templates are HTML/XML files that you create. These files consist of report header information, the html layout for your report and additional structure tags detailing repeating areas.

ere enables you to group your data in natural hierarchies. The hierarchy is not restricted to the header and footer banners like most report writers. Nested areas represent the data groups in ere. Information within an area may be before, beside or after more detailed information.

Below is a sketch or diagram of the table attribute report as from the Examples page. From the examples page you can see the exact layout of the report template.

The report has two sections, the report definition section and the report itself. Within the report itself, there are three repeating data areas one for each break level. The breaks have been defined on schema name, table name and attribute number.

A break occurs on a column when the value changes between rows. You will have sorted on the break columns in order to achieve the affect you want.

The red box represents the schema break area. The blue box represents the table name break area. The green box represents the column name break area.

The data from the data stream will look something like this:

	ere          report_report   1 r_name     ....
	ere          report_report   2 r_title    ....
	...          ....            . ....       ....
	ere          rr_appgroup     1 ag_name    ....
	...          ....            . ....       ....
	ere          rr_reports      1 r_name     ....
	ere          rr_reports      2 rt_type    ....
	...          ....            . ....       ....
	pg_catalog   pg_aggregate    1 aggfnoid   ....
	pg_catalog   pg_aggregate    2 aggtransfn ....
	...          ....            . ....       ....

Nested blocks
Each time the first column, the schema name, changes (including the first row) all of the HTML within the red area will print with the changed data. Then, when the second column, the table name, changes (including the first row), all of the HTML within the blue area will print with the changed data. Finally, when the each row changes (including the first row), the green area will print with the changed data.

At the end of each area the next row is examined. Depending on what column changed, control will return the the start of the appropriate area. If only a column name changed, for example, control will return to the top of the blue box. But if a schema name changed, for example, control will return to the top of the red box.


Copyright 2003 through 2009 A. Elein Mustain, Varlena, LLC