SATREPORT Definition Tags
S@
Home SATGUI SATSHELL SATFORM SATFILTER SATREPORT SATMYSQL License Download Examples Contact

<back> </back>Marks limits of back page definition.
<config> </config>Marks limits of configuration.
<data> </data>Marks limits of data format definition.
<footer> </footer>Marks limits of page/group footer defintion.
<front> </front>Marks limits of front page definition.
<group> </group>Marks limits of group definition.
<header> </header>Marks limits of page/group header definition.
<page> </page>Marks limits of page definition.


<back> </back>

The <back> tag marks the begining of the back page definition. The matching </back> tag marks the end of the back page definition.

Any of the predefined data items may be used on the back page. This can be useful to generate a summary/total page.

Example:

<back>
<b><u>REPORT SUMMARY:</u></b>


Total Employees: ${COUNT}
Total Salaries : ${SUM-salary}
</back>

Notes:


<config> </config>

The <config> tag marks the begining of the configuration. The matching </config> tag marks the end of the configuration.

The configuration is used to define report parameters, and must contain one line only.

Syntax: parameter=value parameter=value ...

There must be at least one space between each parameter/value pair. Spaces are not allowed either side of the "=" characters.

ParameterPossible ValuesDefault
dateformateu|gb|uk|us|textus
layoutlandscape|portraitlandscape
length1-99Landscape=36, Portrait=58
groupyes|nono
namesyes|noyes

Example:

<config>
dateformat=gb group=yes
</config>

Note:


<data> </data>

The <data> tag marks the begining of the data format definition. The matching </data> tag marks the end of the data format definition. Each data row from the input will be formatted using this definition.

Any of the variable/predefined data items may be used in the data format definition. The data format definition may be more than one line. This can be used, for example, by adding a blank line, to generate "double spaced" output.

Example:

<data>
%{name}<@ 35>${department}<$ 55:${salary}>
</data>

Note:


<footer> </footer>

The <footer> tag marks the begining of a group/page footer definition. The matching </footer> tag marks the end of the group/page footer definition.

If nested in a group definition, the footer is be invoked when the group changes. If nested in a page definition, the footer is invoked when the number of data rows for the current page reaches the defined length. This can be useful to print group/page summaries.

Using the "@" tag it is possible to position "footer" information anywhere on the current page.

Example:

<footer>
<@ 0:42>Page: ${PAGE} <@ 95>${DATE}
</footer>

Note:


<front> </front>

The <front> tag marks the begining of the front page definition. The matching </front> tag marks the end of the front page definition.

Only the DATE predefined data item may be used on the front page. This can be useful to provide a title/banner page for the report.

Example:

<front>

<font univers:18>EMPLOYEE SALARIES REPORT<size 12><@ 95>${DATE}

Details of all employee salaries by department.
</front>

Notes:


<group> </group>

The <group> tag marks the begining of the group definition. The matching </group> tag marks the end of the group definition.

The group definition must contain header/footer definitions only. Any text not in a header/footer definition is ignored.

Example:

<group>
<header>
<@ 80:0><b>Department:</b> %{GROUP}
</header>

<footer>
<@ 0:41>Department Employees: ${COUNT-GROUP}
Department Salary Total: ${SUM-GROUP-salary}
</footer>
</group>

Notes:


<header> </header>

The <header> tag marks the begining of a group/page header definition. The matching </header> tag marks the end of the group/page header definition.

If nested in a group definition, the header is be invoked when the group changes. If nested in a page definition, the header is invoked when the number of data rows for the current page reaches the defined length. This can be useful to print page title information and column headers.

Using the "@" tag it is possible to position "header" information anywhere on the current page.

Example:

<header>
<size 14><b>EMPLOYEE REPORT

<size 12><u>Name</u><@ 35><u>Department</u><@ 50><u>Salary</u></b>
</header>

Note:


<page> </page>

The <page> tag marks the begining of the page definition. The matching </page> tag marks the end of the page definition.

The page definition must contain header/footer/data definitions only. Any text not in a header/footer/data definition is ignored.

Example:

<page>
<header>
<size 14><b>EMPLOYEE REPORT

<size 12><u>Name</u><@ 35><u>Department</u><@ 50><u>Salary</u></b>
</header>

<data>
%{name}<@ 35>${department}<$ 55:${salary}>
</data>

<footer>
<@ 0:42>Page: ${PAGE} <@ 95>${DATE}
</footer>
</page>

Notes:


Copyright © 2003
Adrian Davis.